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?
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:
Tags
People
Badges
Help
Range::notifyChange()
Spreadsheet::notifyLoadedAreaChange()
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
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 )editAsked: 2021-01-20 16:12:12 +0800
Seen: 8 times
Last updated: Jan 21 '21