search

ruilisi / fortune-sheet

A drop-in javascript spreadsheet library that provides rich features like Excel and Google Sheets
https://ruilisi.github.io/fortune-sheet-docs/
MIT License
2.54k stars 227 forks source link

='Sheet1'!A1 generates error #557

Closed ojrestrepom closed 4 months ago

ojrestrepom commented 5 months ago

Describe the bug image

When I use the demo I can reference cells in other sheets. But when I use it in an application it generates an error. image And it doesn't matter if I use single quotes or not. Error is generated.

The cell reference appears in the calcChain. But he doesn't recognize the formula when I enter the name of the sheet. Could you tell me what to do? I am working on the development in Next JS 14 Thank you

sanchit3008 commented 5 months ago

Thanks for reporting this. Will try reproducing this.

sanchit3008 commented 4 months ago

I was able to reproduce this, working on a fix.

sanchit3008 commented 4 months ago

@zyc9012 i just noticed that this feature is not working even if you revert to commits that are 6 months old. Any clue what could be going on?

sanchit3008 commented 4 months ago

https://github.com/ruilisi/fortune-sheet/commit/906216e7a9ee0c5161057d6709a4892de20ad8e2?diff=unified&w=1

while updating the grammar parser, the lines for checking the sheet names were removed.