Issue 39995 - Error 508 encountered when opening MS Excel file to OpenOffice
Summary: Error 508 encountered when opening MS Excel file to OpenOffice
Status: CLOSED DUPLICATE of issue 39996
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 1.1.2
Hardware: Other Linux, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2005-01-06 05:48 UTC by zhred
Modified: 2005-01-13 16:44 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description zhred 2005-01-06 05:48:28 UTC 
I recently opened an MS Excel XP file using my OpenOffice 1.1.2 spreadsheet.  
An "Err:508" message appears on each cell that has a formula in it which is 
similar to this:

=IF($R4=H$3,"Qwest",IF($T4=H$3,"GX",IF($V4=H$3,"TNC",IF($X4=H$3,"Alpha",IF
($Z4=H$3,"ArcPhone",IF($AB4=H$3,"MindLab",IF($AF4=H$3,"Vinculum",IF
($AH4=H$3,"Sprint",""))))))))

The file opens perfectly when using an MS Excel XP spreadsheet.
Comment 1 abdul 2005-01-10 09:00:03 UTC 
Duplicte

*** This issue has been marked as a duplicate of 39996 ***
Comment 2 frank 2005-01-13 16:44:57 UTC 
Hi,

the only fault I can detect is the comma as parametere separator. If you change
it to a semicolon it will work fine in both Apps Excel and Calc.

Frank

PS Checked with OOo1.1.4 and OOo1.9.m69