[Libreoffice-bugs] [Bug 157389] Conditional formats don't always apply to pasted cells
https://bugs.documentfoundation.org/show_bug.cgi?id=157389 --- Comment #7 from m.a.riosv --- (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. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 157389] Conditional formats don't always apply to pasted cells
https://bugs.documentfoundation.org/show_bug.cgi?id=157389 --- Comment #6 from laza...@iname.com --- 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? -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 157389] Conditional formats don't always apply to pasted cells
https://bugs.documentfoundation.org/show_bug.cgi?id=157389 --- Comment #5 from laza...@iname.com --- 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. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 157389] Conditional formats don't always apply to pasted cells
https://bugs.documentfoundation.org/show_bug.cgi?id=157389
--- Comment #4 from ady ---
(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.
--
You are receiving this mail because:
You are the assignee for the bug.
[Libreoffice-bugs] [Bug 157389] Conditional formats don't always apply to pasted cells
https://bugs.documentfoundation.org/show_bug.cgi?id=157389 m.a.riosv changed: What|Removed |Added Status|UNCONFIRMED |RESOLVED Resolution|--- |NOTABUG CC||miguelangelrv@libreoffice.o ||rg --- Comment #3 from m.a.riosv --- 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. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 157389] Conditional formats don't always apply to pasted cells
https://bugs.documentfoundation.org/show_bug.cgi?id=157389 --- Comment #2 from laza...@iname.com --- Created attachment 189768 --> https://bugs.documentfoundation.org/attachment.cgi?id=189768&action=edit sample file -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 157389] Conditional formats don't always apply to pasted cells
https://bugs.documentfoundation.org/show_bug.cgi?id=157389 --- Comment #1 from laza...@iname.com --- Created attachment 189767 --> https://bugs.documentfoundation.org/attachment.cgi?id=189767&action=edit screenshot -- You are receiving this mail because: You are the assignee for the bug.
