Problem with Spreadsheet::ParseExcel

ravi45722 has asked for the wisdom of the Perl Monks concerning the following question:

I am parsing an excel sheet by using Spreadsheet::ParseExcel and parsing a template. In that template I am some formulae of =C2+D2+E2+F2+G2+H2+I2+J2+K2+P2 in s2 & =SUM(C2:R2) in T2 and =S2/T2 in U2.

After parsing and saving the formulae is not evaluating. Its showing 0 in S2 & T2. its showing #DIV/0! for U2. Even I have values in the cells y cant it add.

Is there anything to do to fix this???

Comment on Problem with Spreadsheet::ParseExcel Select or Download Code

Replies are listed 'Best First'.
Re: Problem with Spreadsheet::ParseExcel by poj (Abbot) on Nov 30, 2015 at 15:33 UTC
See known problems in Spreadsheet::ParseExcel::SaveParser `"formulas aren't rewritten, only the result of a formula is written."` poj	[reply] [d/l]
Re^2: Problem with Spreadsheet::ParseExcel by ravi45722 (Pilgrim) on Dec 01, 2015 at 06:27 UTC
Then to write a formulae what we can do???	[reply]
Re: Problem with Spreadsheet::ParseExcel by Anonymous Monk on Nov 30, 2015 at 07:41 UTC
Hi, I think this part is FAQ in the docs where in formulas are not expanded... I leave it up to you to find the cite Cheers	[reply]