Strange Behaviour Of Hancom Sheet

[plcg]

Hi,

Did anyone notice this weird problem in Hancom Sheet v1.6.0 (C700 with Cacko v1.22) ?
I've created an excel document with 3 cells :
one with a number, one with function NOW() and another which is the sum of the two others (Example : NOW()+A1).
The results are as expected.

But, when i close and then reopen this document, the cell which contains the sum is filled with "#0PRND".
I have to select "Tools/Recalculate" to get correct result.
What means "#0PRND" ?

I've never seen this problem with Hancom Sheet v1.5.0, tkcrom and SL5500.

Thanks for your help  
plcg

[Joeboo]

Hi,

Did anyone notice this weird problem in Hancom Sheet v1.6.0 (C700 with Cacko v1.22) ?
I've created an excel document with 3 cells :
one with a number, one with function NOW() and another which is the sum of the two others (Example : NOW()+A1).
The results are as expected.

But, when i close and then reopen this document, the cell which contains the sum is filled with "#0PRND".
I have to select "Tools/Recalculate" to get correct result.
What means "#0PRND" ?

I've never seen this problem with Hancom Sheet v1.5.0, tkcrom and SL5500.

Thanks for your help   
plcg
[div align=\"right\"][a href=\"index.php?act=findpost&pid=63638\"][{POST_SNAPBACK}][/a][/div]

I get this when the input variables are wrong.  For example if I run a formula based on numbers from a different column and I try to insert a letter instead, I get the same message.  Check your formula and check your data.

Good luck.

[ralphrmartin]

Where did you get that release of Hancom Sheet?

I can only find 1.5.0 on the web, and that doesn't work too well with a C860 (fonts too small...)

[rrashkin]

what happens when you save as Hancom Sheet instead of Excel?  I have found that some functions don't persist, even though I'd think they are the same in both.

[mikew]

Hancom Sheet version 1.6 comes as standard with version 1.22 of the Cacko ROM, as does Hancom Word version 1.6.

Mike

[plcg]

Hi,

I haven't saved this document as Hancom Sheet because I must open it on my Windows PC.

I've also tried Hancom Sheet v1.5.0 on my C700/cacko v1.22.
The fonts were small but my document was correct (no #PRND).

I'm lost...  
plcg