Forums Home / Spread / Spread for WinForms
Posted by: krishna.vajja on 28 October 2020, 11:12 pm EST
krishna.vajja
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.
krishna.vajja
Posted 28 October 2020, 11:15 pm EST - Updated 30 September 2022, 4:20 am EST
krishna.vajja
Posted 28 October 2020, 11:17 pm EST
Attaching the sample excel here
krishna.vajja
Posted 28 October 2020, 11:19 pm EST
Ruchir.Agarwal
Posted 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
krishna.vajja
Posted 1 December 2020, 7:16 pm EST
Hi Ruchir,
Any update on this issue?
Regards,
Krishna Chaitanya.
Ruchir.Agarwal
Posted 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,
krishna.vajja
Posted 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.
krishna.vajja
Posted 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.
jitender.yadav
Posted 20 January 2021, 5:59 pm EST
Hi Krishna,
The fix will be available in Spread 14 SP1 release (expected in May).
Unfortunately, there is no workaround for this since the issue is in internal layout.
If you are going to upgrade to Spread 14 before release of SP1, then we can create a hotfix build for you.
Regards,
Jitender
krishna.vajja
Posted 2 May 2021, 5:52 pm EST
Hi,
Want to check if we are getting the fix this month as you said it would be in may.
We have also upgraded to SP14 a couple of weeks back.
Awaiting the response.
jitender.yadav
Posted 6 May 2021, 3:35 pm EST
Hi,
Yes, the SP1 release is scheduled for 20 May.
Regards,
Jitender
jitender.yadav
Posted 20 May 2021, 6:36 pm EST
Hi,
Spread 14 SP1 is released now. You can download the latest installer from this page:
https://www.grapecity.com/spreadnet/download
Let us know if you still face any issues.
Regards,
Jitender
jitender.yadav
Posted 25 May 2021, 10:46 pm EST
Hi,
It seems the installer is not updated with the new builds.
Please use the following direct download links for the offline installer:
https://cdn.grapecity.com/SpreadNET/installer/14.1.20211.0/offlineDownload.zip (WinForms only)
https://cdn.grapecity.com/SpreadNET/installer/14.1.20211.0/offlineDownload_Full.zip
Regards,
Jitender
