https://bugs.documentfoundation.org/show_bug.cgi?id=96822
--- Comment #3 from A (Andy) <[email protected]> --- (In reply to GerardF from comment #2) > (In reply to Kevin Suo from comment #0) > > > 1.1. Type "123" in A1, without quotes. > > 1.2. Set cell format of A1 to "Text". > > (Observe that the value is right-aligned. The expected behaviour is > > left-aligned as the cell value is text). > > 1. You type 123 in A1 : This is a numeric value. > 2. You are formatting the cell as "Text". > > Changing format of a cell with data do not affect data, the cell content is > still a numeric value. > > > 2.1. Set cell format of A2 to "Text". > > 2.2. Type "123" in A2, without quotes. > > (Oberve that the value is left-aligned. This is expected.) > > 2.3 Change format A2 to "Standard" or any numeric format. > A2 is still left aligned and "123" is still text. > > No bug here. Changing cell format never affect cell content. Why should the cell format never affect the cell content? If I decide after typing some characters to mark them as text then I would expect that it is text and that I don't have to type it again to get the same behaviour as it would be if I would have marked the cell as text before typing? -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
