<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Inconsistent display and refresh of date formats FORMATTING / UI"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=128403">128403</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Inconsistent display and refresh of date formats FORMATTING / UI
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.3.2.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>douglas.crooke@googlemail.com
</td>
</tr></table>
<p>
<div>
<pre>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:</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>