[libreoffice-users] writer: repeat a cell content (string) in a cell or in text
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 :-) pier -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] writer: repeat a cell content (string) in a cell or in text
At 14:45 21/07/2015 +0200, Pier Andreit wrote: 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 "=", 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 -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] writer: repeat a cell content (string) in a cell or in text
Hi all: I supoused that you can use "A1&"something" that you have in A2 (With out quotes) Regards, Jorge Rodríguez El mar, 21-07-2015 a las 14:41 +0100, Brian Barker escribió: > At 14:45 21/07/2015 +0200, Pier Andreit wrote: > >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 "=", 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 > > -- Atentamente, Jorge Rodríguez -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] writer: repeat a cell content (string) in a cell or in text
On 21/07/15 14:41, Brian Barker wrote: At 14:45 21/07/2015 +0200, Pier Andreit wrote: 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 "=", 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. -- Mike Scott Harlow, Essex, England -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] writer: repeat a cell content (string) in a cell or in text
At 15:45 21/07/2015 +0100, Mike Scott wrote: On 21/07/15 14:41, Brian Barker wrote: 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 -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] writer: repeat a cell content (string) in a cell or in text
On 21/07/15 20:48, Brian Barker wrote: At 15:45 21/07/2015 +0100, Mike Scott wrote: On 21/07/15 14:41, Brian Barker wrote: 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? -- Mike Scott Harlow, Essex, England -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] writer: repeat a cell content (string) in a cell or in text
On 07/22/2015 09:09 AM, Mike Scott wrote: I tried, but it is not so useful as I expected :-) ...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. On 21/07/15 20:48, Brian Barker wrote: At 15:45 21/07/2015 +0100, Mike Scott wrote: On 21/07/15 14:41, Brian Barker wrote: 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? -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] writer: repeat a cell content (string) in a cell or in text
At 16:48 22/07/2015 +0200, Pier Andreit wrote: I tried, but it is not so useful as I expected :-) ...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. 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 -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted