Issue 116395 - Opening spreadsheet produces "BASIC runtime error 423 OperatingSystem"
Summary: Opening spreadsheet produces "BASIC runtime error 423 OperatingSystem"
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:
Keywords: crash
Depends on:
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: ---

Example spreadsheet (212.00 KB, application/octet-stream)
2013-05-03 17:57 UTC, blueh2o
no flags Details

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
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