PHP_XLSXWriter icon indicating copy to clipboard operation
PHP_XLSXWriter copied to clipboard

Published 20 hours ago • verified publisher icon mk-j

Question: How do I write R1C1 formulas?

Open MonkeyHunter opened this issue 5 years ago • 2 comments

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?

MonkeyHunter avatar Dec 12 '19 15:12 MonkeyHunter

Is there any progress in this?

vladoATL avatar Jun 14 '23 10:06 vladoATL

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: @.***>

mk-j avatar Jun 14 '23 18:06 mk-j