Currency Formatting Issues with Excel and Data Only Excel

raguraman.vayanakkan · August 22, 2013, 12:47pm

We are using Aspose.Cells for Reporting Services SSRS2008 R2 V1.9.0.39, We have purchased the SITE OEM License for this product.

There are 3 issues identified below with the Aspose.Cells for Reporting Services with Excel2007 and Excel Data Only Renderers.

The Aspose Data Only output column width is not set to the width specified. This is happening only on Aspose Data Only Renderer / Excel2007SimpleXlsxRenderer, and the Excel XLSX render works fine with the same settings.
If there is a line feed / Carriage Return within a field, its causing either a special character that is shown in place of the line feed or appends them without the line feed. This is happening only on Aspose Data Only Renderer / Excel2007SimpleXlsxRenderer, but the Excel XLSX render works fine with the same settings.
The Field Format types are messing up the Currency values – The issues below are happening for both Excel2007XlsxRenderer and Excel2007SimpleXlsxRenderer renderers

a. When the Currency Field in the RDL is defined with formatting of C2 and when the data is zero dollar like $0 its outputting the value as $$

b. When the Currency Field in the RDL is defined with formatting of C2 and when the data is a “Positive Dollar” amount like $123 its outputting the value as $123$

c. When the Currency Value in the RDL is defined with formatting of C2 and when the data is a “Positive Dollar” amount like $123.45 its outputting the value as $123$ and on top it chopped off the cents.

d. When the Currency Field in the RDL is defined with formatting of C2 / C4 and when the data is a “Negative Dollar” amount like -$123.45 its outputting the value as ($123) which is correct but chopping off the cents

e. When the Currency Field in the RDL is defined with formatting of Currency and when the data is a “Negative Dollar” amount like -$123.45 its outputting the value as ($123.45) which is not correct and it should be ($123.45)

The expectations are based on en-US formats.

These are currently identified during our QA cycle and we need resolution ASAP as this build is moving towards PRD release coming shortly.

The attached ZIP contains the RDL which demostrates these issues, and the Excel Outputs from the same.

The configurations in RSReportServer.Config

Excel

EXCEL_UNFORMATTED

True

False

true

False

We need these to be resolved for us to promote our recent changes with Aspose.Cells to Production.

Thanks,

Ragu…

shakeel.faiz · August 23, 2013, 12:38am

Hi,

Thanks for your posting and using Aspose.Cells for Reporting Services.

We have logged this issue in our database for investigation. We will look into it and update you. Once, there is some fix or update for you, we will let you know asap.

This issue has been logged as SSRS-40125.

amjad.sahi · August 26, 2013, 3:52am

Hi,

For 1,2:

Aspose Data Only Renderer / Excel2007SimpleXlsxRenderer only exports data and data values format and does not support to other calculations.

For 3:

We have found the issues and fixed them.

Please try the fixed version : Aspose.Cells for Reporting Services (SSRS2008R2). Please copy Aspose.Cells.ReportingServices.dll into following folder : ${SQL Server 2008 R2 Reporting Services}\Reporting Services\ReportServer\bin.

Please let us know your run result.

Thank you.

raguraman.vayanakkan · August 26, 2013, 1:03pm

Hi Amjad,

We are not seeing the link to download the HotFix release. Can you please provide the link to download the latest release? Once downloaded we will test and confirm the item 3.

On the Item 1. The width should be handled by the Aspose. It makes it difficult for the End users to look into the data with out expanding all the columns manually. This is not related to Formatting but the size of the column width. We are not expecting any Aspose to have a fix for this one to output the data only format to have the width specified in the RDL, like in regular excel.

On the Item 2. There are no specific special formating specified here as well. But the data output by the report is altered by the Data Only renderer in this case. I understand the point that its a data only renderer, and it just gets the data part. But at the same time the data value shouldnt change without any specific formatting specified.

We are expecting the Aspose to fix the items 1 and 2 as well, either directly or based on a configuration at the Device Info level. This is critical for us to not to go through and modifiy the 100s of reports that we have.

Thanks,

Ragu...

amjad.sahi · August 26, 2013, 1:27pm

Hi,

Well, I attached the new version/fix : Aspose.Cells for Reporting Services v1.9.0.44 in the forum post, so you need to open the thread (after log in) and get it from my previous post.

<a href="

Alternatively, please download it (Aspose.Cells for Reporting Services v1.9.0.44) here

Let us know your feedback with details.

Thank you.

raguraman.vayanakkan · August 26, 2013, 5:57pm

Thanks Amjad for providing the link to download... Didnt notice the ZIP attachment, as we got used to getting a link before.

You may have noticed our response to the Item 1 and 2 that was reported in the original chain. We are still waiting for an answer on those two items.

Thanks,

Ragu...

amjad.sahi · August 27, 2013, 2:23am

Hi,

Good to know that you are now able to download / get the new fix.

raguraman.vayanakkan:

On the Item 1. The width should be handled by the Aspose. It makes it difficult for the End users to look into the data with out expanding all the columns manually. This is not related to Formatting but the size of the column width. We are not expecting any Aspose to have a fix for this one to output the data only format to have the width specified in the RDL, like in regular excel.

On the Item 2. There are no specific special formating specified here as well. But the data output by the report is altered by the Data Only renderer in this case. I understand the point that its a data only renderer, and it just gets the data part. But at the same time the data value shouldnt change without any specific formatting specified.

We observed your provided details on issues 1) and 2). I have already logged your comments against your issue id "SSRS-40125". Our concerned developer will look into it and we will get back to you soon.

Thank you.

shakeel.faiz · August 27, 2013, 3:11am

Hi,

We have found the issues and fixed them.

Please try the fixed version: Aspose.Cells for Reporting Services (SSRS2008R2) V1.9.0.45.

Please copy Aspose.Cells.ReportingServices.dll into following folder :

${SQL Server 2008 R2 Reporting Services}\Reporting Services\ReportServer\bin.

Please let us know run result.

raguraman.vayanakkan · August 27, 2013, 10:15am

Thanks Shakeel for a quick response on the Items 1 and 2, we have downloaded that and tested with our Static RDL and found that its working. We will continue our testing with our existing reports.

For the Item 3, items reported to Aspose and fixed in the version 1.9.0.44 seems to be working. However when we tested that with our reports we found on additional issue.

When the Formatting is specified as "c" - lower case c, the negative data values are displayed with the minus sign at the front. For example -$123.45 was output as -$123.45, this is expected to be output as ($123.35). This is happening on Aspose Excel XLSX Renderer and Data Only Renderer.

We have noticed that "c" - lower case is working fine in the Microsoft Excel Render. And "C" - upper case is working fine in all formats of Aspose.

Can we have a fix for this and make sure the formatting works fine regardless of the case of the format, whether its a lower case of upper case C.

The Static RDL and the report outputs are attached here as Iteration 3.zip.

Thanks,

Ragu...

shakeel.faiz · August 27, 2013, 11:20am

Hi,

Thanks for your posting and using Aspose.Cells for Reporting Services.

We have logged your comments in our database. We will look into it and fix this issue. Once, the issue is fixed or we have some other update for you, we will let you know asap.

shakeel.faiz · August 28, 2013, 1:54am

Hi,

We have found the issues and fixed them.

Please try the fixed version: Aspose.Cells for Reporting Services (SSRS2008R2) V1.9.0.46.

Please copy Aspose.Cells.ReportingServices.dll into following folder :

${SQL Server 2008 R2 Reporting Services}\Reporting Services\ReportServer\bin.

Please let us know run result.

raguraman.vayanakkan · August 28, 2013, 3:10pm

Thanks for the quick fix again Shakeel. We tested this fix the Static RDL and one of the report and its working. We can close the Currency Formatting issues reported so far.

Appreciate the quick responses from Aspose, Please note that we are in the middle of a QA cycle and there may be some additional items that we may bring it to Aspose for similar quick Hot Fixes.

We appreciate it.

Thanks,

Ragu...

shakeel.faiz · August 29, 2013, 12:30am

Hi,

Thanks for your posting and using Aspose.Cells for Reporting Services.

It is good to know that your issues are resolved with the above fixes. We have closed this thread. If you encounter any newer issues, please create new threads. We will look into your issues and help you asap.

aspose.notifier · March 19, 2014, 3:23am

The issues you have found earlier (filed as SSRS-40125) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.