Invalid XML when saving to .xlsx
lazarus / 49-FPSpreadsheet

----------------------------------------------------------------------
pmoita · 2016-03-10 11:48

I have a very old program made in FPW2.6 that can export to XLS in
sfExcel2 format.

I made one that reads this file and saves it again in sfOOXML or
sfOpendocument formats.

Problem is some of the files say invalid XML when opening if sfOOXML
format is used.

After some research I concluded some characters included in the
original file text aren't escaped in the XML.

What can I do to prevent this?

----------------------------------------------------------------------
wp · 2016-03-10 12:07

Without digging into details, and based on your idea that some
characters have not been escaped properly, I'd guess that your
fpspreadsheet version is too old. Update to the trunk version, or
version 1.6.

[EDIT]
I uploaded a bugfix release 1.6.1 which should contain all fixes
submitted after 1.6 (but not the new features):
https://sourceforge.net/projects/lazarus-
ccr/files/FPSpreadsheet/fpspreadsheet-1.6.1.zip/download