Page 5 of 9

Re: Export data to OpenOffice Calc and MS Office Excel

Posted: Fri Feb 20, 2015 4:45 pm
by Javier Tovar
I expect a full sample of both, do not deny me not to try OpenOffice!

regards

Re: Export data to OpenOffice Calc and MS Office Excel

Posted: Sun Feb 22, 2015 2:10 pm
by Mario Mansilla
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

Re: Export data to OpenOffice Calc and MS Office Excel

Posted: Sun Feb 22, 2015 6:06 pm
by mol
You can use such a construction:

Code: Select all

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

Re: Export data to OpenOffice Calc and MS Office Excel

Posted: Mon Feb 23, 2015 11:49 am
by Mario Mansilla
Hola Mol :
muchas gracias por tu repuesta .
Saludos cordiales
Mario Mansilla

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

Re: Export data to OpenOffice Calc and MS Office Excel

Posted: Tue Feb 24, 2015 1:57 pm
by mol
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

Re: Export data to OpenOffice Calc and MS Office Excel

Posted: Tue Feb 24, 2015 6:31 pm
by quartz565
Thank you Mol!

Re: Export data to OpenOffice Calc and MS Office Excel

Posted: Wed Feb 25, 2015 3:02 am
by danielmaximiliano
Gracias por compartir Mol....

Re: Export data to OpenOffice Calc and MS Office Excel

Posted: Wed Feb 25, 2015 8:17 am
by serge_girard
Thanks Marek !


Serge

Re: Export data to OpenOffice Calc and MS Office Excel

Posted: Wed Feb 25, 2015 8:51 am
by serge_girard
Marek,

FMG is missing in EXPORT.ZIP?

Serge

Re: Export data to OpenOffice Calc and MS Office Excel

Posted: Wed Feb 25, 2015 9:25 am
by mol
You're right, Serge!
I'm attaching new zip including all files.