User story

when importing an xlsx, charts might be rendered differently from Excel, I want to customize how a chart is rendered, so that I can

• make a chart look more similar to Excel
• fix some problems
• customize a chart's rendering e.g. font size

Accept Criteria

• provide a way to manipulate chart rendering options for each chart or globally, so app devs can customize a chart's rendering with zkchart API.
• this feature only affects chart rendering in a browser, it doesn't affect the result to export charts' to an xlsx or PDF.

Details

Propose Solution

Since supporting all Excel chart options requires significant resources, we can consider exposing the zkcharts object to allow app devs to customize chart rendering.

• Provide a way to access ZssCharts when each chart creation, update.
• Provide a way to locate a speicific ZssCharts based on ID or row/column index, so app devs can change that chart in an event listener
• Limitation: these custom changes cannot be exported
• keikai can redraw a chart when it's updated follow the way to update a zkchart