Hi,
I am running version 11.11. of Aspose.Words (because of .NET 1.1, soon to upgrade )
If I mail merge a document (or update fields) with the following,
Row 1 | £1000.00 |
---|---|
Row 2 | > £1000.00 |
Row 3 | £1000.00 |
Total | { =SUM(B1,B2,B3) } |
The total is correctly £3000
if there is more than one entry in a cell (and I need this for when using mergefields that do not exist, that should not cause empty lines), the total does not work
i.e.
Row 1 | £1000.00 |
---|---|
Row 2 | £1000.00 £50.00 |
Row 3 | £1000.00 |
Total | { =SUM(B1,B2,B3) } |
reports £2000 in hte total, as row 2 is ignored.
Word correctly adds these up, you can put any number of values in one cell
I also notice that one of the values must be a mail merge field for this to work, this is fine as I use them, a user update is required in word otherwise. Please see the working and not working examples that both contain mail merge fields.
Is this something that can be included with version 11.11, or only the newer 13.x for > .net 1.1
I have not tried this on 13.x
Kind Regards
Chris