https://bugs.freedesktop.org/show_bug.cgi?id=81798
Priority: medium
Bug ID: 81798
Assignee: [email protected]
Summary: FILEOPEN: Doesn't respect flag to recalculate formula
upon loading.
Severity: normal
Classification: Unclassified
OS: Linux (All)
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 4.2.4.2 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 103526
--> https://bugs.freedesktop.org/attachment.cgi?id=103526&action=edit
A sample file that triggers the issue.
Problem description:
This is probably a simple issue for someone familiar with the codebase, but
XSLX files generated with Python module XlsxWriter
(http://xlsxwriter.readthedocs.org/) can contain formulas, but since the module
can't evaluate them, it simply sets 0 to the result and marks a global flag on
the file so the formulas will be recalculated upon loading. The issue is
explained under name "Formula results displaying as zero in non-Excel
applications" in the "Known Issues and Bugs" section of the documentation (
http://xlsxwriter.readthedocs.org/bugs.html ).
Steps to reproduce:
1. Load the attached file;
2. The value 0 will be displayed instead of the correct formula value.
Current behavior:
LibreOffice won't respect the flag to recalculate the formulas of XLSX files
upon loading, and shows the stored incorrect value instead.
Expected behavior:
LibreOffice should recalculate the formula when the flag on the file requests
it upon loading (Should it clear the flag when saving? Probably it should...)
Operating System: Ubuntu
Version: 4.2.4.2 release
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
