Export data to OpenOffice Calc and MS Office Excel

Javier Tovar · Post by **Javier Tovar** » Fri Feb 20, 2015 4:45 pm

I expect a full sample of both, do not deny me not to try OpenOffice!

regards

Mario Mansilla · Post by **Mario Mansilla** » Sun Feb 22, 2015 2:10 pm

Hola :
Es posible obtener al pie de una columna con datos numericos obtener la suma de toda la columna .

Saludos
Mario Mansilla

Hello:
It is possible to obtain at the foot of a column with numeric data to obtain the sum of the whole column.

regards
Mario Mansilla

mol · Post by **mol** » Sun Feb 22, 2015 6:06 pm

You can use such a construction:

Code: Select all

	oSheet:getCellByPosition(0,11):SetFormula("=Sum(A1:A10)")

Mario Mansilla · Post by **Mario Mansilla** » Mon Feb 23, 2015 11:49 am

Hola Mol :
muchas gracias por tu repuesta .
Saludos cordiales
Mario Mansilla

Hello Mol:
thank you very much for your response.
Best Regards
Mario Mansilla

mol · Post by **mol** » Tue Feb 24, 2015 1:57 pm

I want to share with you my little sample about formatting export to OpenOffice.
It's not finished yet, but it can show power of LibreOffice calc API.
Have a nice testing!
Thanks for future questions!

Regards, Marek

quartz565 · Post by **quartz565** » Tue Feb 24, 2015 6:31 pm

Thank you Mol!

Post by **danielmaximiliano** » Wed Feb 25, 2015 3:02 am

Gracias por compartir Mol....

Post by **serge_girard** » Wed Feb 25, 2015 8:17 am

Thanks Marek !

Serge

Post by **serge_girard** » Wed Feb 25, 2015 8:51 am

Marek,

FMG is missing in EXPORT.ZIP?

Serge

mol · Post by **mol** » Wed Feb 25, 2015 9:25 am

You're right, Serge!
I'm attaching new zip including all files.

HMGforum.com

Export data to OpenOffice Calc and MS Office Excel

Re: Export data to OpenOffice Calc and MS Office Excel

Re: Export data to OpenOffice Calc and MS Office Excel

Re: Export data to OpenOffice Calc and MS Office Excel

Re: Export data to OpenOffice Calc and MS Office Excel

Re: Export data to OpenOffice Calc and MS Office Excel

Re: Export data to OpenOffice Calc and MS Office Excel

Re: Export data to OpenOffice Calc and MS Office Excel

Re: Export data to OpenOffice Calc and MS Office Excel

Re: Export data to OpenOffice Calc and MS Office Excel

Re: Export data to OpenOffice Calc and MS Office Excel