Help - Search - Members - Calendar
Full Version: Hancom Sheet Functions
OESF Forums > Distros, Development, and Model Specific Forums > Model Specific Forums > C1000/3x00 General discussions
Darklaw
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...
Darklaw
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.
John Galt
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.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.