We are using Aspose Excel to generate reports. The format of the same is attached along.
We are quite satisfied with the results, however when we try to generate the sum of any of the columns of the generated report, we are unable to do so. For example, in the attached sheet, if we are trying to sum the values of J:5 to J:10, we are getting “0”(Zero) as the value. We even tried changing the format of the column to numeric but could not succeed in getting the desired result.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />
We also have a second issue.
We want to show the negative values in brackets (). Is there any facility to do so?Kindly help us in this regard.