https://bugs.freedesktop.org/show_bug.cgi?id=67221
Priority: medium
Bug ID: 67221
Assignee: libreoffice-bugs@lists.freedesktop.org
Summary: [FILESAVE] Saving xls file which has cell with formula
result #DIV/0! deleted formula, data loss
Severity: major
Classification: Unclassified
OS: Windows (All)
Reporter: mikeyy....@gmail.com
Hardware: Other
Status: NEW
Version: 4.1.0.3 rc
Component: Spreadsheet
Product: LibreOffice
Created attachment 82865
--> https://bugs.freedesktop.org/attachment.cgi?id=82865&action=edit
Test file
This is 100% reproducable from start, but to shorten explanation use attached
file.
1. Open file and position your self on cell D3 which is first cell with
formula.
2. Copy that cell formula to other cells by draging bottom right corner (or
copy/paste) to cells D4:D11.
3. Notice rows 6 and 8 which divide 0 by 0 (0/0 = error = #DIV/0!). Those cells
still have formula in them, but result is error since you can't divide 0 by 0.
4. Now save document as xls file and close LO.
5. Open document again and instead of #DIV/0! error you will now see Error: 512
and formula will be deleted, only = sign will be there...
This is regression.
Tested for ODS files also, no problems. Didn't test for xlsx.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
