Analyzing your prompt, please hold on...
An error occurred while retrieving the results. Please refresh the page and try again.
Preserve Single Quote Prefix of Cell Value or Range
Contents
[
Hide
]
Possible Usage Scenarios
When you put a value inside a cell that has a leading apostrophe or single‑quote mark, Microsoft Excel hides it, but when you select the cell, it displays the leading apostrophe or single quote in the formula bar, as shown in the following screenshot.
Aspose.Cells for Python via .NET also hides the leading apostrophe or single quote like Microsoft Excel, but it sets the Style.quote_prefix property to true for that cell. If you apply an empty style to the cell, then Style.quote_prefix becomes false again. To address this, Aspose.Cells for Python via .NET provides the Style.quote_prefix property; when it is set to false, the property is not updated and its previous value is preserved. That means if the previous value of Style.quote_prefix was true, it will remain true, and if it was false, it will remain false.
Preserve Single Quote Prefix of Cell Value or Range
The following sample code explains the usage of the Style.quote_prefix property as described previously. Please read the comments inside the code and see the console output below for more help.
Sample Code
Console Output
Quote Prefix of Cell A1: False
Quote Prefix of Cell A1: True
When StyleFlag.QuotePrefix is False, it means, do not update the value of Cell.Style.QuotePrefix.
Similarly, when StyleFlag.QuotePrefix is True, it means, update the value of Cell.Style.QuotePrefix.
Quote Prefix of Cell A1: True
Quote Prefix of Cell A1: False