When type in False, the cell is auto converted to FALSE

[crosslife]

As showed in the image.

[Santhosh Govindasamy]

Hi crosslife,

We would like to inform you that when you type "False" in a cell in a spreadsheet, it will be automatically converted to "FALSE" because the spreadsheet recognizes "False" as a boolean value as per MS Excel standards. Spreadsheet designed to interpret certain keywords like "True" and "False" as boolean values, which are used in logical operations and functions within the sheet. This behavior helps ensure consistency and proper functionality when performing calculations that involve logical conditions.

Please let us know if you need further assistance; we are happy to help you.

Regards,

Santhosh.G

[crosslife]

Is there an option can control this behivour?

Like the following.

filterRange.NumberFormat = "@";

[Santhosh Govindasamy]

Hi crosslife

We are currently analyzing the scenario you reported. We need time to validate it, and we will provide an update on or before July 25, 2024.

Regards,
Santhosh.G

[Santhosh Govindasamy]

Hi crosslife,

We have checked the reported issue "Typing 'False' automatically converts the cell to 'FALSE' in WPF Spreadsheet" 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 August 20, 2024.

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

Feedback Link: https://www.syncfusion.com/feedback/59848/typing-false-automatically-converts-the-cell-to-false-in-wpf-spreadsheet
 

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

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,
Santhosh.G

[Santhosh Govindasamy]

Hi crosslife,

We regret the inconvenience.

We are unable to include the fix for this issue in our NuGet package released. We will fix this issue and include it in our upcoming Weekly NuGet release scheduled for August 27, 2024.

Regards,
Santhosh.G

[Santhosh Govindasamy]

Hi crosslife,

We would like to let you know that Essential Studio Weekly NuGet packages (v26.2.11) has been published in nuget.org with the fix for the issue “Typing 'False' automatically converts the cell to 'FALSE' in WPF Spreadsheet”. Please let us know if you have any concerns in this.

Root Cause:​
In the current implementation of the SfSpreadsheet, the Excel Range "Value" is assigned to the current cell's value. Currently, the Excel Range "Value" automatically converts the input "true" or "false" into Boolean values (TRUE or FALSE), even when the cell type is set to "Text" format. To address this issue, I have assigned the Excel Range "Text" to the current cell's value and ensured that it is always treated as text when the Format Type is set to "Text."

Regards,
Santhosh.G