I am writing an app that updates data from query results into an existing Excel workbook (.xlsx file) into Excel table objects. I'd like other pre existing objects in the workbook to be preserved. I added a simple stacked area chart with date column on the x axis and two numeric columns on the y axis. My app uses umya 3.1 crate to write the query results into Excel table object regions. Writing the query results works, but when umya saves the workbook (.xlsx file), the existing chart that I manually added in Libre Calc is removed.
Perhaps I am trying to do something that is not supported?
I am using Libre Calc Version: 26.2.5.2 (X86_64) and umya-spreadsheet = "3.1.0".
I am writing an app that updates data from query results into an existing Excel workbook (.xlsx file) into Excel table objects. I'd like other pre existing objects in the workbook to be preserved. I added a simple stacked area chart with date column on the x axis and two numeric columns on the y axis. My app uses umya 3.1 crate to write the query results into Excel table object regions. Writing the query results works, but when umya saves the workbook (.xlsx file), the existing chart that I manually added in Libre Calc is removed.
Perhaps I am trying to do something that is not supported?
I am using Libre Calc Version: 26.2.5.2 (X86_64) and umya-spreadsheet = "3.1.0".