Bug 157389 - Conditional formats don't always apply to pasted cells
Summary: Conditional formats don't always apply to pasted cells
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.5.6.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-09-23 04:28 UTC by Lazarus
Modified: 2023-09-26 16:55 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
screenshot (1.98 KB, image/png)
2023-09-23 04:30 UTC, Lazarus
Details
sample file (6.15 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2023-09-23 04:31 UTC, Lazarus
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Lazarus 2023-09-23 04:28:37 UTC
Description:
Conditional formats are not applied to pasted cells. I've attached a screenshot and sample file. The two columns have identical conditional formats, but the first column's values were pasted in. The second column was entered manually. A2 and A3 should not be white. The format is text, but the conditional format still doesn't apply even if I change the format to number.

Steps to Reproduce:
1. Copy and paste cells
2. Apply ColorScale conditional format to column


Actual Results:
Some cells don't receive coloring

Expected Results:
Conditional format should apply to all cells in the column


Reproducible: Always


User Profile Reset: No

Additional Info:
Version: 7.6.1.2 (X86_64) / LibreOffice Community
Build ID: f5defcebd022c5bc36bbb79be232cb6926d8f674
CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded
Comment 1 Lazarus 2023-09-23 04:30:38 UTC
Created attachment 189767 [details]
screenshot
Comment 2 Lazarus 2023-09-23 04:31:36 UTC
Created attachment 189768 [details]
sample file
Comment 3 m_a_riosv 2023-09-23 15:23:13 UTC
Because in A2 and A3 you have numbers as text, no true numbers.
You can select column A, and use Menu/Data/Text to columns to have numbers.

You don't explain how you have pasted. Maybe you can get data pasted fine, usin paste special, unformatted text.
Comment 4 ady 2023-09-23 15:34:58 UTC
(In reply to Lazarus from comment #0)
> A2 and A3 should not be white. The format is text, but the
> conditional format still doesn't apply even if I change the format to number.

When you change the format from text to number, the content is ("almost") modified too; look at the input box (formula bar) and you will see an initial apostrophe before the number.

You are using color scale as conditional format; colors are applied according to a scale of numeric values.

You need to actually have numeric values (not numbers formatted as text) for a color scale conditional format to be correctly used.

Generally speaking, I would suggest using https://ask.libreoffice.org or the users mailing list in order to ask questions and to confirm whether there is really a bug to report.

This report should be considered either not a bug or invalid.
Comment 5 Lazarus 2023-09-25 05:32:08 UTC
Sorry, the confusion was from the input line not showing the apostrophe when the cell is formatted as text. Somehow the cell got formatted as text.
Comment 6 Lazarus 2023-09-26 09:00:15 UTC
I select a column and format it as number. But if I check one of the cells in the column why is it still formatted as text?
Comment 7 m_a_riosv 2023-09-26 16:55:23 UTC
(In reply to Lazarus from comment #6)
> I select a column and format it as number. But if I check one of the cells
> in the column why is it still formatted as text?

¿Está formateado como texto o tiene un número de texto?
Formatear como número no cambia el valor de cadena a número (nunca un cambio de formato cambia el valor), hazlo como se menciona en mi comentario 3.