jspreadsheet / pro

Jspreadsheet Pro | The javascript spreadsheet
https://jspreadsheet.com/
15 stars 1 forks source link

Columns Name Calculations does not work when column title is chinese. #323

Closed lyxiaoxiang closed 7 months ago

lyxiaoxiang commented 7 months ago

Columns Name Calculations does not work when column title is chinese.

For example: data: [ {rmb_price:'=@价格10', price:'100'}, // {rmb_price:'=@price10', price:'100'}, ],

columns: [ {'title': '价格', 'name': 'price', 'width': '200px', 'type': 'numeric'}, {'title': '人民币价格', 'name': 'rmb_price', 'width': '150px', 'type': 'numeric'}, ]

Can I use the name property of a column when calculating a formula?

frodhod commented 7 months ago

Actually that works, but must have Formula Pro enabled, and the column name must have more than 3 characters.

Here is a working example: https://jsfiddle.net/bad56yfz/7/

lyxiaoxiang commented 6 months ago

Hi frodhod, Do you see the #ERROR! in the C1 CELL ?

It's not work properly. Is it license-related?

image

hodeware commented 6 months ago

We have updated the license and the version. Here is a working example: https://jsfiddle.net/xm1vfg9h/2/