(I use automatic translation from Russian, the text may look clumsy, sorry)
the problem is in generating correctly encoded (according to [MS-OE376]: Part 4 Section 3.18.96, ST_Xstring (Escaped String) | Microsoft Learn) strings in sheet1.xml (which is placed in .zip archive of which the .xmlx file consists).
- open onlyoffice desktop editors (tested on 184.108.40.206 deb and x86 msi versions of the program under astralinux 1.7 and windows 7), table, enter the text
="_x1234"in cell A1 (everything starting with the “equals” symbol, 9 characters, “x” - Latin)
- save as .xlsx, close the table editor
- open this saved file in the table editor
I see that after this,
_x1234_ is correctly visible in the table itself, but if you select this cell, nonsense is visible in the “formula area”
my opinion: this is because when entering text like
_xNNNN_ into a cell, the program, when generating sheet1.xml, writes encoded text into the
<v> tag (instead of
_x005F_xNNNN_ as it should be encoded according to the link above), and in the
<f> tag writes NOT the encoded text, but the original text.
But when opening a file, the program decodes BOTH from the
<v> AND from the
<f> tag, and therefore an incorrect result is obtained in the “formula area” (it includes the decoded from the
<f> tag… into which the program “forgot” to encode the text when saving).
if I write this text (
="_x1234_") in cell A1, save it in xlsx, open xlsx just as an archive and read /xl/worksheets/sheet1.xml from there, then I will see something like this (for cell A1):
<c r="A1" t="str"><f>"_x1234_"</f><v>_x005F_x1234_</v></c>
but (I think) there should be something like:
<c r="A1" t="str"><f>"_x005F_x1234_"</f><v>_x005F_x1234_</v></c>
(in this form, xml is generated by MS Excel when writing such text into cell A1 and saving the table to an xlsx file)
Please confirm the error and correct it.
I have a free version and technical support told me that they cannot reproduce the problems and do not provide support for free versions and told me to write to the forum.
here I am writing