https://bugs.freedesktop.org/show_bug.cgi?id=86737
Bug ID: 86737
Summary: Wrong precaculated values in OOo calc sheet not
reevaluated
Product: LibreOffice
Version: 4.1.6.2 release
Hardware: x86 (IA32)
OS: Linux (All)
Status: UNCONFIRMED
Severity: major
Priority: medium
Component: Spreadsheet
Assignee: [email protected]
Reporter: [email protected]
Created attachment 110054
--> https://bugs.freedesktop.org/attachment.cgi?id=110054&action=edit
HR department calc sheet
The attached document is a complex calc sheet used in our HR department.
>From my investigation and kendys commends, it seems at least OOo 3.2.1 has been
writing wrong cached values, as there are some xml arguments of:
office:date-value="1899-12-30"
in the document.
As it's in German and was possibly generated using an even older OOo version,
just a usage howto:
1. Open the document.
2. Locate the wrong date in the lower right corner of the first sheet:
"12/30/1899"
3. Locate the date the calculation is base on in the middle of the first sheet:
"Stufenlaufzeit ab" "10/01/2013" and change it to force reevaluation.
After recalculation the sheet is correct.
--
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
