At 04:15 08/09/2017 +0000, Mark Messiha wrote:
I have a client who uses Open office. I need to
use formula Edate to calculate some dates. When doing so, I get error 508.
The formula is as follows: =edate(r2, 9) or
=edate(r2, 12). Can anyone tell me why I get
error code 508 and what I can do to fix it?
OpenOffice uses a semicolon, not a comma, as a
parameter separator in spreadsheet formulae. Use
=EDATE(R2;9) and so on instead.
I have done the following:
· Uninstalled Open Office
· Rebooted my PC
· Run CCLeaner
· Rebooted my PC again
· Reinstalled the latest version of Open office
You could have read the Calc Manual, which says
"*Note* OOo uses the semicolon as an argument
list separator, unlike Excel which uses a comma.
This is a common mistake made by users accustomed to entering Excel formulas."
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
