Hi Javier,
javier wrote:
I'm stuck with quite a stupid question.
I'm working in writer with a table with calculations. I wan't a cell to display a value only if it's positive and 0 when the value is negative. In calc, this formula work all right:
=IF(A1>A2;A1-A2;0)
but in writer
=IF(<A1>><A2>;<A1>-<A2>;0)
doesn't work. It always return the failed result (0). And the reverse condition <A1><<A2> can't be checked (it returns an error, probably it sees the "<" sign as the start of a cell reference).
Any idea of a workaround? Should I file an Issue?.
You can make the table in Calc. Copy and past it in writer. It becomes an object. Doubleclick on it, and you can edit what you want.
Kind regards,
Cor
-- Cor Nouws www.nouenoff.nl
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
