You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by Christophe Sauthier <ch...@gmail.com> on 2005/08/11 17:28:48 UTC

Excel file with macro and XP/Excel2003

Hi,

I've been working lately with poi/hssf to generate an excel file, that
contains a macro (I am just adding datas to an existing file that
contains this macro).

I'm using POI 2.5.1-final

The problem that I am facing is that this solution runs perfectly on
Win2000/Excel 2000, but it is not the case under XP/Excel 2003.

The error message complains about "One of many invalid formulas had
been delete" (this is my translation of the french error message). It
also says that Excel has been able to open the file, and to repair it.

Does anybody has a clue to help me ?


Thanks in advance,

     Chris
-- 
Ma vie              |  
Mes images      |  http://www.reponses.net
Mon Wiki          |

---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/


Re: Excel file with macro and XP/Excel2003

Posted by Karl-Heinz Zengerle <ka...@sawag.com>.
Bonjour Christophe.

I think still just Excel97 up to Excel2000 are supported because of
different binary formats.

So you've to take care that your template is a template saved in
Excel2000 format. Excel can save files in elder formats.

Does the error still occur if you take care for that things? If yes then
retest it with a template newly built from the scratch and having the
desired content.

Au revoir,

Karl-Heinz.


Am Do 11.08.2005 17:28 schrieb Christophe Sauthier
<ch...@gmail.com>:

> Hi,
> 
> I've been working lately with poi/hssf to generate an excel file, that
> contains a macro (I am just adding datas to an existing file that
> contains this macro).
> 
> I'm using POI 2.5.1-final
> 
> The problem that I am facing is that this solution runs perfectly on
> Win2000/Excel 2000, but it is not the case under XP/Excel 2003.
> 
> The error message complains about "One of many invalid formulas had
> been delete" (this is my translation of the french error message). It
> also says that Excel has been able to open the file, and to repair it.
> 
> Does anybody has a clue to help me ?
> 
> 
> Thanks in advance,
> 
>      Chris
> -- 
> Ma vie              |  
> Mes images      |  http://www.reponses.net
> Mon Wiki          |
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
> The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/
> 
> 



---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/