Description:
Currently, the OnlyOffice Spreadsheet API does not provide methods to programmatically format the font properties of chart data labels. This limitation prevents developers from creating fully customized, professional-looking charts through macros and scripts.
Requested Feature:
Add support for formatting chart data label fonts via the API, including:
-
Font Type/Family - Ability to set font name (e.g., “Arial”, “Calibri”, “Times New Roman”)
-
Font Size - Ability to set font size in points (e.g., 8, 10, 12, 14, 16, etc.)
-
Font Color - Ability to set text color using RGB values or hex codes
-
Bold - Ability to toggle bold weight on/off
-
Italic - Ability to toggle italic style on/off
-
Underline - Ability to toggle underline on/off
Current Limitation:
While data labels can be enabled/disabled and positioned through the API using methods like SetShowSerName(), SetShowVal(), and SetPosition(), SetShowDataLabels SetShowPointDataLabel there is no way to modify the font formatting of these labels programmatically.