fslaborg / FsSpreadsheet

Spreadsheet creation and manipulation in F#, Javascript, and Python.
http://fslab.org/FsSpreadsheet/
MIT License
20 stars 1 forks source link

[BUG] FsRange and FsRangeAddress use alternative constructors #57

Open Freymaurer opened 1 year ago

Freymaurer commented 1 year ago

This makes them impossible to use from js native perspective. All create functions are created with hashes appended:

image

Types must have the [<AttachMembers>] or are unusable. I tried writing tests in javscript but cannot add a cell:

image

HLWeil commented 1 year ago

Is it actually a necessity someone explicitly calls these in js?

Freymaurer commented 1 year ago

for js native testing i would say yes, see my example. Alternatively i would suggest a new type called "JsConstructor" in its own file. This type then contains create functions for all types.

HLWeil commented 1 year ago

Maybe, for the moment, try this syntax:

ws.Row(1).[2].SetValueAs "myColumn1"