https://bugs.documentfoundation.org/show_bug.cgi?id=152724
--- Comment #14 from Laurent Balland <jumbo4...@yahoo.fr> --- (In reply to ady from comment #13) > I'd like to emphasize that combining "?0" was not working in 7.4.4.2 for > ods. I understand that you worked on the "?" part for 7.6; my point is that > saying "0 was already treated" might be confusing to users, since the > combination of "0" with some of the other codes was not working. As ? was not working, any combination with ? was not working. Combining # and 0 was working fine. > Would you please be so kind and mention here some example of "unreasonable" > combination of "#, ? and 0"? Not only it would help for testing (now and in > future versions), but especially to be aware and to be able to provide such > information to other users. Sorry I went too fast. The format code of integer part must be in the following order: - zero or any number of "#" - zero or any number of "?" - zero or any number of "0" For the decimal part, it is the opposite order. For instance, these formats are correct: ##??00.00??## ?????0.# But if you mix order of coding characters, format will be non sense. These formats cannot be saved in ODF (even if you can save them in XLSX) because they are not coherent: 00?#?.#0?0 ?#0.?0 > > _x still needs an ODF extension. I accordingly modified the summary. > > Would this RFE be assigned to someone for that? There may be someone who could assigned it to him/herself, but nobody will assigned to someone else. It's a voluntary project. As far as I am concerned, I could have a look in few weeks, if nobody takes care of it. > Please note the double zeros in the last one. Whether this could generate > problems with users sharing files between different versions of LO, IDK. > Whether this can be avoided, IDK either. Replacing ? with 0 is the best choice for versions unable to interpret ? in integer part: a place is reserved for the digit. -- You are receiving this mail because: You are the assignee for the bug.
