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
Created attachment 189767 [details] screenshot
Created attachment 189768 [details] sample file
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.
(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.
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.
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?
(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.