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 "=<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.



--
Mike Scott
Harlow, Essex, England

--
To unsubscribe e-mail to: users+unsubscribe@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