https://bugs.documentfoundation.org/show_bug.cgi?id=118850
Bug ID: 118850
Summary: Custom time format changes to default upon load
Product: LibreOffice
Version: 5.1.1.3 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: stephan.sot...@bistum-wuerzburg.de
Description:
Certain custom time/number formats get changed to another format upon loading
the document. Happens when the document was saved with any version up to 5.0
and opened with any version 5.1 or higher (or vice versa).
Steps to Reproduce:
1. Enter 0,333333 in a cell (any value works, really but there has to be a
value)
2. Define this custom format: H:MM;@ for the cell
3. Save the document in any LO 5.0 Version or lower
4. Reopen it with LO 5.1 or higher
Actual Results:
Cells that contain values that have this format applied are changed to standard
number format. You can find and reapply the custom format in the list.
Afterwards it works fine.
Curiously empty cells are not affected - probably no validity check upon
loading?
Expected Results:
Keeping the correct time format for all cells.
Reproducible: Always
User Profile Reset: No
Additional Info:
Doesn't happen with all custom formats; apparently just ones that defy the
intended logic of the formatting code rules. In the example H:MM;@ I'm not sure
about the intended function of the @ part is. It doesn't seem to change
behavior skipping the @. And H:MM as a custom format doesn't show the
problematic behavior. But anyway that's what the user entered and thus had his
documents misformatted when we changed to LO 5.2.7
Anyway, it's inconsistent when the program functions normally upon entering the
number format, but at the same time recognizes it as invalid and from v5.1 on
decides to silently "correct the error" when it actually has the capability to
apply it correctly.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs