Spudsoft excel emitter: how to get Excel formula?

[color=rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;]Hi,[/color] 
 
[color=rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;]I am trying to get a formula working in the excel file I create using the Spudsoft emitter (ExcelEmitter.Formula). However: everything I try does not result in any formula in the output. Could you give me an example of a BIRT design that contains an Excel formula in the output?[/color] 
 
[color=rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;]Thanks for your support.[/color] 
 
[color=rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;]Kind regards,[/color] [color=rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;]Mikey[/color]

Find more posts tagged with

Comments

kclark

I haven't tried using a forum la with the spudsoft emitter. In his repo, he does talk about needing to leave out the leading = Can you provide an example of a formula you're trying to use?

MikeyD

Hi Kristopher, Thanks for your reply. I have tried several things (including leaving out the = sign). I can't even get a simple formula like "A1+B1" to work, so any example of a formal that does work would be very welcome. Kine regards, Mikey

emilito911

hello, im also trying to do it but in my case i have a crosstable(several crosstables with spudsoft and i want to sum every row at the right and every column at the bottom any idea?
 
and thanks for reading

nvinaykalyan

Hi Kristopher Clark,
 
I am also tried to send macros or formula's to Excel ouput file.is that is possible in BIRT?
 
if possible can i have sugesstion on how to pass the macros or formula's to Excel ouput file
 
Thanks in advance
 
Regards
Vinaya Kalyan

JFreeman

Looking through the <a data-ipb='nomediaparse' href='https://bitbucket.org/yaytay/spudsoft-birt-excel-emitters/wiki/UserProperties'>UserProperties documentation</a> for the spudsoft emitter, it does appear that there are some options available for passing formulas to the excel output.
 
I would start there for outputting formulas.