Show leading apostrophe in cells

Show leading apostrophe in cells

In Microsoft Excel, the leading apostrophe in the cell’s value is hidden. Aspose.Cells provides the feature to display the apostrophe by default. For this, the API provides Workbook.Settings.QuotePrefixToStyle property. This property indicates whether to set the QuotePrefix property when entering string value starting with a single quote to the cell. Setting the Workbook.Settings.QuotePrefixToStyle property to false will display the leading apostrophe in the output excel file.

The following screenshot shows the output excel file with the visible apostrophe.

The following code snippet demonstrates this by adding data with Smart Markers in the source excel file. The source and output excel files are attached for reference.

Source File

Output File

Sample Code

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-Java
//directories
String sourceDir = Utils.Get_SourceDirectory();
String outputDir = Utils.Get_OutputDirectory();

// Instantiating a WorkbookDesigner object
WorkbookDesigner designer = new WorkbookDesigner();

Workbook workbook = new Workbook(sourceDir + "AllowLeadingApostropheSample.xlsx");
workbook.getSettings().setQuotePrefixToStyle(false);

// Open a designer spreadsheet containing smart markers
designer.setWorkbook(workbook);

ArrayList<DataObject> list = new ArrayList<>();
list.add(new DataObject(1, "demo"));
list.add(new DataObject(2, "'demo"));

// Set the data source for the designer spreadsheet
designer.setDataSource("sampleData", list);

// Process the smart markers
designer.process();

designer.getWorkbook().save(outputDir + "AllowLeadingApostropheSample_out.xlsx");

The implementation of DataObject class is given below

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-Java
public class DataObject
{
    private int id;
    private String name;

    public DataObject(int id, String name)
    {
        this.id = id;
        this.name = name;
    }

    public int getId()
    {
        return this.id;
    }

    public void setId(int value)
    {
        this.id = value;
    }

    public String getName()
    {
        return this.name;
    }

    public void setName(String value)
    {
        this.name = value;
    }
}