https://bugs.documentfoundation.org/show_bug.cgi?id=120513
Bug ID: 120513
Summary: LibreOffice Calc warning message when opening an XLSX
file is misleading
Product: LibreOffice
Version: 6.2.0.0.alpha0+ Master
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
LibreOffice Calc offers the following options for reculation of XLSX files on
file load:
• Always recalculate
• Never recalculate
• Prompt user
If we set it to Prompt user, a dialog appears every time an XLSX file is opened
with the following message:
This document was last saved by Excel. Some formula cells may produce different
results when recalculated. Do you want to recalculate all formula cells now?
This message is misleading as it is displayed every time an XLSX file is opened
even when the file was created by and saved only with LibreOffice Calc. The
wording should be therefore something like that:
This document was saved in Excel 2007-2019 format (.xlsx). Some formula cells
may produce different results when recalculated. Do you want to recalculate all
formula cells now?
Steps to Reproduce:
1. Go to Tools > Options > LibreOffice Calc > Formula and select “Prompt user”
for “Excel 2007 and newer” under Recalculation on File Load.
2. Create a simple spreadsheet and save it as XLSX.
3. Reload the file by clicking on File > Reload.
Actual Results:
The following message appears:
This document was last saved by Excel. Some formula cells may produce different
results when recalculated. Do you want to recalculate all formula cells now?
Expected Results:
The message shouldn't say that the document was saved by Excel just because it
has XLSX extension. The message should be something like that:
This document was saved in Excel 2007-2019 format (.xlsx). Some formula cells
may produce different results when recalculated. Do you want to recalculate all
formula cells now?
Reproducible: Always
User Profile Reset: No
Additional Info:
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
