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