Bug 149739 - General input/output error saving complex spreadsheet
Summary: General input/output error saving complex spreadsheet
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.4.0.0 beta1+
Hardware: All macOS (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Save
  Show dependency treegraph
 
Reported: 2022-06-27 01:41 UTC by Tim Daley
Modified: 2023-07-26 19:48 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
CensusUS1860-04.ods and required macro files. (987.18 KB, application/gzip)
2022-06-27 01:41 UTC, Tim Daley
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Tim Daley 2022-06-27 01:41:51 UTC
Created attachment 180977 [details]
CensusUS1860-04.ods and required macro files.

I have a spreadsheet with lots of complex calculations. If I replicate a set of columns and try to save it crashes. Here's how I reproduce the error:

1) Copy spreadsheet file from CensusUS1860-04.ods to CensusUS1860-08.ods
2) In the spreadsheet, copy the cells Q11:X14 to Q15
3) Save the spreadsheet. It should give the error message General input/output error.
4) If it doesn't fail, just keep copying, or copy Q11:X11 from Q12:Q50 and save.

The required functions are in the tar file user_basic_standard.tgz and should be untarred from the LibreOfficeDev folder which contains the user profile. In my case it is ~/Library/Application Support/LibreOfficeDev
Comment 1 Roman Kuznetsov 2022-08-06 16:14:32 UTC
Confirm the error in

Version: 7.5.0.0.alpha0+ / LibreOffice Community
Build ID: d75c5c1f61a174b3b333e9db6536ab15cc37d00b
CPU threads: 4; OS: Mac OS X 12.5; UI render: Skia/Raster; VCL: osx
Locale: ru-RU (ru_RU.UTF-8); UI: en-US
Calc: threaded Jumbo

Tim, how did you create the example? I see some user defined functions there but I don't see any macro in the file
Comment 2 QA Administrators 2023-02-03 03:22:30 UTC Comment hidden (obsolete)
Comment 3 Roman Kuznetsov 2023-02-03 10:10:40 UTC
Let's set it to NEW, but Timur would be nice if you answer