Slow Hancom Sheet

[amdonati]

Hi,

I have tried to open a small (around 160 KB) excel file in Hancom Sheet to work on it on the road.
The file is a sort of personal \"cash book\", so it has 2 sheets and each sheet (Home and bank) has an income and a outcome and sum column. THe sum cell in each row sums the incomes or outocomes of the row and add or substracts them from the previous total.
Quite straightforward and easy!  :wink:
It has now around 100 rows filled, evenly divided in the 2 sheets!
The problem is that:
1) to load the file, once Hancom sheet is open. it takes around 1 minute from SD
2) to make the recaluclations when I enter a new value it takes around 2 minues (with both automatic or manual recalculation)!

Now, I know that the StrongArm is not an AThlonXP, but this seems to me quite extreme!
We are speaking of around 100 sums!

Is this normal?
Is there a way to improve the performance?
As it is now, it is really badly usable!

Thank you!
Adalberto

[dawest]

I would say that you have something else happening there... I have something that has at least twice the data and is cross linked between 3 sheets and the re-calculation time is under 45 seconds from the CF card... have you configured a swap file?  That would greatly improve performance!

Be Well
DW

[amdonati]

Yes, I have a 20mb swap in ram (using tkc rom1).
 

Adalberto

[dawest]

I am using the sharp 3.13 rom but that should not be much of a difference... have you inspected your formulas for circular referances? that could make the recalculation go arround a loop for a while before reporting... but that might also make the math look funny???

Sorry I was not more help
DW

[amdonati]

Thanks for the suggestions anyway!  

I will give a look to the file.
Maybe there are some \"hidden\" referencies that are ignored by EXcel but not liked by Hancom Sheet!

If only OPie sheet could import simple excel files or Gnumeric would be available!    

Adalberto