Specify Custom Number Decimal and Group Separators for Workbook with C++

In Microsoft Excel, you can specify the Custom Decimal and Thousands Separators instead of using System Separators from the Advanced Excel Options, as shown in the screenshot below.

Aspose.Cells provides the WorkbookSettings.GetNumberDecimalSeparator() and WorkbookSettings.GetNumberGroupSeparator() properties to set the custom separators for formatting/parsing numbers.

Specifying Custom Separators using Microsoft Excel

The following screenshot shows the Advanced Excel Options and highlights the section to specify the Custom Separators.

Specifying Custom Separators using Aspose.Cells

The following sample code illustrates how to specify custom separators using the Aspose.Cells API. It sets the custom number decimal and group separators to a dot and a space, respectively.

C++ code to specify custom number decimal and group separators

#include <iostream>
#include "Aspose.Cells.h"
using namespace Aspose::Cells;

int main()
{
    Aspose::Cells::Startup();

    // Source directory path
    U16String srcDir(u"..\\Data\\01_SourceDirectory\\");

    // Output directory path
    U16String outDir(u"..\\Data\\02_OutputDirectory\\");

    // Create a new workbook
    Workbook workbook;

    // Specify custom separators
    workbook.GetSettings().SetNumberDecimalSeparator(u'.');
    workbook.GetSettings().SetNumberGroupSeparator(u' ');

    // Get the first worksheet
    Worksheet worksheet = workbook.GetWorksheets().Get(0);

    // Set cell value
    Cell cell = worksheet.GetCells().Get(u"A1");
    cell.PutValue(123456.789);

    // Set custom cell style
    Style style = cell.GetStyle();
    style.SetCustom(u"#,##0.000;[Red]#,##0.000", true);
    cell.SetStyle(style);

    // Auto-fit columns
    worksheet.AutoFitColumns();

    // Save workbook as PDF
    workbook.Save(outDir + u"CustomSeparator_out.pdf");

    std::cout << "Workbook saved successfully with custom separators!" << std::endl;

    Aspose::Cells::Cleanup();
}