https://issues.apache.org/ooo/show_bug.cgi?id=123033
--- Comment #3 from Oliver-Rainer Wittmann <[email protected]> --- (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 -- 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.
