Issue 116395 - Opening spreadsheet produces "BASIC runtime error 423 OperatingSystem"
Summary: Opening spreadsheet produces "BASIC runtime error 423 OperatingSystem"
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: programming (show other issues)
Version: OOo 3.2.1
Hardware: PC (x86_64) Linux, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: crash
Depends on:
Blocks:
 
Reported: 2011-01-10 15:11 UTC by blueh2o
Modified: 2013-12-13 14:03 UTC (History)
2 users (show)

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

Attachments
Example spreadsheet (212.00 KB, application/octet-stream)
2013-05-03 17:57 UTC, blueh2o 		no flags Details
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 blueh2o 2011-01-10 15:11:08 UTC 
OpenOffice does not seem to like these spreadsheets with BASIC code in them,
specifically the following statement:

  MacXL = (UCase(Left(Application.OperatingSystem, 3)) = "MAC")

Apparently "Application" does not have a property "OperatingSystem".. 

Some sheets in this file do not appear correctly and trying to delete them also
causes OpenOffice to crash entirely.
Comment 1 Edwin Sharp 2013-05-03 12:26:17 UTC 
Please attach example.
Comment 2 blueh2o 2013-05-03 17:57:59 UTC 
Created attachment 80635 [details]
Example spreadsheet
Comment 3 Edwin Sharp 2013-05-10 07:25:34 UTC 
Thank you and sorry for late reply.

Only Purchase Order sheet is visible in Excel 2010.
In Calc Rev. 1479897 also sample1, sample2, sample3 sheets are visible.
Deleting one of them causes a crash.
Comment 4 Edwin Sharp 2013-12-13 13:50:27 UTC 
No crash when delete sheets.

AOO410m1(Build:9750)  -  Rev. 1543812
Rev.1543812
Win 7
Comment 5 Edwin Sharp 2013-12-13 14:02:58 UTC 
Sorry. There is a crash.
Comment 6 Edwin Sharp 2013-12-13 14:03:11 UTC 
Confirmed.