| Summary: | Inconsistent display and refresh of date formats FORMATTING / UI | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Douglas Crooke <douglas.crooke> |
| Component: | Calc | Assignee: | Eike Rathke <erack> |
| Status: | RESOLVED FIXED | ||
| Severity: | normal | CC: | oliver.brinzing |
| Priority: | medium | ||
| Version: | 5.1.3.2 release | ||
| Hardware: | All | ||
| OS: | All | ||
| See Also: | https://bugs.documentfoundation.org/show_bug.cgi?id=117715 | ||
| Whiteboard: | target:6.4.0 | ||
| Crash report or crash signature: | Regression By: | ||
| Attachments: |
New calc file with example copy/pasted into cells to demonstrate issue (on my machine at least)
Screen recording opening and viewing issue in test file result after fix |
||
|
Description
Douglas Crooke
2019-10-26 14:00:10 UTC
Created attachment 155326 [details]
New calc file with example copy/pasted into cells to demonstrate issue (on my machine at least)
When I open this file (after closing all Calc windows), first 4 date entries show as expected, the remaining entries show as cinancial/currency formatted numbers.
If I scroll down and then up, rows change displayed format except for row 6 whch remains in currency/financial format.
Note, I have been living with this issue for a while, only finally decided to report it after Ubuntu upgrade to 19.10 made no difference. Created attachment 155327 [details]
Screen recording opening and viewing issue in test file
Screen recording to illustrate observed behaviour on the test / example file. File opened, scrolled (when diplayed format changes), saved, entry changed which changes preceding formats.
*** This bug has been marked as a duplicate of bug 117715 *** Or rather, this is not exactly a duplicate and can be fixed independently. Best: do not apply the conditional formatting on column A. It might even be that conditional formatting's number format should always take precedence over manual/hard number format. See bug 117715#c10 The current "sometimes does, sometimes not" in this test case is of course wrong. Eike Rathke committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/4dfb22acfe30f9322ecc0ad9d01b17a3814c87a2 Related: tdf#117715 tdf#128403 Couple ATTR_LANGUAGE_FORMAT ATTR_VALUE_FORMAT It will be available in 6.4.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. Eike Rathke committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/f357831478ca063190eedeef12635117b8360277 Resolves: tdf#128403 Use ScPatternAttr::GetNumberFormat() It will be available in 6.4.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. So far fixed, but the actual behaviour what will take precedence will depend on the outcome of bug 117715. Created attachment 155338 [details] result after fix checked with: Version: 6.4.0.0.alpha1+ (x64) Build ID: b7735d9c705bdec53ddb0077b93ae70ce4c2df48 CPU threads: 12; OS: Windows 10.0 Build 18362; UI render: GL; VCL: win; Locale: de-DE (de_DE); UI-Language: en-US Calc: CL |