copy and pest on linux

[vikram007]

Hi i am not able to get formula calculated value into other cell in excel .

i am using linux os

example

 
A1 =4
A2 =5
A3 = =SUM(A1:A2)

how will i copy calculated value of sum to other cell or retain on the same cell these module i am using .

use Spreadsheet::WriteExcel;
use Spreadsheet::ParseExcel;
use Spreadsheet::ParseExcel::Worksheet;
use Parse::RecDescent;
use Spreadsheet::WriteExcel::Utility;
use Spreadsheet::ParseExcel::SaveParser;
use Spreadsheet::ParseExcel::Cell;

i wanted copy or retain that calculated value of formula at the same cell.

problem: when i am saving excel sheet than i am getting 0 value at formulated cell. i want to retain that calculated value at the same cell

[marto]

Welcome Mr. Bond vikram007. You need to provide more information before anyone can give you a meaningful answer. Describe which modules/tools you are using, show what you have tried. Read and understand PerlMonks for the Absolute Beginner, How do I post a question effectively? and How do I compose an effective node title?.

Update: added last link.

[marto]

Thanks for your update, though it'd be better if the changes to the post were made clear. You post a list of modules but don't show us any of your code (I asked you to read and understand How do I post a question effectively?) which produces the output

Consider updating your post and actually reading the documentation for the modules you're using, for example Spreadsheet::ParseExcel:

"This module cannot read the values of formulas from files created with Spreadsheet::WriteExcel unless the user specified the values when creating the file (which is generally not the case). The reason for this is that Spreadsheet::WriteExcel writes the formula but not the formula result since it isn't in a position to calculate arbitrary Excel formulas without access to Excel's formula engine."

[pvaldes]

not related with your question, but I would suggest to write this:

use Spreadsheet::WriteExcel;
use Spreadsheet::ParseExcel;
use Spreadsheet::ParseExcel::Worksheet;
use Parse::RecDescent;
use Spreadsheet::WriteExcel::Utility;
use Spreadsheet::ParseExcel::SaveParser;
use Spreadsheet::ParseExcel::Cell;

like this:

use Parse::RecDescent;
use Spreadsheet::WriteExcel qw(Utility);
use Spreadsheet::ParseExcel qw(SaveParser Cell Worksheet);

Untested but you can get the idea. If you need more functions from the module simply put its names inside qw(), or use qw(all), or omit the qw part: