Quotes by setFormula

Aspose.Cells Product Family
1

Hi,


I have a problem when I try to set the formula:


Worksheet worksheet = worksheets.getSheet("Sheet1");

Cell cell = worksheet.getCells().getCell(5, 1);

cell.setFormula("=SUM(Cell1:Cell3)");

…

workbook.save(outputDoc);


Now when I open the file, which seeth formula like this:

=SUMME('Cell1:Cell3')


When I save in excel2007 format:

workbook.save(outputDoc, FileFormatType.EXCEL2007); , the error does not take.

But I need the file format 2003.

The file is attached.


Thanks,

Inna

<o:p></o:p>

2

Hi,

Well, that looks to be the restriction of MS Excel 2003. You can confirm by implementing your scenario manually in MS Excel 2003. On the other hand, MS Excel 2007 handles the formulas having argument like “Cell1”, “Cell2” etc.

Anyways, we will further investigate and get back to you soon. We have logged it into our issue tracking system assigning a ticket (id): CELLSJAVA-16550.

Thank you.