Open Calc - Display problem Err508

fsmi Posted messages 7 Status Member -  
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
Configuration: Windows XP Firefox 3.0.1

7 answers

OOoForum Posted messages 3871 Registration date   Status Member Last intervention   965
 
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>
1
fsmi Posted messages 7 Status Member
 
My version of Open Office is 2.4 and the formula is as follows: =$BerM1.Z4
0