php - Getting #N/A for any calculations that reference a cell by name
I have an Excel file that consists of 8 Worksheets.
Throughout the Excel file, there are calculations that take place in various cells that reference other cells in other worksheet and refer to them by name only.
For example in Worksheet 2, I have a cell D12 and the formula in this cell is
=CostIssue. CostIssue is a cell in Worksheet 1.
Using PHPExcel I managed to read the Excel file, manipulate some cells and then generate an HTML of it, but as I mentioned, in all the cells that reference named cells I am getting #N/A.
Any way to solve this or must I manually edit the entire file to reference these named cells in another way (i.e. by worksheet and cell number)?
Some more info. Sheet 2, cell D12 contains
CostIssue is the name of cell C37 in Sheet 1 which contains: