https://bugs.documentfoundation.org/show_bug.cgi?id=170654
Bug ID: 170654
Summary: Some cells display background colours when they should
be white, and some cells contain #N/A when they should
be blank
Product: LibreOffice
Version: 26.2.0.3 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Having entered some data into my spreadsheet, some cells turn purple, when they
should have a white background. See column I on Balances tab of my
spreadsheet, rows 7 to 16. Also, Cells in rows 12 and onwards in column K and
onwards on the SO & DDs tab on the same spreadsheet turns purple if numbers are
entered, but go white if the numbers are removed..
Some others display #N/A when they should be blank. See column I on the SO &
DDs tab on the same spreadsheet,on rows where there is no data in column B.
Steps to Reproduce:
1. Load spreadsheet and look at tabs called Balances and SO & DDs
2. Note the presence of the rogue purple colour and, on the latter tab, #N/A
in column I
3. Delete or add data and see the purple go and return.
Actual Results:
Having populated fields on tabs Main Menu and Assets, I note that column I,
lines 7 to 16 are purple, when they should have a white background.
Having started to populate tab SO & DDs, I see that #N/A appears in column
I,lines 12 onwards, except if I enter data in column B. As soon as I enter
data in columns K onwards, the cells turn purple.
Expected Results:
None of those cells should have a purple background.
Cells in Column I of the SO & DDs tab should be blank, unless column H of that
row has data, (in which case that row's column I auto-fills in with a
description.
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 26.2.0.3 (X86_64)
Environment: CPU threads: 8; OS: Windows 11 X86-64
(build 26100)
User Interface: UI render: Skia/Raster; VCL: win
Locale: en-GB (en-GB); UI: en-GB
Misc: Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
