[Libreoffice-bugs] [Bug 127473] New: Regression: Formatting error using format "TT.MM.JJJJ HH:MM:SS, 000000000000000000"

[bugzilla-daemon at bugs.documentfoundation.org]

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 at lists.freedesktop.org
          Reporter: albrecht.mueller at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190910/65d953a0/attachment-0001.html>