Function in writer

[Pierrot]

Hello

I am using this in a table cell in Writer:

=if(<C1>=="A"; <B1>*5,5/100; 0)

which is about calculating a 5.5% rate on B1 if C1 contains the letter "A" (and I will expand this into using a 19.6 VAT rate if letter is B).
Doesn't seem to work altough

=SI(C1="A"; B1*5,5/100; 0) works in in the spreadsheet module ...

Any idea why ? is this something I am allowed to do in the Writer module ? If not, I couldn't guess how to add a spreadsheet table in a writer page ...

BTW, have been using v2alpha4 which seems so far to be extremely stable for me (G4 1.5ghz) ! Very good work !

Pierre

[OPENSTEP]

Dunno about formulas in writer tables, but you can insert a spreadsheet with "Insert > Object > OLE Object" and choose "Spreadsheet" from the dialog.

ed

[Guest]

Yep, that's working ! At least I can use that

But if anybody knows the answer for the writer module, I'd like to know, it's kind of faster that way !

Thks. Pierre.

[Guest]

Hello

After fumbling around quite sometime, I managed to do what I wanted in the writer. I had to use a few columns and replace my A's and B's by 1 and 2 because it seems that the "if" syntax does not exist in writer.
There are EQ (==) or NEQ (!=) tests, they just produce 0 or 1 (false or true) results and seems to work only on numbers (not strings).

Still, once working, it's easier and faster to use within the writer module (as opposed to creating a calc).

Pierre