Simple formatting of cells with OpenOffice in VB.NET

Question

I want to automate OpenOffice in VB.NET. I have installed "Libre Office". How do I add a reference to com object? I can't find it in com objects list.

I can fill cells with values.

... 
firstSheet.getCellRangeByName("B10").value = 12.36    
firstSheet.getCellRangeByName("C10").string = "aaaaaa"

But I can't make some simple formatting with cells.

I want to change appearance of cells. Change 'BackColor' or 'Forecolor' or 'Font size', 'Font Name', round digits, etc.
How do I format cell as date? How do I make my own format style? How do I format cells?

Jim K · Accepted Answer · 2016-03-15 14:19:00Z

1

Check out Bernard Marcelly's VB.NET OOo guide. An excerpt from the document:

COM interfaces are not visible from the VB programmer. In fact interfaces are seen as objects with methods and properties, and you handle Apache OpenOffice objects as Object.

To set cell attributes, see section 6.3 of Andrew Pitonyak's Macro document.

answered Mar 15, 2016 at 14:19

Jim K

14.1k2 gold badges26 silver badges54 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

GGSoft Over a year ago

Thanks Jim Second link was very usefull

Collectives™ on Stack Overflow

Simple formatting of cells with OpenOffice in VB.NET

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related