zk spreadsheet autorefresh performance

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

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
6280 ● 2 ● 7

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

Comments

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

https://doc.keikai.io/tutorial#evaluation

cor3000 ( 2021-04-27 13:59:10 +0800 )edit

Question tools

1 follower

Stats

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

Seen: 9 times

Last updated: Jul 19 '21

CORE FRAMEWORK

FEATURED COMPONENTS

TOOLS

EXPLORE ZK

RESOURCES

LEARN ZK

RESOURCES

GET HELP

RESOURCES

MORE ABOUT ZK

MORE ABOUT ZK

zk spreadsheet autorefresh performance

1 Answer

Comments

Question tools

Stats

Related questions