fpSpreadSheet & Graphics
lazarus / 49-FPSpreadsheet

----------------------------------------------------------------------
spenna · 2014-10-08 20:29

May I preserve graphics in a .xls file? I tried to load a test xls
with a graphic defined inside, but when I save a modified version it
loses the graphic object... someone knows how to fix it ?

----------------------------------------------------------------------
wp · 2014-10-08 21:20

No, graphics, charts etc. are not supported by fpspreadsheet.

BTW, when you load xls files into fpspreadsheet, modify something and
save them back, you must always be aware of some kind of loss; the
list of features that we do not support is still very long and will
probably remain as such: some special number format (fractions,
accounting-type of formats), background patterns, gradients,
conditional formatting, column/row formats, security features etc.

----------------------------------------------------------------------
rvk · 2014-10-08 21:42

Quote from: wp on October 08, 2014, 11:20:36 pmNo, graphics, charts
etc. are not supported by fpspreadsheet.

Quote from: spenna on October 08, 2014, 10:29:36 pmsomeone knows how
to fix it ?
If you really want to preserve everything you need to look into using
ole automation. You do need to have Excel installed on the same
computer, though. You can look here to get started.

----------------------------------------------------------------------
spenna · 2014-10-09 07:24

Thank you for the reply,

I was hoping not to use OLE in fact   -- I don't use Excel at all (I
prefer LibreOffice), but my clients do...

nicola

----------------------------------------------------------------------
rvk · 2014-10-09 07:33

Quote from: spenna on October 09, 2014, 09:24:57 amI don't use Excel
at all (I prefer LibreOffice), but my clients do...
Same here 
That's why I implemented OLE for both LibreOffice and Excel in my
program. I check which one is installed and use the correct one to
generate a file. Only problem arises when somebody has neither
installed (yes it happens  ).