openoffice-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Donald McLean <donmclean...@dodo.com.au>
Subject FORMULA PROBLEMS READING EXCEL FILES
Date Thu, 24 Aug 2017 04:18:40 GMT
Hi, Good folks at Apache, I’m having trouble that a formula [ =IF(B1<0, "-",SUM(A1-B1))
] which works fine in Excel, translates as an Error 509 whatever that is. In trying to correct
it I find that Apache OneOffice on a Mac won’t process the maths concept < or > any
number, e.g. =IF ( b1<0, 3,4) won’t evaluate - I get the error ERROR 508. Can you please
help, Kind Regards Don McLean


Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message