PEAR Forum :: PHP Extension and Application Repository

PEAR Forum Forum Index
 FAQFAQ   SearchSearch   MemberlistMemberlist   RegisterRegister   ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 
Spreadsheet Excel Writer: Workaround for formula error?

 
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    PEAR Forum Forum Index -> General PEAR questions
View previous topic :: View next topic  
Author Message
mpemburn



Joined: 13 Jan 2008
Posts: 1
Location: Bel Air, MD USA

PostPosted: Sun Jan 13, 2008 4:36 pm    Post subject: Spreadsheet Excel Writer: Workaround for formula error? Reply with quote

Hi,

I've been beating my brains against a problem with Spreadsheet Excel Writer "writeFormula" method and I'm hoping someone here knows of a workaround. Here's the deal:

When my users select a range of records in my data-based application, I use Spreadsheet Excel Writer to create a bunch of worksheets in a single workbook. Each worksheet has a number of column totals that I need to reference in a "Totals" worksheet. So, let's say that the "Policy Premiums" total appears in cell C8 of worksheet "Fred_Jones". I want to go to a given cell on the "Totals" worksheet and insert the reference:

=Fred_Jones!$C$8

I can do this manually and it works like a champ. When attempt this with $worksheet->writeFormula, I get the following in the cell instead:

Syntax error: ), lookahead: , current char: 0

I've Googled this error and it looks as if it's an open bug that goes back to sometime in May of 2005. I really, really need to be able to add this functionality to my app -- does anyone have an idea of what to do to make it work?

Thanks in advace,

Mark
Back to top
View user's profile Send private message
Display posts from previous:   
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    PEAR Forum Forum Index -> General PEAR questions All times are GMT + 2 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



PEAR Forum topic RSS feed 
Powered by phpBB © 2001, 2005 phpBB Group

Provided by Ministry of Web developement