Open Calc - Display problem Err508
fsmi
Posted messages
7
Status
Member
-
irongege Posted messages 38993 Registration date Status Moderator Last intervention -
irongege Posted messages 38993 Registration date Status Moderator Last intervention -
Hello,
I have an Excel file provided by an administration that contains about twenty sheets, some of which are hidden with links and a lot of formulas. This file works very well with Excel, but when I try to open it in Open Office with Open Calc, some areas do not display correctly with the message ERR 508. Upon checking, it seems that there is no syntax problem...
Has anyone encountered this case before?
Thanks in advance
I have an Excel file provided by an administration that contains about twenty sheets, some of which are hidden with links and a lot of formulas. This file works very well with Excel, but when I try to open it in Open Office with Open Calc, some areas do not display correctly with the message ERR 508. Upon checking, it seems that there is no syntax problem...
Has anyone encountered this case before?
Thanks in advance
Configuration: Windows XP Firefox 3.0.1
7 answers
Without seeing anything from the formula and without even indicating the version of OpenOffice.org, it is difficult to respond.
Error 508 is due to a missing parenthesis.
--
<signature>Why hack MS-Office when there is a free solution? Use OpenOffice.org</signature>
Error 508 is due to a missing parenthesis.
--
<signature>Why hack MS-Office when there is a free solution? Use OpenOffice.org</signature>
fsmi
Posted messages
7
Status
Member
My version of Open Office is 2.4 and the formula is as follows: =$BerM1.Z4