Oct 22 2005, 01:35 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...
Oct 22 2005, 03:25 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.
Oct 24 2005, 12:46 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:
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