Bug 137222 - Wrong format of text in cell A81
Summary: Wrong format of text in cell A81
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.0.1.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Calc-Cells
  Show dependency treegraph
 
Reported: 2020-10-03 13:46 UTC by David
Modified: 2023-10-03 07:11 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
OpenGL Extensions Viewer report (227.94 KB, application/xml)
2020-10-03 13:49 UTC, David
Details
Spreadsheet containing error/bug (36.00 KB, application/octet-stream)
2020-10-03 15:24 UTC, David
Details
Output from MsInfo32.exe (1.05 MB, text/plain)
2020-10-03 15:26 UTC, David
Details
Conditional formatting on cell A81 (97.96 KB, image/png)
2023-10-03 07:11 UTC, Kira Tubo
Details

Note You need to log in before you can comment on or make changes to this bug.
Description David 2020-10-03 13:46:45 UTC
Description:
I think the best description is to send you whole ODS file and other related. You can download it here: https://uloz.to/file/EokT3zCoNndl/bugs-documentfoundation-org-2020-10-03-15-20-7z
And extract it by passvv0rd: 
D{^=41?->wsG


Steps to Reproduce:
1. copy cell A82 to A81.


Actual Results:
Value of cell A81 (text "Novaservis") is bigger, than in other cells (for example A82).

Expected Results:
Value of cell A81 will be exactly the same as in other cells (for example A82).


Reproducible: Always


User Profile Reset: No


OpenGL enabled: Yes

Additional Info:
Version: 7.0.1.2 (x64)
Build ID: 7cbcfc562f6eb6708b5ff7d7397325de9e764452
CPU threads: 4; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: Skia/Raster; VCL: win
Locale: en-GB (en_GB); UI: en-US
Calc: CL
Comment 1 David 2020-10-03 13:49:23 UTC
Created attachment 166051 [details]
OpenGL Extensions Viewer report
Comment 2 Eike Rathke 2020-10-03 14:27:20 UTC
Please attach the .ods file not-zipped and without password to this bug. Thanks.
Place additional description or material in this bug, or if needed screenshots in additional files attached, not some arbitrary file at some arbitrary download location even locked with a password.
Comment 3 David 2020-10-03 15:24:44 UTC
Created attachment 166052 [details]
Spreadsheet containing error/bug

In meantime I tried resetting my UserProfile. Unfortunatelly without success.
Comment 4 David 2020-10-03 15:26:15 UTC
Created attachment 166053 [details]
Output from MsInfo32.exe

Configuration of my computer.
Comment 5 Xavier Van Wijmeersch 2020-10-04 12:18:36 UTC
can reproduce with

Version: 7.1.0.0.alpha0+
Build ID: 9554ca530a488fcbe922858436d36f324feb1212
CPU threads: 8; OS: Linux 5.4; UI render: default; VCL: gtk3
Locale: nl-BE (en_US.UTF-8); UI: en-US
Calc: threaded
Comment 6 QA Administrators 2022-10-06 04:10:11 UTC Comment hidden (obsolete)
Comment 7 Aaron 2023-08-18 00:23:17 UTC
The bug is still present in

Version: 7.5.5.2 (X86_64) / LibreOffice Community
Build ID: ca8fe7424262805f223b9a2334bc7181abbcbf5e
CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: en-AU (fr_FR); UI: en-US
Calc: threaded

This is quite a strange bug. After a bit of testing I noticed that typing the word 'Novaservis' into A81 produces the bug. Also copying from certain cells do not produce the bug. For example, copying from A73 produces the bug but copying from A72 does not. The behaviour is very inconsistent.
Comment 8 Kira Tubo 2023-10-03 07:11:02 UTC
Created attachment 189967 [details]
Conditional formatting on cell A81

@David, it looks like there is a Conditional Formatting set on A81 (see attachment), which is using the WEEKDAY formula to set the cell style to Heading. It seems to be interpreting the value in B81 as a date: "55014". I am not entirely certain if interpreting numbers as a date is a bug. Someone more knowledgeable in Calc will have to comment. 

In any case, deleting the Conditional Formatting removed the formatting so that it matches the rest of the cells. OR, you'll also see the formatting change to match the rest of the cells when you delete the data in B81.