Import for certain user defined format strings (cell style) from LibreOffice fails. (containing slashes)
When I enter a format code like "a = "0.##" m/s²" in LibreOffice, a cell with value 5 will display as "a = 5 m/s²". (Nearly) same to gnumeric.
But problem is importing or copying data from LibreOffice. See following files:
format_codes.LibreOffice.ods Created in LibreOffice, WORKING in LibreOffice. See next file to see how it looks after gnumeric import:
format_codes.import.gnumeric.xml State after importing the format_codes.LibreOffice.ods file. BROKEN.
format_codes.copyNPaste.gnumeric.xml State after copying the cells from LibreOffice. BROKEN.
format_codes.inside.gnumeric.xml Like *.import.gnumeric.xml, but manually adjusted the format codes to exactly how they appear in LibreOffice. WORKING in Gnumeric
BTW:
- Copying from Gnumeric to LibreOffice works well.
- Format "a = "0.##" m/s²" translates to "a" "=" 0.00 "m"/"s²" and renders cell state to "Invalid format". You can correct it in cell style property editor.
- Format " = sqrt(27m*2/("0,##" m/s²))" vanishes and renders cell state to "Invalid format". You cann't adjust it when opening cell style property editor (empty string to be found), you have to copy the format string from LibreOffice editor.