https://bugs.documentfoundation.org/show_bug.cgi?id=151560

            Bug ID: 151560
           Summary: Calc crashes when loading a previously saved document
                    which has cells with "#" values
           Product: LibreOffice
           Version: 7.3.6.2 release
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: [email protected]
          Reporter: [email protected]

Description:
I edited a perfectly fine spreadsheet by removing a lot of stuff. Because of
that, some references broke, causing some cells to have values like "#WERT!" or
"NAME?" (using German locale). I saved this spreadsheet and closed LibreOffice.
Later, I tried to open the spreadsheet again, but LibreOffice crashed. When
starting from the terminal, the following error message is printed:

/usr/include/c++/12.2.0/optional:484: constexpr const _Tp&
std::_Optional_base_impl<_Tp, _Dp>::_M_get() const [with _Tp = rtl::OUString;
_Dp = std::_Optional_base<rtl::OUString, false, false>]: Assertion
'this->_M_is_engaged()' failed.

I cannot share the original document or the I edited due to sensitive data, but
I used a text editor to remove stuff until I had a version of the document I
could open again. When I open this skeleton document, save it, close
LibreOffice and open the file again, the crash is back.

Calc can open the document again after replacing all "#" values with a text
editor (removing the #).

Starting LibreOffice in safe-mode did not help.

Keywords: EDITING FILEOPEN FILESAVE

Steps to Reproduce:
1. Open the attached example spreadsheet. It should open fine.
2. Save the spreadsheet without editing anything.
3. Close LibreOffice.
4. Open the file again. LibreOffice crashes.
5. Use a text editor to remove all occurrences of the "#" symbol.
6. Open the file once more. It loads again.
7. When saving the spreadsheet again, LibreOffice is again unable to load it.

Actual Results:
LibreOffice crashes when loading a version of the spreadsheet that contains "#"
cell values.

Expected Results:
LibreOffice openes the spreadsheet without crashing.


Reproducible: Always


User Profile Reset: No


OpenGL enabled: Yes

Additional Info:
Version: 7.3.6.2 / LibreOffice Community
Build ID: 30(Build:2)
CPU threads: 4; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: de-DE (de_DE.UTF-8); UI: de-DE
7.3.6-3
Calc: CL

Running Arch Linux, LTS kernel 5.15.71-1

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to