Beefy Boxes and Bandwidth Generously Provided by pair Networks
The stupid question is the question not asked
 
PerlMonks  

Re: Preserve Excel formulas when using Spreadsheet::ParseExcel

by moklevat (Priest)
on Dec 11, 2007 at 15:14 UTC ( [id://656420]=note: print w/replies, xml ) Need Help??


in reply to Preserve Excel formulas when using Spreadsheet::ParseExcel

It's not clear to me from your node if you mean that the formulas are not preserved, or the values computed from the formulas are not preserved (in other words, the results are not preserved). If you are using Spreadsheet::WriteExcel to write out the Excel binary format, then you should it's important to know that this module does not store results with the formula. The documentation for Spreadsheet::ParseExcel mentions this and notes that the behavior is the same as if you had "Auto Calculation" off.

Update: Changed some language to avoid possible misinterpretation of tone.

Replies are listed 'Best First'.
Re^2: Preserve Excel formulas when using Spreadsheet::ParseExcel
by manimarank (Novice) on Dec 12, 2007 at 04:30 UTC
    Hi, Values computed from the formulas are preserved but the cell formula is not preserved.Is any other module available to do the task other than the above mentioned module?..or can you suggest some other solution to preserve formulas while editing the excel sheet.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://656420]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others perusing the Monastery: (4)
As of 2024-03-29 05:09 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found