https://issues.apache.org/ooo/show_bug.cgi?id=103960
Rainer Bielefeld <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Keywords|needmoreinfo | Status|CONFIRMED |RESOLVED CC| |rainerbielefeld_ooo_qa@biel | |efeldundbuss.de Component|configuration |formatting Version|4.1.0-dev |OOo 3.3 or older Resolution|--- |NOT_AN_ISSUE --- Comment #6 from Rainer Bielefeld <[email protected]> --- Version has been modified erroneous, so back to most early version I see the effect: cell shows date and time, after double click view changes to "39480,25", as seen in input line. But I doubt that it is a bug and I am pretty sure that we will not fix that. @reporter: Please feel free to reopen this Bug if you can contribute Microsoft manual information that the format code you found in the excel documents really is valid and useful for particular applications, in that case we would have to think about improvements for our input filter. Additional Info: ---------------- (a) the effect is not related to the "@" in the format string. It will also appear if you type some different text "foo" after the semicolon (b) If I understand everything correctly the format code is "TT.MM.JJJJ HH:MM;@" is incorrect, also in excel. In AOO and Excel you can insert different format codes for different contents, the sections for the different contents are separated by semicolons. In excel: <POSITIVE>;<NEGATIVE>;<ZERO>;<TEXT> So in Example the "@" in reporter's example is a formatting instruction for negative numbers. Because it is invalid, it will make invisible negative numbers in reporter's example Cell D8 (c) so the format code simply is invalid, does not cause bigger trouble most times, but is useless. We can't have ambition to correct any user error of Excel users in AOO. So Not An Issue for now -- 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.
