https://issues.apache.org/ooo/show_bug.cgi?id=122812
Rob Weir <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|CONFIRMED |RESOLVED Resolution|--- |NOTABUG --- Comment #4 from Rob Weir <[email protected]> --- I'm not sure this is actually a bug. The leading ' is not a character is not part of the string all. It is just a formatting hint, to treat what the user types as a string not a number. This is true with other spreadsheets as well, going back to 1-2-3. One way of seeing that it is not part of the string is to use any of the string-oriented functions, such as LEN() or FIND() on such a cell. These functions to not see the apostrophe either. I would be bad, I think, if the interactive string searching (Edit/Find) had a different way of searching for strings than what the spreadsheet functions did. This would be very confusing. -- You are receiving this mail because: You are on the CC list for the bug. You are the assignee for the bug. You are watching all bug changes.
