Internationalization Spreasheet Filter

asked 2020-07-23 21:32:42 +0800

AndreyK gravatar image AndreyK
155 4

updated 2020-07-23 22:23:22 +0800

Hello! We have simple way to customize all filter functionality? Language? I can only find popup.js, but he doesnt contains all what need, and no properties https://gyazo.com/9ccb9ddbca54fd9d49b0bcc8bc229f72

delete flag offensive retag edit


which version are you using?

cor3000 ( 2020-07-24 10:57:32 +0800 )edit

zk8.0.5, zssex-nosrc.version3.9.1

AndreyK ( 2020-07-24 12:40:15 +0800 )edit

2 Answers

Sort by ยป oldest newest most voted

answered 2020-07-24 11:11:08 +0800

cor3000 gravatar image cor3000
5384 2 7
ZK Team

updated 2020-07-24 11:11:45 +0800

The labels shown in your screenshot are defined in zssex.jar/metainfo/zk-labels.properties

ZSS already provides english and chinese(traditional) versions, you can add your own version (e.g. zk-labels_ru.properties), and add it to your project's classpath in package metainfo or inside /WEB-INF/-folder.

image description

link publish delete flag offensive edit


found this https://gyazo.com/98d555eff00a70987f9d7c964f913952. But it doesnt contain such labels like "select all", "blanks", "clear filter" "number/text filters" and all of this https://gyazo.com/7cb46ce40c0896482a4880b92a. Is it only hardcoded js? https://gyazo.com/640b1f53d2afcb1a4f5a90424e5a8389

AndreyK ( 2020-07-24 13:25:21 +0800 )edit

How to adjust the client side js labels is documented here: https://www.zkoss.org/wiki/ZK%20Spreadsheet%20Essentials/Working%20with%20Spreadsheet/Advanced/I18n

cor3000 ( 2020-07-24 15:36:18 +0800 )edit

to correct myself there are a few "hard coded" values, which you have to override by hard coding as well

cor3000 ( 2020-07-24 15:48:30 +0800 )edit

I posted the bug: KEIKAI-326

cor3000 ( 2020-07-24 16:11:18 +0800 )edit

did such way https://gyazo.com/74b1707d80411a5e4732eb62c803ae4a

AndreyK ( 2020-07-24 16:49:53 +0800 )edit

answered 2020-08-20 10:22:39 +0800

cor3000 gravatar image cor3000
5384 2 7
ZK Team

updated 2020-08-20 10:23:56 +0800

KEIKAI-326 is going to be fixed in Keikai 5.4.0 (5.4.0.FL.20200817-Eval is already available on maven for testing)

From this version on the following labels for the Filter dialog can be localized in from msgzss.js:

msgzss.filter = {
    clearFilter: 'Clear Filter From "',
    clearFilterPost: '"',
    colorFilter: 'Filter by Color',
    colorFilterCellColor: 'Filter by Cell Color',
    colorFilterFontColor: 'Filter by Font Color',
    valueFilterTypeText: 'Text Filters',
    valueFilterTypeNumber: 'Number Filters',
    valueFilterTypeDate: 'Date Filters',
    selectAll: '(Select All)',
    blank: '(Blanks)',
    filterOK: 'OK',
    filterCancel: 'Cancel'

See: doc.keikai.io - Internationalization (i18n)

link publish delete flag offensive 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: 2020-07-23 21:32:42 +0800

Seen: 11 times

Last updated: Aug 20

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