Categories > OpenTBS with XLSX >

Excel Plugin SUM Problem

The forum is closed. Please use Stack Overflow for submitting new questions. Use tags: tinybutstrong , opentbs
By: Graeme
Date: 2008-12-19
Time: 10:48

Excel Plugin SUM Problem

I've been trying for several hours to get the excel plugin to produce the SUM function.

What ever version I use and including the demo version give exactly the same results. I've also tried ito n several servers as well as locally on my development machine.

On the 'Demo' version In the reference bar I get: =SUM(E$4:E13])) when I should get: =SUM(E$4:E13)

I've tried this with Office 2003 and as an xml file in Open Office version 3

Rows are fine but I just can't get SUM to work.

Any advice most welcome - Thank you
By: Skrol29
Date: 2008-12-19
Time: 22:22

Re: Excel Plugin SUM Problem

Hi Graeme,

If you tried with the demo package without any change, then your behavior is strange because it doesn't depend on the Office version.  The XLS result is just produced by PHP and TBS.

Can you precise what is your PHP/TBS versions and what is the snippet of cell that should perform the SUM?

Regards,
By: Graeme
Date: 2008-12-20
Time: 01:48

Re: Excel Plugin SUM Problem

Thank you . I've just tried it using my Apple IMAC and Neo Office. It works perfectly

I've set the standard demo up on two web servers one running php 4 and this one running php 5

http://wealdenbusiness.net/xlsplugin/demo_main.htm

I run the demo and save the result. Then rename the extension .xml and it works perfectly in Neo Office on my Apple IMAC but with Windows XP on my laptop and Open Office latest version 3 I get the results as in my first message.

Thank you very much it's not the plugin thats the problem - something to do with Open Office/XP. Any thoughts would be most welcome

You have an excellent product and I'm very impressed. Again thank you.