Reference to other sheet not working

mk-j / PHP_XLSXWriter

Lightweight XLSX Excel Spreadsheet Writer in PHP

MIT License

1.84k stars 665 forks source link

Reference to other sheet not working #289

Closed romain-le-mercier closed 1 year ago

romain-le-mercier commented 4 years ago

I know the issues are not taking under consideration, it's too bad this project could build up and be really useful.

So anyway, i'll post this here.

When writing data to display cell value from an other sheet the cell is displayed as an error at first, but when I edit the cell in excel and just press enter (without changing the formula) the value is displayed correctly. As if an update was needed. If anyone has a solution let me know.

mk-j commented 1 year ago

If you can provide a short php program which reproduces the problem, then we can reproduce it and fix it. Otherwise there isn't enough information to reproduce and fix the reported issue.