https://bugs.documentfoundation.org/show_bug.cgi?id=164601
Bug ID: 164601
Summary: Hard Recalculate produces unexpected result, different
to Excel
Product: LibreOffice
Version: 24.2.5.2 release
Hardware: Other
OS: macOS (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Work with Calc on a specific .xlsm file, macroes disabled.
Perform a hard recalculate.
After that, a drop-down list is destroyed.
Doing the same in Excel, the drop-down list is unchanged.
Steps to Reproduce:
1.Open file "Anlage 2.7.3 Risikoanalyse Informationssicherheit.xlsm" from the
appendix with Calc. Choose Macroes deactivate.
2. Check in Table "II.b Schutzbedarf", field E9 ("customer inquiries"). There
is a drop-down list.
3. Do (I have a German version) "Daten", "Berechnen", "Unbedingte
Neuberechnung".
4. Check field E9 once again: The drop-down list is destroyed.
5. So far, it might be a feature, not a bug. But if you do the same in Excel,
the drop-down list is still valid after step 3.. And the programmer did not
intend to change drop-down lists by recalculation operations.
Actual Results:
see "Steps to Reproduce"
Expected Results:
see "Steps to Reproduce"
Reproducible: Always
User Profile Reset: Yes
Additional Info:
see "Steps to Reproduce"
--
You are receiving this mail because:
You are the assignee for the bug.
