https://bugs.documentfoundation.org/show_bug.cgi?id=162604
Mike Kaganski <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|--- |NOTABUG Status|UNCONFIRMED |RESOLVED --- Comment #1 from Mike Kaganski <[email protected]> --- This means that you put a string into a cell that has numeric formatting; and it shows you that character as a *visual clue* that the data in the numeric cell, although could be converted to a number, is in fact a string. 1. The apostrophe is not a part of the cell content, only a visual clue. 2. If you use cells to store text, as opposed to numbers, it is best to format the cells (maybe the whole column(s)) as text, *prior* to data entry. For numeric cells, Calc is *designed* to try hard to detect if the data can be interpreted as a number, and then it would transform it into such a number. This is the correct and expected behavior, so using textual format for textual cells is the correct workflow (otherwise, you risk having your password "000123" converted into a number 123 - loosing all the significant leading zeroes). -- You are receiving this mail because: You are the assignee for the bug.
