Re: Writer can't do arithmetic?

Paul <[email protected]>
Newsgroups gmane.comp.openoffice.questions
Message-ID <CAASwtFcFF-nM+SWLeBURMrRcyxetyDBRS4LZo73mfAA1DN-a7w@mail.gmail.com>
On Tue, Aug 30, 2011 at 5:52 AM, John Jason Jordan <[email protected]>wrote:

> On Mon, 29 Aug 2011 18:28:14 +0100
> [email protected] dijo:
>
> >In writer, it appears the cell references need to be surrounded in
> >angle brackets, i.e. for E use =(<D1>-<C1>)*B1 and for F use
> >=<B1>*<D1>. The sum() function is not needed in this case - it is
> >useful if you have a range of cells whose values you want to add, e.g.
> >=sum(<A1:A5>).
>
> The brackets! That was the secret that I was missing.
>
> Thanks!
>
> (And yes, there is a reason I am doing the table in a Writer document
> and not in Calc.)
>

There is probably a reason for using a writer table for these calculations
in writer, but you can insert a calc table into a writer document. This will
then enable all the functions of calc.

Just a thought.

/paul



> --
> -----------------------------------------------------------------
> To unsubscribe send email to [email protected]
> For additional commands send email to [email protected]
> with Subject: help
>
-- 
-----------------------------------------------------------------
To unsubscribe send email to [email protected]
For additional commands send email to [email protected]
with Subject: help
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.