#3 Use cell format from XLS

[Marcelo Henrique Cerri]

Hi,

I noticed that antiexcel is not using the current format defined for each cell in the XLS file. For instance, if a cell is defined as a % value, the script still outputs the value as a float-point numeric value.

This can be fixed replacing the following lines:

if ($cell->{Type} eq 'Numeric' ){
    $mycell=$cell->{Val};
} else {
    $mycell=$cell->Value;
};

with:

$mycell=$cell->value();

Thanks for the great work. Antiexcel is very useful.

[Peter Borkuti]

Hi Marcelo,

Thank you for the feedback and the fix. I applied it. You can see it on github:
https://github.com/peterborkuti/antiexcel

I will upload a new version soon.

ps. I totally forgot this app (and I had not use perl in the last 5 years), so now I am very happy that there are users who use this and report bugs and send fixes!

[Marcelo Henrique Cerri]

Nice! I'm using it a lot with mutt.

On 05/12/2013, at 19:38, "Peter Borkuti" borkutip@users.sf.net wrote:

Hi Marcelo,

Thank you for the feedback and the fix. I applied it. You can see it on github:
https://github.com/peterborkuti/antiexcel

I will upload a new version soon.

ps. I totally forgot this app (and I had not use perl in the last 5 years), so now I am very happy that there are users who use this and report bugs and send fixes!

[bugs:#3] Use cell format from XLS

Status: open
Created: Thu Nov 07, 2013 06:52 PM UTC by Marcelo Henrique Cerri
Last Updated: Thu Nov 07, 2013 06:52 PM UTC
Owner: nobody

Hi,

I noticed that antiexcel is not using the current format defined for each cell in the XLS file. For instance, if a cell is defined as a % value, the script still outputs the value as a float-point numeric value.

This can be fixed replacing the following lines:

if ($cell->{Type} eq 'Numeric' ){
$mycell=$cell->{Val};
} else {
$mycell=$cell->Value;
};
with:

$mycell=$cell->value();
Thanks for the great work. Antiexcel is very useful.

Sent from sourceforge.net because you indicated interest in https://sourceforge.net/p/antiexcel/bugs/3/

To unsubscribe from further messages, please visit https://sourceforge.net/auth/subscriptions/

[Peter Borkuti]

I upload antiexcel-1-2.tgz which has your fix.