https://bugs.documentfoundation.org/show_bug.cgi?id=127473
Bug ID: 127473
Summary: Regression: Formatting error using format "TT.MM.JJJJ
HH:MM:SS,000000000000000000"
Product: LibreOffice
Version: 6.0.4.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: minor
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: albrecht.muel...@astrail.de
Description: Using format "TT.MM.JJJJ HH:MM:SS,000000000000000000" values that
have a zero fractional part get formatted with fewer digits in the fractional
part than those whose fractional part is non-zero. Of course, using this kind
of format is not a common use case. I stumbled on this while analysing
round-off errors in the context of bug 127334.
How to reproduce:
- Open a new spreadsheet
- Make column A wide enough so it can display the formatted values
- Select column A, i.e. the cells A1:A1048576
- Set the number format of this cell range to "TT.MM.JJJJ
HH:MM:SS,000000000000000000"
- Fill the range with time values starting vom 10.9.2019 using a time increment
of 0.1 seconds. For this purpose open "Tabelle -> Zellen ausfüllen -> Reihen".
Set "Reihentyp" to "Linear", "Anfangswert" to "10.9.2019" and "Zunahme" to
"00:00:00,1". Press ok. It takes a few moments until the values will show up.
Actual behaviour: The representation of the values representing full seconds is
by three digits shorter than that of the other values when using version
6.2.6.2. If you use Version: 6.0.4.2 (x64) all representations use the same
length except that in cell A1 where the last three digits are replaced by
squares (probably indicating illegal characters).
Expected behaviour: The representation of all values should use the same number
of digits.
--
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