Beefy Boxes and Bandwidth Generously Provided by pair Networks
There's more than one way to do things
 
PerlMonks  

Re: percentage problem

by NetWallah (Abbot)
on Oct 17, 2012 at 15:21 UTC ( #999560=note: print w/replies, xml ) Need Help??


in reply to percentage problem

Use a formula like this one from the documentation:
$worksheet->write('A12', '=A3 + 3*A4' ); # write_formula() # For your case, # Use my $format = $workbook->add_format(); # Create a percentage +format (Do some research here) $worksheet->write('A6', '=(A4+100)*100/(A5+200)' ,$format ); # + write_formula()

             I hope life isn't a big joke, because I don't get it.
                   -SNL

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://999560]
help
Chatterbox?
[Lotus1]: belg4mit are you on a Linix server?
[belg4mit]: yes. the regular expression is generated in code from a text file. that s the regular expression that Perl blows up when it reaches it, but if I use it from the comman line it's fine
[belg4mit]: oh, wait, damn, different lne number
[choroba]: same Perl version?
[choroba]: oh, ok
[belg4mit]: I had \Q'd in one RE but not a subsequent one, doh
[talexb]: Programs writing programs. Neat stuff.

How do I use this? | Other CB clients
Other Users?
Others perusing the Monastery: (8)
As of 2017-04-25 16:47 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    I'm a fool:











    Results (460 votes). Check out past polls.