https://issues.apache.org/ooo/show_bug.cgi?id=123033
--- Comment #4 from Oliver-Rainer Wittmann <[email protected]> --- (In reply to Oliver-Rainer Wittmann from comment #3) > (In reply to Edwin Sharp from comment #2) > > Can not explain presence of character ' > > C10:C14 have format code DD.MM.YY, just like C2:C9. > > IMHO bug. > > ok, let us discuss. > > Here is my view: > The content and the format of a cell does not have to fit together. > > For example: > When the content of cell A1 is "Hallo Edwin" - character " is not part of > the content, I just used it to mark the content -, you can change the format > of A1 to a number format (e.g. format code = 0) or a date format (e.g. > format code = DD-MM-YYYY). But this will not 'convert' the content of the > cell to corresponding type. The content type of A1 will not become a number > or a date. The format of a cell specifies how its content has to be > displayed - it does not convert the content to a specific type. > > In the given document cells C10..C14 contain text content which is indicated > by character '. I had a look into the ODF. For cells C10..C14 value type > "string" is specified. As the content could be interpreted as a date - e.g. > for C10 it is "13.08.13" - the character ' is used to avoid automatic number > recognition on this cell content in order to compress conversion to value > type "date". > > Thus, AOO is just doing what it has been told by the document - handle > content of C10..C14 as text. > > --> my conclusion: not a bug sorry, I found a typo - please read "suppress" instead of "compress" -- 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.
