Absolute referencing doesn't work in spreadsheet directive

RunestoneInteractive / rs

A New Monorepo structure for Runestone

Other

39 stars 65 forks source link

Absolute referencing doesn't work in spreadsheet directive #109

Open raskutti opened 5 years ago

raskutti commented 5 years ago

If I have a rendered spreadsheet, I can reference other cells using their cell number, e.g. I can write a formula like =A1*2. This does not work for absolute references, e.g. =$A$1*2.

bnmnetp commented 5 years ago

This is an interesting one because jExcel doesn't really support the sort of smart copy/pasting and filling that sheets and excel do. -- At least without us implementing our own copy/paste functionality.

I would have to look into the code for jExcel itself to see how hard it would be to add this feature.