zk spreadsheet autorefresh performance

asked 2021-04-16 20:01:38 +0800

AndreyK gravatar image AndreyK
155 4

Hello! I am using zk8.0.5 and zss 3.9.1. Seems here performance problem with autorefresh formula values in big templates (like 300 rows) with many formulas like this https://gyazo.com/197cc56267c220d91eeeecc4e5397222 Some of formula fields doesnt update automatically after changing values in cells and does it only after explicit Range.refresh(). What wrong with it ?

delete flag offensive retag edit

1 Answer

Sort by ยป oldest newest most voted

answered 2021-04-20 12:13:47 +0800

cor3000 gravatar image cor3000
5995 2 7
ZK Team

updated 2021-07-19 17:07:36 +0800

From the screenshot alone it's impossible to tell what's happening and what is not happening at both server and client side. If you can share the excel file and the the related updating code we can have a look (If you can't share the excel file in public please contact our support).

The only thing that pops out from your screen shot are the Russian formula names I assume that's the =SUM(D7:15) formula. So you might try an english locale (just to be sure it's not a localization issue).

In case that was an issue in version ZSS-3.9.1, there is a chance that it had been reported earlier and fixed in Keikai-5.7.0 (continuation ZSS).

Did you already try that latest version?

UPDATE 2021-06-30:

I posted the issue KEIKAI-482 (please track the status there)

link publish delete flag offensive edit


No, didnt. I did simple app with 1 button, u can try. https://drive.google.com/file/d/1zrcW2-kUFAoSwDc-02mlbbqxNkqiqbe_/view?usp=sharing formulas at the end of the pattern are evaluated as I see.

AndreyK ( 2021-04-20 16:56:47 +0800 )edit

You got access?

AndreyK ( 2021-04-21 21:00:01 +0800 )edit

yes I got the file, just other priorities at the moment

cor3000 ( 2021-04-22 13:09:28 +0800 )edit

I was able to run the project after adjusting the incorrect zpoi dependency, and reproduce the problem it happens in both zss 3.9.1 and keikai 5.0.0 OSE the problem doesn't occur since keikaiex 5.0.0 and also still works in keikai 5.7.0 If you'd like to try you can use the evaluation versions

cor3000 ( 2021-04-27 13:58:40 +0800 )edit
Your answer
Please start posting your answer anonymously - your answer will be saved within the current session and published after you log in or create a new account. Please try to give a substantial answer, for discussions, please use comments and please do remember to vote (after you log in)!

[hide preview]

Question tools

1 follower



Asked: 2021-04-16 20:01:38 +0800

Seen: 8 times

Last updated: Jul 19

Support Options
  • Email Support
  • Training
  • Consulting
  • Outsourcing
Learn More