Issues Upgrading from Spread 6 to Spread 10

Posted by: david.weldon on 27 April 2018, 3:01 am EST

    • Post Options:
    • Link

    Posted 27 April 2018, 3:01 am EST

    We just upgraded from version 6 to version 10 and are running into some issues that we did not have with 6.

    • “The biggest issue we have is that rows do not always paint correctly. You can see this in the “Issues 1 and 2” image. We’re having trouble understanding exactly what causes this, but it seems to be related to sorting, merging and changing row visibility. I recreated this in a sample project (attached). There are 2 scenarios here. In the first scenario (Spread Malfunction #1 in the sample project), row 20 does not paint correctly and when you expand it you can see there is actually hidden data that shows up but doesn’t fill the row. This is the most common misbehavior we are seeing. In the second scenario (Spread Malfunction #2 in the sample project), row 16 is cutoff and whitespace is padded at the bottom. Row 17 doesn’t paint correctly. When you resize row 17, it fills the resized space with the contents of row 16.”

    • “The next issue is that we have grids with vertically centered text that rendered correctly in Spread 6. However, after the upgrade, the text is now flush along the bottom of the row. If you resize the row to make it bigger, the text is vertically centered correctly. We could now set the default row height to a larger size to get around this. Unfortunately, that is not ideal for our end users who need to see as much data as reasonably possible.”

    • “The last issue is that when you have a grid with frozen colums and only a few visible rows, when you scroll to the right and then back, unnecessary grid lines are rendered in the dead space below the grid. See the issue 3 image.”

      BrokenSpreadGrid.zip[img]https://gccontent.blob.core.windows.net/forum-uploads/file-08dc3715-466b-490a-ab7d-ff4a9a15a957.png[/img][img]https://gccontent.blob.core.windows.net/forum-uploads/file-c630a889-4925-4eac-8cd7-7b0fb6ccf6a7.png[/img]

  • Posted 29 April 2018, 9:08 pm EST

    Hello,

    I tested these issues with Spread v11.1. latest version and could not replicate the issue.

    Please refer to the attached video.

    I would suggest you to download the latest version from our website and test this issue with the same.

    Thanks,

    Deepak SharmaSpreadUpgradeIssue.zip

  • Posted 30 April 2018, 12:22 am EST

    Actually, I forgot to mention that I already had tried 11. I just tried again just to make sure and do not see any change. These are still issues for me. Perhaps you had an engineering build or something?

  • Posted 30 April 2018, 4:06 am EST

    I have tried this on multiple machines and am seeing the same results as I did before. I am using 11.1 (11.45.20181.0) and each machine is running Windows 10. These results are inconsistent with what you demonstrated in the video. In the video you have sections of unpainted customer and product rows. It’s not clear why those rows were not painted as I did not getting audio for any sort of explanation. My results are the same as described in the initial writeup except for the fact that incorrect rows are painted white now instead of grey. I’m struggling to understand why you are seeing different results.

    Item 3 does seem to have been resolved in the latest release.

    Item 2 (which was not in the demo) was not discussed in your response. You can see that by setting a default row height of 15 in the example.

    Any insight into why this is still a problem for us would be greatly appreciated as it is preventing us from upgrading.

    Thank you.

    –David

  • Posted 2 May 2018, 12:31 am EST

    Hi David,

    1. I see that few cells are not painted correctly. I will discuss this issue with the concerned team and let you know.

    2. The grid lines issue is also not seen with the sample application you provided. I set the frozen column count to 4 but do not see the issue.

    Regards,

    Deepak Sharma

  • Posted 2 May 2018, 2:28 am EST

    Thank you, Deepak. I’ll be looking forward to hearing back on item 1.

    Any thoughts on item 2? Obviously, we can get around it by increasing the row height. But, I’d be curious if there is another solution that doesn’t require increasing the row height (or decreasing the font size) and still getting vertically centered text.

    –David

  • Posted 3 May 2018, 12:28 am EST

    Hello,

    RowHeight issue is not reproducible as you see in the video I provided with my earlier post. Let me know in case you can replicate this issue.

    Also the tracking id for cell paint issue is 257863. I will let you know once I get an update on this.

    Thanks,

    Deepak Sharma

  • Posted 8 May 2018, 8:26 am EST

    Thank you. As I understand it, the issue tracking is only internal and I can’t get access to see the status of an issue. Do you have an estimated timeframe on when I might see a fix?

    Also, the example program I attached did not demonstrate the cell text alignment issue. You can easily see this by setting the row height to 15.

    Thanks,

    –David

  • Posted 9 May 2018, 11:05 pm EST

    Hi David,

    The bug id 257863, will be fixed in our next service pack of Spread .NET v11.

    I am able to replicate the Vertical Alignment issue. I have submitted it as a bug to the development team. The bug id for this issue is 258157.

    Thanks,

    Deepak Sharma

  • Posted 10 May 2018, 5:17 am EST

    Hi Deepak.

    Do you have a rough idea when the next service pack for 11 will be released? Also, is there any chance we could get a service pack to 10 with this fix since that’s the version we’ve been testing with.

    Thank you,

    –David

  • Posted 10 May 2018, 8:45 pm EST

    Hi David,

    For vertical alignment issue #258157, this has been found as the limitation of Spread currently. You can work around the issue using the following code:

    ITextAdjustmentSpacing textAdjustCellType = cellType as ITextAdjustmentSpacing;

    if (textAdjustCellType != null) textAdjustCellType.TextAdjustmentSpacing = 0;

    I don’t think we can get this issue fixed with v10.0 because Spread v10.0 is not under development anymore. I will further check with the development team and let you know.

    Thanks,

    Deepak Sharma

    Thanks,

    Deepak Sharma

  • Posted 24 June 2018, 3:16 pm EST

    Hello,

    This issue is fixed for our next service pack of Spread .NET v11. Which is scheduled to be released in July last week.

    Thanks,

    Deepak Sharma

  • Posted 25 June 2018, 3:55 pm EST

    could you confirm if Spread v6.0 is compatible with .NET 4.5 framework?

  • Posted 25 June 2018, 8:16 pm EST

    Hello,

    According to the Product requirements of Spread 6 .Net 3.5 version it works with .Net Framework 3.5 but it should work with .Net framework 4.5.

    Please try the same and let us know if you face any issue. We will look into this issue thereon.

    Thanks,

    Reeva

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels