Improper fill series behavior when the NumberFormat is set as Text ~ Split from F195333

[crosslife]

However, in the demo project I created, it shows a different behavior.

see the code and attachment video.

Attachment: 20241128200126_WindowShot_8406732e.zip

[Sreemon Premkumar Muthukrishnan]

Hi crosslife,

Thank you for sharing the code snippet and video reference, which clearly illustrate the reported issue.

Regarding the fill series issue observed in the second video, we were able to replicate the problem when the NumberFormat is set to Text. However, without this setting, the issue does not occur.

We are currently investigating this at the source level to identify the root cause. This requires additional time for validation, and we will provide you with further updates by December 03, 2024.

We appreciate your understanding and patience.

Regards,
Sreemon Premkumar M.

[Sreemon Premkumar Muthukrishnan]

Hi crosslife,

We are still working on validating the reported issue at the source level. The issue occurs because an internal property does not receive the proper value. We are investigating this internally and will provide further details on or before December 05, 2024.

We appreciate your patience in the meantime.

Regards,
Sreemon Premkumar M.

[Sreemon Premkumar Muthukrishnan]

Hi crosslife,

We have confirmed the issue as "HasString returns wrong value when text format is applied in cell containing number value." and logged a defect report. We will include the fix for this issue in our upcoming weekly NuGet release scheduled for December 24, 2024.

We will update the feedback details tomorrow.

Regards,
Sreemon Premkumar M.

[Sreemon Premkumar Muthukrishnan]

Hi crosslife,

We have created a bug report for the reported issue “Fill Series Loading with Empty Cells When the Number Format Is Applied to Text after setting Numeric Value”. We will include this fix in our upcoming Weekly NuGet release which is scheduled for December 24, 2024.

You can track the status of this report through the following feedback link,

Feedback Link: Fill Series Loading with Empty Cells When the Number Format Is Applied to Text after setting Numeric Value in WPF | Feedback Portal

Note: The provided feedback link is private, and you need to login to view this feedback.

We will let you know once it is released. We appreciate your patience until then.

Disclaimer: Inclusion of this solution in the weekly release may change due to other factors including but not limited to QA checks and works reprioritization.

Regards,
Sreemon Premkumar M.

[Sweatha Bharathi]

Hi crosslife,

We regret for the inconvenience.

 

We are unable to include the fix for this issue in our NuGet package which is released today as promised. We will fix this issue and include it in our upcoming weekly NuGet release scheduled for December 31, 2024.

We will inform you once it is released. We appreciate your patience until then.

Regards,

Sweatha.B

[Rabina Murugan]

Hi crosslife,

We sincerely apologize for the inconvenience caused. Unfortunately, we are unable to include  fix in today's weekly release due to breaks encountered during testing. As a result, we had to revert the changes at the last minute. However, we assure you that this fix will be included in the upcoming weekly release scheduled for January 7, 2025.

Thank you for your patience and understanding.

Regards,

Rabina

[Sweatha Bharathi]

Hi crosslife,

We would like to let you know that Essential Studio Weekly NuGet packages (v28.1.38) has been published in nuget.org with the fix for the issue “Fill Series Loading with Empty Cells When the Number Format Is Applied to Text after setting Numeric Value”. Please let us know if you have any concerns in this.

 

Root Cause:

As per Microsoft Excel's behavior, when applying a text number format to a cell containing a number, the value is considered as text. Currently, XlsIO does not handle this behavior correctly, causing HasString to return false.

Regards,

Sweatha.B