Chart series in Excel97 workbook
Posted: Thu Feb 13, 2014 2:56 pm
I am porting code from XLsReadWrite v4 to v5. All is going well, but I cannot get the modification of chart series working, e.g
// Does not work missing event handler TFormulaHandler::SheetDataEvent
TDrwCharts* charts = Sheet->Charts ;
TDrwChart* chart ;
// For all charts in a worksheet -
for (int i = 0; i < charts->Count; i++)
{
chart = charts->Items ;
// For all series in chart
for (int a = 0; a < chart->Series->Count; a++)
{
// Add category and value range definitions
UnicodeString C = chart->Series->Items[a]->Category ;
UnicodeString V = chart->Series->Items[a]->Values ;
// Does not work missing event handler TFormulaHandler::SheetDataEvent
TDrwCharts* charts = Sheet->Charts ;
TDrwChart* chart ;
// For all charts in a worksheet -
for (int i = 0; i < charts->Count; i++)
{
chart = charts->Items ;
// For all series in chart
for (int a = 0; a < chart->Series->Count; a++)
{
// Add category and value range definitions
UnicodeString C = chart->Series->Items[a]->Category ;
UnicodeString V = chart->Series->Items[a]->Values ;