https://bugs.documentfoundation.org/show_bug.cgi?id=149428
Laurent BP <jumbo4...@yahoo.fr> changed: What |Removed |Added ---------------------------------------------------------------------------- Version|7.1.6.2 release |Inherited From OOo CC| |er...@redhat.com, | |jumbo4...@yahoo.fr --- Comment #3 from Laurent BP <jumbo4...@yahoo.fr> --- Actually, there is no way to save such specific format in ODF. You can only save it in XLSX. ODF save the number of decimals (either 0, or blank (?) or empty place (#)), plus some text after the number, but it has no information if text is placed inside decimal part. How ODF save format, if text is inserted in integer part: 00" "00" "00" "00" "00 <number:number number:decimal-places="0" number:min-decimal-places="0" number:min-integer-digits="10"> <number:embedded-text number:position="8"> </number:embedded-text> <number:embedded-text number:position="6"> </number:embedded-text> <number:embedded-text number:position="4"> </number:embedded-text> <number:embedded-text number:position="2"> </number:embedded-text> </number:number> If text is inserted in decimal part: 0.00" "00" "00" "00" "00 <number:number number:decimal-places="10" number:min-decimal-places="10" number:min-integer-digits="1"/> <number:text> </number:text> number position is lost and restored as 0.0000000000" " Could we store a negative value of "position" to indicate it concerns decimal part? number:position is defined here: https://docs.oasis-open.org/office/OpenDocument/v1.3/os/part3-schema/OpenDocument-v1.3-os-part3-schema.html#attribute-number_position as position is defined as an integer, it could get negative value. Add Eike in CC. Eike, do you think it is reasonably feasible? -- You are receiving this mail because: You are the assignee for the bug.