[Libreoffice-bugs] [Bug 128403] New: Inconsistent display and refresh of date formats FORMATTING / UI

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=128403

            Bug ID: 128403
           Summary: Inconsistent display and refresh of date formats
                    FORMATTING / UI
           Product: LibreOffice
           Version: 6.3.2.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: douglas.crooke at googlemail.com

Description:
Observed using file with conditional formatting applied based on date in Column
A.  The date should appear in a date format, but sometimes displays as a
financial format.  This is not consistently displayed, and can change if the
display of the cells is refreshed by scrolling off/on screen, or by a file
save.
I also observe that the incorrect financial format seems to 'stick' to cells
with a thick lower border defined on them.  Should be visible in attached
spreadsheet, which was created by copy/pasting ing a small section of my
personal accounts spreadsheet into a new file and removing all data except
dates.
  The conditional format setup may be ambiguous as its is applied across
multiple columns with date, test and number (financial) entries.

Steps to Reproduce:
1.Apply formatting combination to new spreadsheet
2.Open and / or save and dates are reformatted as financial numbers
3.Displayed format changes on refresh of screen (scroll on and off screen and
displayed format changes
4. On save, some formats displayed change
5. Cells with border formatting seem to 'stick' at the financial format


Actual Results:
Copy existing format to new spreadsheet.  Dates shown in column display
inconsistently, and can change when refeshed by scrolling them on and off
screen.

Expected Results:
All entries in column A display as a Date format (e.g. Fri 2 Aug 19)


Reproducible: Sometimes


User Profile Reset: No


OpenGL enabled: Yes

Additional Info:
Version: 6.3.2.2
Build ID: 1:6.3.2-0ubuntu2
CPU threads: 4; OS: Linux 5.3; UI render: default; VCL: gtk3; 
Locale: en-GB (en_GB.UTF-8); UI-Language: en-US
Calc: threaded

OpenGL vendor string: Intel Open Source Technology Center
OpenGL renderer string: Mesa DRI Intel(R) Sandybridge Mobile 
OpenGL core profile version string: 3.3 (Core Profile) Mesa 19.2.1
OpenGL core profile shading language version string: 3.30
OpenGL core profile context flags: (none)
OpenGL core profile profile mask: core profile
OpenGL core profile extensions:
OpenGL version string: 3.0 Mesa 19.2.1
OpenGL shading language version string: 1.30
OpenGL context flags: (none)
OpenGL extensions:
OpenGL ES profile version string: OpenGL ES 3.0 Mesa 19.2.1
OpenGL ES profile shading language version string: OpenGL ES GLSL ES 3.00
OpenGL ES profile extensions:

-- 
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/20191026/bf26a2e7/attachment.html>