mk-j / PHP_XLSXWriter

Lightweight XLSX Excel Spreadsheet Writer in PHP
MIT License
1.84k stars 665 forks source link

Question: How do I write R1C1 formulas? #254

Open MonkeyHunter opened 4 years ago

MonkeyHunter commented 4 years ago

I need to use R1C1 notation for a particular formula, but excel errors and removes the formula when the spreadsheet opens. Ive tried the simplest test I could and it didn't work "=C[-1]" any thoughts?

vladoATL commented 1 year ago

Is there any progress in this?

mk-j commented 1 year ago

I'm not familiar with R1C1 formulas. If you're saying excel supports them, then go ahead, manually make a spreadsheet in excel with them. Rename the spreadsheet.xlsx file to .zip, unzip the file, and find your formula in the xml files (maybe xl/worksheets/sheet1.xml?) and see what it looks like in the xml. Then post the xml of the formula here.

Message ID: @.***>