在用 C++ 设置样式的 Custom 属性时检查自定义数字格式
Contents
[
Hide
]
可能的使用场景
如果你为 Style.GetCustom() 属性分配了无效的自定义数字格式,Aspose.Cells 不会抛出任何异常。但是,如果你希望 Aspose.Cells 检查所分配的自定义数字格式是否有效,请将 Workbook.GetCheckCustomNumberFormat() 属性设置为 true。
设置 Style.Custom 属性时检查自定义数字格式
以下示例代码为 Style.GetCustom() 属性分配了无效的自定义数字格式。由于我们已经将 Workbook.GetCheckCustomNumberFormat() 属性设置为 true,因此会抛出异常,例如:无效的数字格式。请查看代码中的注释以获取更多帮助。
示例代码
#include <iostream>
#include "Aspose.Cells.h"
using namespace Aspose::Cells;
int main()
{
Aspose::Cells::Startup();
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-C
// Create an instance of Workbook class
Workbook book;
// Setting this property to true will make Aspose.Cells to throw exception
// when invalid custom number format is assigned to Style.Custom property
book.GetSettings().SetCheckCustomNumberFormat(true);
// Access first worksheet
Worksheet sheet = book.GetWorksheets().Get(0);
// Access cell A1 and put some number to it
Cell cell = sheet.GetCells().Get(u"A1");
cell.PutValue(2347);
// Access cell's style and set its Style.Custom property
Style style = cell.GetStyle();
// This line will throw exception if Workbook.Settings.CheckCustomNumberFormat is set to true
style.SetCustom(u"ggg @ fff"); // Invalid custom number format
std::cout << "Custom number format set." << std::endl;
Aspose::Cells::Cleanup();
}