Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to chage cell's format of Libre-Office Calc

Status
Not open for further replies.

capri1966

Programmer
May 13, 2010
57
ES
Please, I would like to know how to change the cell's format in a Libre-Office Calc with automation from VFP.
Someone know how to do this ?. Thanks
 
I doubt that anyone has done any automation with Libre-Office Calc. Most of the automation work is with Microsoft Excel as this is the dominate spreadsheet program. You can look at as this is a VFP only class that will open a spreadsheet in XLSX format, you can then make changes, and then save. The class also allows creation of XLSX documents.
 
It would help if you could tell us how much you already know. Can we assume that you already know how to instantiate the automation server, open the spreadsheet and locate the cell that you want to change? Or are you starting completely from scratch?

If the former, that's a reasonable question and it's possible that someone here knows the answer. But if the latter, this isn't the place to ask. You would need to read the Libre Office documentation and make sure you understand the overall concepts involved.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips and downloads
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top