Image Rendering of Spreadsheet not honoring settings

We have several complex spreadsheets with macros and other enhancements. We are having issues with the images not getting generated correctly. It seems the font size settings for some items are not being honored as well as the Z-Order.


We have updated the code and invoke the calculate method prior to generating the image but still have issues.

This is a licensed version of the Cells product and we are using version 8.2.0.0.

What can we do to have these issues looked at and hopefully resolved? Unfortunately the spreadsheets are proprietary and I cannot post to a public forum.

Thanks.

Hi Dan,


Thank you for contacting Aspose support.

Unfortunately, we will not be able to properly investigate the matter on our end unless you share a few of your problematic samples along with your source code (most preferably a console application) to replicate the issue. We have marked the this thread private, now only you and Aspose staff could access the thread’s contents & attachments. In case you are still concerned about the privacy of your samples, you can use the contact button on the post window to send an email to babar.raza, and attach your sample to the message. Once the email is sent, please notify us here.

Before you provide the sample spreadsheets and your code, please give a try to the latest version of Aspose.Cells for .NET 8.2.0.3 on your end.

I have provided you the information requested via the contact.

Hi Dan,


Thank you for providing the requested material. I have downloaded the archive and currently looking into the matter. Please spare us little time to evaluate the said problem. In case we need more information, we will let you know.

Excellent, thank you for the prompt response. This is one of the reasons we chose Aspose as a foundation for our new product – knowing you would aggressively pursue and fix issues (which you have already done in the past while we were evaluating the product).

Hi Dan,


Thank you for your nice gesture.

We will try our best to provide the fix for the identified issues at earliest possible. Please note, we have logged 9 tickets based on the presentation file shared via private message highlighting the issues. The details for these aforesaid tickets is are follow.

  1. CELLSNET-42996: White grid lines are rendered as black
  2. CELLSNET-42997: Background color changed to white
  3. CELLSNET-42998: Text in shape isn’t rendered properly
  4. CELLSNET-42999: Conditional formatting arrows are smaller in size
  5. CELLSNET-43000: Graph has changed the position
  6. CELLSNET-43001: Formula based values are rendered as N/A
  7. CELLSNET-43002: Shapes overlapping text
  8. CELLSNET-43003: Text in shape renders upside down
  9. CELLSNET-43004: Stop Light Indicators render as #N/A

Please also refer to the attached snapshots that we have provided to the core development team for further investigation & correction purposes, and feel free to write back in case we have missed anything or you have further concerns.

Hi Dan,


This is just to update you that we are working to provide the fix for all of the mentioned issues, whereas the problems related to the formula calculation are already fixed. However, we have met a strange behavior of MS Excel application for your provided spreadsheet.

Please check the worksheet Burndown-Projections in MS Excel.

Cell Value
M2 PROJECTED
M170 1.75
M171 1.75
M172 -0.00000000000000022204 (format as 0.00000000000000000000)
The formula of Cell M172 is =IF(M$2=“Projected”,M171-M170,…), as the value of M2 equals “Projected” so the value of M172 should be the result of M171-M170. Aspose.Cells calculate M172 as 0 but MS Excel returns it as -0.00000000000000022204. You may simply test this behavior by replacing the formula in M172 with =(M171-M170) the result would be the same as stated above. However, if you replace the formula with =M171-M170 (without the parenthesis) the result would be correct; that is 0.

The reason for bringing this case to you knowledge is that we may not be able to fix the aforesaid problem very soon because this issue requires detailed analysis. After investigation we will be in a better position to comment if the problem can be fixed, and if yes, how much time will be required to accomplish this task.

Hi. I forwarded the issue on to the spreadsheet member that created this. He will work on this but confirmed that it is an issue. It is something odd that Excel is doing.


Recommendation is to treat or work the value as 0 for this entry.

[EDITED HERE]… Essentially, if you want a quick work around to the formula/Excel issue, entering 0.0 in cell M172 should resolve the issue and allow continued work.

Thanks,
Dan

Hi Dan,


Thank you for the confirmation on this. As stated in our previous response, Aspose.Cells API is behaving correctly (yielding expected results) in the presented scenario therefore no more work will be required in this reference.

Regarding other mentioned issues, as soon as we receive more updates, we will post here for your kind reference.

Hi Dan,


Thank you for your patience with us.

Please try the latest version of Aspose.Cells for .NET 8.2.1.2 against the problems logged earlier as;

  • CELLSNET-42996: White Grid Lines are rendered Black
  • CELLSNET-42999: Conditional Formatting arrows are smaller in size
  • CELLSNET-43002: Shape overlapping the text
  • CELLSNET-43003: Text in shape renders upside down

Please let us know of your feedback so we may close the tickets.

Hi Dan,

Thanks for using Aspose.Cells.

We have also fixed the following issues.

  • CELLSNET-43004: Stop Light Indicators render as #N/A
  • CELLSNET-43001 - Formula based values are not rendered when spreadsheet is converted to image

Please download and try the latest version: Aspose.Cells
for .NET v8.2.1.2
and let us know your feedback.

Thank you for the excellent work. See below for the status of each of the items.

  • CELLSNET-42996: White Grid Lines are rendered Black – FIXED.
  • CELLSNET-42999: Conditional Formatting arrows are smaller in size – FIXED.
  • CELLSNET-43002: Shape overlapping the text – FIXED.
  • CELLSNET-43003: Text in shape renders upside down – FIXED; However, the text is still not rendering correctly. The text in right box should be left justified. It also appears that the text is somehow the wrong size since the top right box is actually missing the title caption (Key Takeaways)

From what I have seen, things are looking very good. We really appreciate the effort the team is putting in to get these things corrected.

[quote user=“mshakeel.faiz”]Hi Dan,

Thanks for using Aspose.Cells.

We have also fixed the following issues.

  • CELLSNET-43004: Stop Light Indicators render as #N/A
  • CELLSNET-43001 - Formula based values are not rendered when spreadsheet is converted to image

Please download and try the latest version: Aspose.Cells
for .NET v8.2.1.2
and let us know your feedback.
[/quote]


I agree, these have also been completed – again, outstanding work.

Dan

The team is doing great and I just wanted to provide a quick follow up/summary of where things are.


As of now, I see 3 items still open: 42997, 42998, and 43000.

I would like to add that it appears 43000 is actually pretty close. The only remaining item that I see when viewing the image is the dollar value labels that accompany the “yellow” line. The rendered image is a vertical, large box instead of the thinner, fitting box. Additionally, the $0 boxes should not display. Everything else appears to render as expected.

Thanks again,
Dan

Hi Dan,

Thanks for your feedback and using Aspose.Cells.

For your remaining issues that are unresolved, we are still working on them and once, these are resolved, we will update you by posting a fix in this thread. Please spare us some time. Once, the next fix is available for you, we will let you know asap.

The issues you have found earlier (filed as CELLSNET-43003;CELLSNET-43002;CELLSNET-42999;CELLSNET-42996;CELLSNET-43004;CELLSNET-43001) have been fixed in this update.


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

Thank you for the update.


Is there any status on the remaining 3 items: 42997, 42998, and 43000?


Hi Dan,


Thank you for your patience with us.

Rest of the problems are proving to be complex that is the reason we currently do not have a concrete release schedule for these issues. As soon as we receive more updates in this regard, we will post here for your kind reference.

@danpierce

for the issue CELLSNET-42997: Background color changed to white.

It is OK in the latest fix v21.6.5.

Aspose.Cells21.6.5 For .Net2_AuthenticodeSigned.Zip (5.5 MB)
Aspose.Cells21.6.5 For .Net4.0.Zip (5.5 MB)
Aspose.Cells21.6.5 For .NetStandard20.Zip (5.5 MB)

The issues you have found earlier (filed as CELLSNET-42997) have been fixed in this update. This message was posted using Bugs notification tool by simon.zhao