Issue with symbol cells alignment

Posted by: krishna.vajja on 28 October 2020, 11:12 pm EST

  • Posted 28 October 2020, 11:12 pm EST

    Hi,
    We are facing issue with symbol cell alignment.
    They are getting distorted when we are opening the attached excel with spread designer.
    We are using spread version 12.45.20193.0
    Also attaching the image which shows how the cells are getting misplaced.


    Regards,
    Krishna Chaitanya.
  • Replied 28 October 2020, 11:15 pm EST

  • Replied 28 October 2020, 11:17 pm EST

    Attaching the sample excel here
  • Replied 28 October 2020, 11:19 pm EST

    Copy of Sample_FarPoint.zip
  • Replied 30 October 2020, 3:32 am EST

    Hello Krishna,

    I could see the problem and it seems to be an issue with the control. So, I have forwarded it to team for fix [ID: 13340].
    We will update you once it is fixed.

    Regards,
    Ruchir
  • Replied 1 December 2020, 7:16 pm EST

    Hi Ruchir,

    Any update on this issue?

    Regards,
    Krishna Chaitanya.
  • Replied 2 December 2020, 7:14 am EST

    Hello Krishna,

    The issue cause by the difference rounding number between cell layout and shape. It happens if the zoomFactor is not integer.

    Here is an example: Row height is 21, Zoom Factor is 1.5 (150%), Shape is cover 2 rows
    For cell layout, the display row height will be ROUND(21*1.5) * 2 = ROUND(31.5) * 2 = 64 => 2 rows will display as 64 pixels
    For shape, the display shape will be calculated as ROUND((21 * 2) * 1.5) = ROUND(42 * 1.5) = 63 => shape will display as 63 pixels

    Unfortunately, this issue is not easy to fix and the team plans to fix it in later release (14E SP1 or 14E SP2)

    Regards,
  • Replied 19 January 2021, 5:01 pm EST

    Hi,

    Our customers are waiting for this issue to be fixed. Can we know the status and availability of this issue?

    Thanks,
    Krishna.
  • Replied 19 January 2021, 5:08 pm EST

    Hi,

    Our customers are waiting for this issue to be fixed. Can we know the status and availability of this issue?

    And also please suggest some workaround for the time being. This might help customers to continue with their work.

    Thanks,
    Krishna.
Need extra support?

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

Learn More

Forum Channels