Bug 164119 - Crash when openeing complex spreadsheet
Summary: Crash when openeing complex spreadsheet
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
24.8.3.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Pivot-Table
  Show dependency treegraph
 
Reported: 2024-12-01 21:44 UTC by lance
Modified: 2024-12-02 04:40 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Workbook with pivot tables (6.18 MB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2024-12-01 22:45 UTC, lance
Details
Workbook without pivot tables (6.13 MB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2024-12-01 22:46 UTC, lance
Details

Note You need to log in before you can comment on or make changes to this bug.
Description lance 2024-12-01 21:44:41 UTC
Description:
When I try to open my accounting spreadsheet it crashes with a "General input output error". Previous version of calc had no problem opening the file, although the pivot tables never worked correctly in Libre Calc compared to Excel.

Steps to Reproduce:
1. Open Libre Office or calc
2. Open the file
3. Boom

Actual Results:
Crash with General input output error and app closes.

Expected Results:
File should open cleanly


Reproducible: Always


User Profile Reset: No

Additional Info:
Version: 24.8.3.2 (X86_64) / LibreOffice Community
Build ID: 48a6bac9e7e268aeb4c3483fcf825c94556d9f92
CPU threads: 8; OS: Windows 10 X86_64 (10.0 build 19045); UI render: Skia/Vulkan; VCL: win
Locale: en-AU (en_AU); UI: en-US
Calc: CL threaded
Comment 1 Marina Latini (SUSE) 2024-12-01 22:19:04 UTC
Could you try to open LibreOffice in safe mode and see if LibreOffice crashes again?

Is it possible to have a sample file where the crash is still happening? 
Please, note that the attached files on bugzilla are public. Do NOT upload the accounting file with the data, but if possible, upload a version of it without sensitive data but that still crashes.
Comment 2 lance 2024-12-01 22:34:14 UTC
Still crashes in safe mode.
Comment 3 lance 2024-12-01 22:45:53 UTC
Created attachment 197892 [details]
Workbook with pivot tables

This is the file that crashes Calc.
Comment 4 lance 2024-12-01 22:46:35 UTC
Created attachment 197893 [details]
Workbook without pivot tables

This file opens ok in Calc
Comment 5 lance 2024-12-01 22:48:15 UTC
Workbook without pivot tables opens ok, so it's an issue with pivot tables. Note that pivot tables in this workbook have never worked correctly in Calc, it always broke the tables on data update, whereas they always work fine in Excel.
Comment 6 Marina Latini (SUSE) 2024-12-02 00:19:56 UTC
* Can't repro in all the bibisect-linux-64-24.2 repo

* Can't repro on:
Version: 6.0.6.0.0+
Build ID: c6c82096301180cfa7942dd9fb9d1cb66c7ecc04
CPU threads: 20; OS: Linux 5.14; UI render: default; VCL: gtk3; 
Locale: en-US (en_US.UTF-8); Calc: group

* can't repro on:
Version: 7.6.3.2 (X86_64) / LibreOffice Community
Build ID: 29d686fea9f6705b262d369fede658f824154cc0
CPU threads: 20; OS: Linux 5.14; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded

* Can repro on:
Version: 24.8.3.2 (X86_64) / LibreOffice Community
Build ID: 480(Build:2)
CPU threads: 20; OS: Linux 5.14; UI render: default; VCL: kf5 (cairo+xcb)
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded

* Can repro in all the bibisect-linux-64-25.2 repo

On the terminal I get:
---------------
warn:vcl:30106:30106:vcl/source/image/ImplImage.cxx:102: Failed to load scaled image from cmd/sc_signaturesmenu.png at 1
warn:vcl:30106:30106:vcl/source/image/ImplImage.cxx:126: Failed to load stock icon cmd/sc_signaturesmenu.png
warn:sfx.dialog:30106:30106:sfx2/source/dialog/filtergrouping.cxx:357: already have an element for WordPerfect
warn:sfx.dialog:30106:30106:sfx2/source/dialog/filtergrouping.cxx:357: already have an element for writerweb8_writer_template
warn:sfx.dialog:30106:30106:sfx2/source/dialog/filtergrouping.cxx:357: already have an element for writerglobal8
kf.kio.filewidgets.kfilefiltercombo: Could not find filter "*|All files"
warn:sc:30106:30106:sc/source/filter/oox/formulabase.cxx:1381: OpCodeProviderImpl::initFuncOpCode - no opcode mapping for function ODF 'ORG.OPENOFFICE.EASTERSUNDAY' <-> OOXML '_xlfn.ORG.OPENOFFICE.EASTERSUNDAY'
warn:sc:30106:30106:sc/source/filter/oox/formulabase.cxx:1381: OpCodeProviderImpl::initFuncOpCode - no opcode mapping for function ODF 'ORG.OPENOFFICE.EASTERSUNDAY' <-> OOXML 'EASTERSUNDAY'
warn:legacy.osl:30106:30106:sc/source/filter/oox/formulabase.cxx:1244: OpCodeProviderImpl::OpCodeProviderImpl - opcodes not initialized
warn:xmloff:30106:30106:sax/source/fastparser/fastparser.cxx:1233: unknown attribute revIDLastSave=0
warn:xmloff:30106:30106:sax/source/fastparser/fastparser.cxx:1233: unknown attribute documentId=13_ncr:1_{1E7EC74D-E190-4498-85FA-DB8799F6D081}
warn:xmloff:30106:30176:sax/source/fastparser/fastparser.cxx:1233: unknown attribute defaultSlicerStyle=SlicerStyleLight1
warn:xmloff:30106:30176:sax/source/fastparser/fastparser.cxx:1233: unknown attribute defaultTimelineStyle=TimeSlicerStyleLight1
warn:sc:30106:30180:sc/source/filter/oox/formulabase.cxx:1381: OpCodeProviderImpl::initFuncOpCode - no opcode mapping for function ODF 'ORG.OPENOFFICE.EASTERSUNDAY' <-> OOXML '_xlfn.ORG.OPENOFFICE.EASTERSUNDAY'
warn:sc:30106:30180:sc/source/filter/oox/formulabase.cxx:1381: OpCodeProviderImpl::initFuncOpCode - no opcode mapping for function ODF 'ORG.OPENOFFICE.EASTERSUNDAY' <-> OOXML 'EASTERSUNDAY'
warn:legacy.osl:30106:30180:sc/source/filter/oox/formulabase.cxx:1244: OpCodeProviderImpl::OpCodeProviderImpl - opcodes not initialized
warn:xmloff:30106:30182:sax/source/fastparser/fastparser.cxx:1233: unknown attribute hideValuesRow=1
warn:sc:30106:30183:sc/source/filter/oox/formulabase.cxx:1381: OpCodeProviderImpl::initFuncOpCode - no opcode mapping for function ODF 'ORG.OPENOFFICE.EASTERSUNDAY' <-> OOXML '_xlfn.ORG.OPENOFFICE.EASTERSUNDAY'
warn:sc:30106:30183:sc/source/filter/oox/formulabase.cxx:1381: OpCodeProviderImpl::initFuncOpCode - no opcode mapping for function ODF 'ORG.OPENOFFICE.EASTERSUNDAY' <-> OOXML 'EASTERSUNDAY'
warn:legacy.osl:30106:30183:sc/source/filter/oox/formulabase.cxx:1244: OpCodeProviderImpl::OpCodeProviderImpl - opcodes not initialized
warn:sc:30106:30184:sc/source/filter/oox/formulabase.cxx:1381: OpCodeProviderImpl::initFuncOpCode - no opcode mapping for function ODF 'ORG.OPENOFFICE.EASTERSUNDAY' <-> OOXML '_xlfn.ORG.OPENOFFICE.EASTERSUNDAY'
warn:sc:30106:30184:sc/source/filter/oox/formulabase.cxx:1381: OpCodeProviderImpl::initFuncOpCode - no opcode mapping for function ODF 'ORG.OPENOFFICE.EASTERSUNDAY' <-> OOXML 'EASTERSUNDAY'
warn:legacy.osl:30106:30184:sc/source/filter/oox/formulabase.cxx:1244: OpCodeProviderImpl::OpCodeProviderImpl - opcodes not initialized
warn:sc:30106:30185:sc/source/filter/oox/formulabase.cxx:1381: OpCodeProviderImpl::initFuncOpCode - no opcode mapping for function ODF 'ORG.OPENOFFICE.EASTERSUNDAY' <-> OOXML '_xlfn.ORG.OPENOFFICE.EASTERSUNDAY'
warn:sc:30106:30185:sc/source/filter/oox/formulabase.cxx:1381: OpCodeProviderImpl::initFuncOpCode - no opcode mapping for function ODF 'ORG.OPENOFFICE.EASTERSUNDAY' <-> OOXML 'EASTERSUNDAY'
warn:xmloff:30106:30182:sax/source/fastparser/fastparser.cxx:1233: unknown attribute hideValuesRow=1
warn:legacy.osl:30106:30185:sc/source/filter/oox/formulabase.cxx:1244: OpCodeProviderImpl::OpCodeProviderImpl - opcodes not initialized
warn:sc:30106:30181:sc/source/filter/oox/formulabase.cxx:1381: OpCodeProviderImpl::initFuncOpCode - no opcode mapping for function ODF 'ORG.OPENOFFICE.EASTERSUNDAY' <-> OOXML '_xlfn.ORG.OPENOFFICE.EASTERSUNDAY'
warn:sc:30106:30181:sc/source/filter/oox/formulabase.cxx:1381: OpCodeProviderImpl::initFuncOpCode - no opcode mapping for function ODF 'ORG.OPENOFFICE.EASTERSUNDAY' <-> OOXML 'EASTERSUNDAY'
warn:legacy.osl:30106:30181:sc/source/filter/oox/formulabase.cxx:1244: OpCodeProviderImpl::OpCodeProviderImpl - opcodes not initialized
warn:sc:30106:30179:sc/source/filter/oox/formulabase.cxx:1381: OpCodeProviderImpl::initFuncOpCode - no opcode mapping for function ODF 'ORG.OPENOFFICE.EASTERSUNDAY' <-> OOXML '_xlfn.ORG.OPENOFFICE.EASTERSUNDAY'
warn:sc:30106:30179:sc/source/filter/oox/formulabase.cxx:1381: OpCodeProviderImpl::initFuncOpCode - no opcode mapping for function ODF 'ORG.OPENOFFICE.EASTERSUNDAY' <-> OOXML 'EASTERSUNDAY'
warn:legacy.osl:30106:30179:sc/source/filter/oox/formulabase.cxx:1244: OpCodeProviderImpl::OpCodeProviderImpl - opcodes not initialized
warn:xmloff:30106:30182:sax/source/fastparser/fastparser.cxx:1233: unknown attribute hideValuesRow=1
warn:sc:30106:30177:sc/source/filter/oox/formulabase.cxx:1381: OpCodeProviderImpl::initFuncOpCode - no opcode mapping for function ODF 'ORG.OPENOFFICE.EASTERSUNDAY' <-> OOXML '_xlfn.ORG.OPENOFFICE.EASTERSUNDAY'
warn:sc:30106:30177:sc/source/filter/oox/formulabase.cxx:1381: OpCodeProviderImpl::initFuncOpCode - no opcode mapping for function ODF 'ORG.OPENOFFICE.EASTERSUNDAY' <-> OOXML 'EASTERSUNDAY'
warn:legacy.osl:30106:30177:sc/source/filter/oox/formulabase.cxx:1244: OpCodeProviderImpl::OpCodeProviderImpl - opcodes not initialized
warn:sc:30106:30178:sc/source/filter/oox/formulabase.cxx:1381: OpCodeProviderImpl::initFuncOpCode - no opcode mapping for function ODF 'ORG.OPENOFFICE.EASTERSUNDAY' <-> OOXML '_xlfn.ORG.OPENOFFICE.EASTERSUNDAY'
warn:sc:30106:30178:sc/source/filter/oox/formulabase.cxx:1381: OpCodeProviderImpl::initFuncOpCode - no opcode mapping for function ODF 'ORG.OPENOFFICE.EASTERSUNDAY' <-> OOXML 'EASTERSUNDAY'
warn:legacy.osl:30106:30178:sc/source/filter/oox/formulabase.cxx:1244: OpCodeProviderImpl::OpCodeProviderImpl - opcodes not initialized
warn:sc:30106:30182:sc/source/filter/oox/formulabase.cxx:1381: OpCodeProviderImpl::initFuncOpCode - no opcode mapping for function ODF 'ORG.OPENOFFICE.EASTERSUNDAY' <-> OOXML '_xlfn.ORG.OPENOFFICE.EASTERSUNDAY'
warn:sc:30106:30182:sc/source/filter/oox/formulabase.cxx:1381: OpCodeProviderImpl::initFuncOpCode - no opcode mapping for function ODF 'ORG.OPENOFFICE.EASTERSUNDAY' <-> OOXML 'EASTERSUNDAY'
warn:legacy.osl:30106:30182:sc/source/filter/oox/formulabase.cxx:1244: OpCodeProviderImpl::OpCodeProviderImpl - opcodes not initialized
warn:sc.core:30106:30106:sc/source/core/data/dptabsrc.cxx:2580: ScDPMember::GetItemData: what data? nDim 7, mnDataId 0
warn:sc.core:30106:30106:sc/source/core/data/dptabsrc.cxx:2580: ScDPMember::GetItemData: what data? nDim 7, mnDataId 0
warn:sc.core:30106:30106:sc/source/core/data/dptabsrc.cxx:2580: ScDPMember::GetItemData: what data? nDim 7, mnDataId 0
warn:sc.core:30106:30106:sc/source/core/data/dptabsrc.cxx:2580: ScDPMember::GetItemData
---------------