We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Hi!
I tried to create an XLS file with the Syncfusion.XlsIO.Wpf 20.4.0.54 package and then load it back to a SfSpreadsheet control.
One cell ("C5" in the sample) contains a date that was created with a formula ("=B5-WEEKDAY(B5)" in the sample) and a custom format ("d"). When I load the created file in Excel, the value is displayed correctly. However if I load the created file into the SfSpreadsheet control, the cell is formatted as a number and the value is wrong. I saw in the changelog that a similar problem was fixed in the 20.4.0.44 version but it still does not work in the 20.4.0.54 package.
Could you please take a look at this?
Thanks in advance,
Mihaly
Hi Mihaly Poor,
We are currently checking your reported issue with provided information and we need two more business days to validate this. We will update you with further details on March 31, 2023.
Regards,
Sathiyathanam
Mihaly Poor,
Still, we are working on this, we need two more business days to validate this.
We will update you with further details on April 04, 2023. We appreciate your
patience and understanding.
Mihaly Poor,
We deeply regret the delay and inconvenience caused.
Still, our development team working on this, and we need two more business days to validate this. We will update you with further details on April 6, 2023. We appreciate your patience and understanding.
Mihaly Poor,
We have checked the reported issue “Display Text is not correct when applied number format is "d" on our end and it is confirmed as a defect. And We have logged a bug. We will fix this issue and include it in our NuGet release Which is scheduled on April 18, 2023.
We will share the feedback link for this on April 10, 2023. We appreciate your patience until then.
Mihaly Poor,
As we mentioned earlier, we have created a bug report for the reported issue “Display text is incorrect while applying the cell number format as d. We will fix this issue and include it in our NuGet release Which is scheduled on April 18, 2023.
You can track the status of this report through the following feedback link,
Feedback Link: https://www.syncfusion.com/feedback/42715/display-text-is-incorrect-while-applying-the-cell-number-format-as-d
Note: The provided feedback link is private, and you need to login to view this feedback.
We appreciate your patience until then.
Mihaly Poor,
We are unable to include the fix for this issue in our NuGet Release which is released today as promised. We will fix this issue and include it in our upcoming NuGet release which is scheduled on April 25, 2023. We will let you know once it is released.
We appreciate your patience until then.
Mihaly Poor,
Weekly NuGet was not released today due to Essential Studio 2023 Volume 1 Service Pack release on next week. We will include the fix in our upcoming Essential Studio 2023 Volume 1 Service Pack release which is expected to be rolled out on next week.
However, we have resolved the issue Display Text is not correct when applied number format is "d" and generated custom NuGet in the version 21.1.41 under .NET Framework 4.6. This custom NuGet can be downloaded from below link.
Note: First, we need to install the XlsIO custom NuGet before then after that only Syncfusion.SpreadSheet.WPF nuget.
Limitation in Microsoft Excel: Microsoft Excel treats 1900 as leap year which is not a
correct behaviour. Also found the documentation for this.
https://learn.microsoft.com/en-us/office/troubleshoot/excel/wrongly-assumes-1900-is-leap-year
We will let you know
once it is released. We appreciate your patience until then.
Mihaly Poor,
Thank you for your
patience.
We are glad to announce that our
Essential Studio 2023 Volume 1 Service Pack Release V21.2.3 is rolled out
with the reported bug fix “Display text is incorrect while applying the cell number
format as d.” and is available for download in nuget.org.
Let us know, if you require further assistance on this
Dear Sathiyathanam Jeyakumar!
I tried to update the packages to the V21.2.3 version. I built and run the sample project I sent you earlier and the issue is still there unfortunately.
When I run the application (check the SfSpreadsheet.Error_eea6a41f.zip file in the attachment of the first message) after a Nuget package update, it creates a cell (B5) with the current date as the value. Then the C5 cell is calculated by a formula ("=B5-WEEKDAY(B5)"). When I open the created "Sample.xlsx" file into the SfSpreadsheet control the value of the C5 cell is still 0 but on June 23 it should be displayed as "17".
Can you check this please?
Thanks in advance,
Mihaly
UPDATE: When I edit the C5 cell (remove the last parenthesis and add it again) and hit enter, the value "17" is displayed correctly.
UPDATE 2: With the V22.1.34 version it even crashes. After selecting the C5 cell and waiting for a few seconds the application crashes. I attached the callStack.txt file to check the call stack.
Hi Mihaly Poor,
We are checking your reported problem with provided information and we need a time to validate this. We will update you with further details on, June 28 2023.
Mihaly Poor,
|
Query |
Comments |
|
|
1.I built and run
the sample project I sent you earlier and the issue is still there
unfortunately. it creates a cell (B5) with the current date as the
value. Then the C5 cell is calculated by a formula
("=B5-WEEKDAY(B5)"). |
We suggest you to enable sheet calculations for the worksheet, before setting the formula. Else, the formulas will not be calculated.
|
|
|
2. With the V22.1.34 version it even crashes. After selecting the C5 cell and waiting for a few seconds the application crashes. |
We have created a new forum thread (183166) for this ComboBoxAdv query. Please follow forum 183166 for further updates. Link : https://www.syncfusion.com/forums/183166/custom-date-format-error-from-181449 |
