Help - Search - Members - Calendar
Full Version: Hancom Mobile Sheet deletes entered formula
OESF Forums > General Forums > General Support and Discussion > Software
Morpheus
Help please, this is driving me nuts.

I have a small spreadsheet that I use to log my work hours and calculate the amount to invoice the company I am contracted to.

There is one formula that I have that joins two numerical cells together:
=UNION(H9,":",I9)

Its just a visual thing to make my hours and minutes display in the correct format.

For some unknown reason, every time I re-open the file, the formula has been replaced by a '0' in the cell. If I replace the formula, save it, close sheet and re-open the file, the cell is once again displaying '0'

This only seems to happen with the =UNION() function, any other function I have used so far work fine.

I'm using a SL5600, running Sharp kernal 2.4.18, and Qtopia 1.5.4

Has any one else seen this happen?

Jason
rrashkin
are you, by any chance, saving this file as .xls rather than native Hancom? That would explain it IF you're not using any other Hancom functions that do not exist in Excel.
Morpheus
Yes, i am saving the file as a .xls
I didnt know it was a Hancom specific function, I didnt even know there WERE Hancom specific functions!! I've re-entered the function, saved as .hst, closed and re-opened the file and it works just fine.

Thanks for the very quick reply.

Just out of curiosity, is there an equivalent excel function? I used to use =STRING() on my old Psion5 excel compatible spreadsheet, but that doesnt work on the Zaurus.

Cheers

Jason
rrashkin
As it turns out, there is:
QUOTE
 
CONCATENATE (text1,text2,...)

Text1, text2, ...   are 1 to 30 text items to be joined into a single text item. The text items can be text strings, numbers, or single-cell references.

Remarks

The "&" operator can be used instead of CONCATENATE to join text items.

Examples

CONCATENATE("Total ", "Value") equals "Total Value". This is equivalent to typing
"Total"&" "&"Value"
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.