Error in sum(sheetname!cellname)

Aspose.Cells Product Family
1

Hi,

got some errors in creating sums of different worksheets…

Examples:
Invalid formula: =SUM(Kombi_3-Achser!C15) --> the “-” (minus) is throwing the exception
Invalid formula: =SUM(Kombi 3_Achser!C15) --> the " " (space) is throwing the exception

In Excel self this can done with formula: =SUM(‘Kombi 3-Achser’!C15)
Will this be added soon because of there will be other chars that will throw the same exception…

Thanks for support, Stefan

2

Dear Stefan,

Currently space char, ‘+’, ‘-’, ‘*’, ‘/’ are not supported in sheet name when setting a formula. Please avoid this in your spreadsheet. I will add this support before the end of march. Now thanks for your patience.