Open Office Basic cell.length

2.3k views Asked by At

I have to check cells and when it is empty show MsgBox or something. So I`m looking for IsNull function or cell.length. Has BASIC some kind of this functions?

2

There are 2 answers

0
Csabi On BEST ANSWER

In OpenOffice I would use YourCell.String == ""

0
jswolf19 On

According to http://wiki.services.openoffice.org/wiki/Documentation/BASIC_Guide/Cells_and_Ranges, you can check Cell.Type to see if it is equal to com.sun.star.table.CellContentType.EMPTY.