Open Office Basic cell.length

Question

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?

score 1 · Answer 1 · answered Feb 14 '11 at 09:02

1

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.

answered Feb 14 '11 at 09:02

jswolf19

2,303
15
16

score 1 · Accepted Answer · edited Oct 11 '15 at 17:29

1

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

edited Oct 11 '15 at 17:29

Igor Ševo

5,459
3
35
80

answered Feb 14 '11 at 09:02

Csabi

3,097
17
59
107

Open Office Basic cell.length

2 Answers2