Free Support Forum - aspose.com

Formula with Ampersand (&)

Hi,

I am trying to use a formula such as "Online Store Purchase Invoice No " & A2

where A2 is a CELL reference,
which works in Excel but generates an error when using Aspose Excel.

Could you check this out for me?? I am using 1.8.3.0

Thanks,
Alex.

Hi Alex,

I have fixed this problem but the fix is not released yet. It will be available before the start of next week.

If you are in urgent need of it, please let me know.

Can wait, thanks Laurence.

Hi Alex,

Please download hotfix 1.8.7 and have a try.

Thanks Laurence - seems to work fine except that text is converted to uppercase???

eg:
="Online Order No " & A1

converts to the following in Excel using Aspose.Excel (as an example):
ONLINE ORDER NO 005

Can you check that out for me?
Thanks,
Alex.

Sorry, a small bug.

Please download hotfix 1.8.7.1 and have a try.