https://bugs.freedesktop.org/show_bug.cgi?id=85448
Bug ID: 85448
Summary: Result formatted with 'clear direct formatting' gets
re-formmated after .ods save-load roundtrip
Product: LibreOffice
Version: 4.3.2.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Spreadsheet
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: cle...@gmail.com
Created attachment 108408
--> https://bugs.freedesktop.org/attachment.cgi?id=108408&action=edit
Spreadsheet with illustration of problem
Problem description:
When subtracting today() from a date the result is formatted as a date instead
of a normal number (of days between dates). The quickest way to change that to
a number is to remove the formatting with "clear direct formatting". After
saving and loading, the text is re-formatted as a date, instead of looking the
way it was when the document was saved.
Steps to reproduce:
1. put date into A1
2. put "=A1-today()" in B1
3. result in B1 should be formatted as date instead of integer
4. change to integer via "Format" -> "Clear direct formatting"
5. save document
6. load document
7. B1 contains the value formatted as a date, instead of integer
Current behavior: result is formatted as a date
Expected behavior: result is formatted the way it appeared when the document
was saved
--
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
