0

Rerender spreadsheet cells

asked 2021-01-20 16:12:12 +0800

AndreyK gravatar image AndreyK
155 4

updated 2021-01-20 17:15:56 +0800

Hello! Zk version 8.0.5, zss version 3.9.1 Getting this issue: https://gyazo.com/c1a8d9687a7ea725017189a5db31ef39 In "template.xlsx" adjusted MASK for numbers. It works when we put data in runtime, by editing cells. But if data preloaded there is no way to rerender/notify/refresh it with mask without editing value in interface. Whats wrong?

delete flag offensive retag edit

1 Answer

Sort by ยป oldest newest most voted
0

answered 2021-01-21 11:18:29 +0800

hawk gravatar image hawk
2785 1 5
http://hawkphoenix.blogsp... ZK Team

updated 2021-01-21 11:28:48 +0800

image description

As I understand, you mean the value of the first cell under column 12 without colon : is loaded from the file. And other cells are inputted by users, so it contains :, right?

You can notify cells to update by:

Range::notifyChange()
Spreadsheet::notifyLoadedAreaChange()

Range javadoc

I assume you apply a specific number format on those cells to show them in the special format. What pattern do you apply to create that input mask, like ##:##:######:###? I try it in Excel, but Excel doesn't allow me to set that pattern.

Besides, ZK Spreadsheet is retired now. Please migrate to Keikai

link publish delete flag offensive edit

Comments

No, all numbers without ":", 1st loaded from database and set by Range.setCellValue. Mask in Excel template like: https://gyazo.com/af9bac96a1d291e39d19ac7db715b7a9; Problem that this notify dont work for me. Number remains number, not adjusting to mask in view

AndreyK ( 2021-01-21 13:42:47 +0800 )edit
1

Seems, found problem. Number was inserted like a String

AndreyK ( 2021-01-21 14:11:45 +0800 )edit

ok right. If you set a cell value as String. zss doesn't apply it with a number format.

hawk ( 2021-01-25 09:27:43 +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

Follow

RSS

Stats

Asked: 2021-01-20 16:12:12 +0800

Seen: 7 times

Last updated: Jan 21

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