Skip to content

Bubble Charts limited to 26 columns  #1076

@benjaminpavone

Description

@benjaminpavone

Category

Bug

Version

Please specify what version of the library you are using: [ 3.9 ]

Expected / Desired Behavior

Hi
Bubble charts are currently limited to columns named in range [A-Z]. With more than 26 columns the generated xml has an error.

File gen-charts.ts :

if (chartObject.opts._type === CHART_TYPE.BUBBLE) {
    strSheetXml += '<dimension ref="A1:' + LETTERS[intBubbleCols - 1] + (data[0].values.length + 1) + '" />'
}

Steps to reproduce

A sample code here : https://jsfiddle.net/7gc2kp0z/5/
With more than 26 columns, when you tried to change series in the generated pptx, you get an error. (export is good, bubbles too, but you can't change series)

After looking in generated xml files :
dimension ref="A1:undefined17" should be dimension ref="A1:AG17" (for example)

Best regards

Metadata

Metadata

Assignees

Labels

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions