writer: repeat a cell content (string) in a cell or in text

users
#1

I would like to do in writer (tables or text) as in calc, if in cell A1 I have “something” and in cell A2 I insert “=A1” in cell A2 I'll have “something”

I tried with formulas but didn't succeed.
it seems that they treat only numbers...
any suggestion???

manythanks, ciao :slight_smile: pier

#2

I would like to do in writer (tables or text) as in calc, if in cell A1 I have "something" and in cell A2 I insert "=A1" in cell A2 I'll have "something"

The syntax would be "=<A1>", I think.

I tried with formulas but didn't succeed. it seems that they treat only numbers...

It seems so.

any suggestion?

Yes: create what you need in a spreadsheet and copy and paste the required cell range into your text document. It will appear as a table but will function like the spreadsheet section that it is.

I trust this helps.

Brian Barker

#3

Hi all:

  I supoused that you can use "A1&"something" that you have in A2 (With
out quotes)

Regards,

Jorge Rodríguez

#4

I would like to do in writer (tables or text) as in calc, if in cell
A1 I have "something" and in cell A2 I insert "=A1" in cell A2 I'll
have "something"

The syntax would be "=<A1>", I think.

I tried with formulas but didn't succeed. it seems that they treat
only numbers...

It seems so.

Breaking the principle of least surprise, it seems "tables" in Writer only do arithmetic.

any suggestion?

Yes: create what you need in a spreadsheet and copy and paste the
required cell range into your text document. It will appear as a table
but will function like the spreadsheet section that it is.

I trust this helps.

Brian Barker

Or embed a spreadsheet object: Insert | Object | OLE Object and pick spreadsheet, then fill it in. Then you get most (all?) of the facilities you'd expect. Double-click to open the spreadsheet object for editing.

Referring back to my recent comments, this really should be the default action for anything table-like. IMO.

#5

Yes: create what you need in a spreadsheet and copy and paste the required cell range into your text document. It will appear as a table but will function like the spreadsheet section that it is.

Or embed a spreadsheet object: Insert | Object | OLE Object and pick spreadsheet, then fill it in. Then you get most (all?) of the facilities you'd expect. Double-click to open the spreadsheet object for editing.

There's no "Or" about it: isn't that just a complicated way to achieve the same thing?

Referring back to my recent comments, this really should be the default action for anything table-like.

Er, I think it is ...

Brian Barker

#6

Yes: create what you need in a spreadsheet and copy and paste the
required cell range into your text document. It will appear as a
table but will function like the spreadsheet section that it is.

Or embed a spreadsheet object: Insert | Object | OLE Object and pick
spreadsheet, then fill it in. Then you get most (all?) of the
facilities you'd expect. Double-click to open the spreadsheet object
for editing.

There's no "Or" about it: isn't that just a complicated way to achieve
the same thing?

Looking again, yes the same thing; sorry. More complicated though? - I'm not sure: one way you need a separate Calc window open, the other way you work directly within the Writer window alone.

Referring back to my recent comments, this really should be the
default action for anything table-like.

Er, I think it is ...

I was trying (badly) to make the point that there should ideally be no such thing as Writer's own table construct. IMO of course. It adds nothing but confusion when a Calc object can be embedded instead. Why does Writer need to have it's own sort of table, especially one so restricted in facilities and with a rather different usage from Calc?

#7

I tried, but it is not so useful as I expected :slight_smile:
...I was thinking about to use insert>field...
if I can have custom field to insert...

the aim is to have ONE information, in a cell or elsewhere, repeated in the document as many times as I like, and when I change this information (in the cell or elsewhere is it but ONE time) this is updated in the whole document.

#8

o Go to Insert | Fields > | Other... (or Ctrl+F2).
o Select "Set variable" and give your variable a name.
o Under Format, select Text and enter your original value for Value.
o If you prefer, you can suppress the appearance of your text at this point in the document by ticking Invisible.
o Insert.
o Close.

Each time you need to insert the text:
o Go to Insert | Fields > | Other... (or Ctrl+F2).
o Select "Show variable" and your named variable.
o Insert.
o Close.

When you need to change the text:
o Put the cursor just to the left of the *original* field. (If you chose "Invisible", this will be a small, apparently empty field shading.)
o Go to Edit | Fields... (or right-click | Fields...).
o Select your named variable.
o Modify the text under Value.
o OK.

Voilà!

There is no particular need for this value to be in a table cell where it appears.

I trust this helps.

Brian Barker