Welcome to the JavaScript feedback portal. We’re happy you’re here! If you have feedback on how to improve the JavaScript, we’d love to hear it!>
Thanks for joining our community and helping improve Syncfusion products!
If you set isTransposed to true on a chart the export module creates a spreadsheet with just the chart title in it, no data at all.
I believe the problem lies in the getXValue method in export.ts - within the forloop it sets a variable called axisName. With e.g. a column chart transposed I believe the axis the export module will process will be primaryYAxis rather than primaryXAxis and and that forloop will set the axisName variable to null for primaryYAxis only if the series is of type "Bar" (presumably because because the bar chart is effectively a transposed column chart). So what happens with the transposed column chart is that the axisName variable gets set to "primaryYAxis" (because the series is not of type "Bar"), the actual column series all have an xAxisName property of null and then so the "if" statement skips that series when it checks axisName against series.xAxisName since "primaryYAxis is not null.
The fix would seem to be for this for loop to check if the chart is transposed and swap where it's looking at x and y axis related aspects of the axes and series that it's looping over.
I have used an export example from your documentation and modified it to set isTransposed to true and it demonstrates that the export doesn't behave properly.