ce icon indicating copy to clipboard operation
ce copied to clipboard

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

Open st8st8 opened this issue 1 year ago • 4 comments

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 avatar Feb 01 '24 09:02 st8st8

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

st8st8 avatar Feb 01 '24 10:02 st8st8

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

paulorodalves avatar Feb 01 '24 13:02 paulorodalves

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?

st8st8 avatar Feb 01 '24 15:02 st8st8

Yes, that will be included on version 5.

hodeware avatar Feb 01 '24 18:02 hodeware