OESF Portables Forum

Everything Else => Sharp Zaurus => Model Specific Forums => Distros, Development, and Model Specific Forums => Archived Forums => C1000/3x00 General discussions => Topic started by: Darklaw on October 22, 2005, 05:35:18 pm

Title: Hancom Sheet Functions
Post by: Darklaw on October 22, 2005, 05:35:18 pm

I'm trying to use a spreadsheet created on OpenOffice.org and saved as an .xls file, with Hancom Sheet on my Z.

Unfortunately the sheet contains a formula that Hancom doesn't recognise - namely ISBLANK, which returns TRUE if a referenced cell is blank.

I was wondering if (and hoping that) someone might be able to help me out with a replacement for this function.

Thanks in advance...

Title: Hancom Sheet Functions
Post by: Darklaw on October 22, 2005, 07:25:01 pm

I've been doing some checking, and I have a feeling the CELL function could be used to do the same job, but I'm not sure how to use it.

The specified usage is CELL(type, range).  I figure "range" is the cell in question; but I'm not sure what to include for "type".

Again, any assistance anyone can offer would be greatly appreciated.

Title: Hancom Sheet Functions
Post by: John Galt on October 24, 2005, 04:46:17 pm

I haven't checked it with Hancom, but I think CELL works the same way as with Excel. For type you would enter something like the following:

address
col
color
contents
filename
format
parentheses
prefix
protect
row
type
width

In your case, if you use "type" it will return either "b" for blank, "v" for value or "l" for label. "contents" will return either the content or 0.

I hope this helps.