search

jspreadsheet / ce

Jspreadsheet is a lightweight vanilla javascript plugin to create amazing web-based interactive tables and spreadsheets compatible with other spreadsheet software.
https://bossanova.uk/jspreadsheet/v4
MIT License
6.66k stars 818 forks source link

Entering "=VLOOKUP" into a cell displays the code for that function #1670

Open st8st8 opened 5 months ago

st8st8 commented 5 months ago

Take any recent version of jspreadsheet ce, take a cell and insert "=VLOOKUP" into it. The value of the cell with the javascript code for that function:

image

st8st8 commented 5 months ago

The same is true for other functions as well, for example "=ERF"

paulorodalves commented 5 months ago

Several formulas are only implemented on Formula Pro, available on the Pro versions. https://jspreadsheet.com/products/formulas

st8st8 commented 5 months ago

It happens for all formulas. The issue is the function code gets splashed into the cell when using it in his way (see screenshot). Would "#ERROR" be more appropriate?

hodeware commented 5 months ago

Yes, that will be included on version 5.