We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

setXValues does not work like Excel for workbook-scoped named ranges

In Excel, one can set a workbook-scoped named range for horizontal axis labels of a chart by providing the following formula in the editor:

"=SHEET!WORKBOOK_RANGE"
or
"=FILE.xlsx!WORKBOOK_RANGE"

When re-editing the horizontal axis labels, we get in both cases:

"=FILE.xlsx!WORKBOOK_RANGE"

With ASPose, we can call:
chart.getNSeries().get(0).setXValues("=SHEET!WORKBOOK_RANGE");
but not:
chart.getNSeries().get(0).setXValues("=FILE.xlsx!WORKBOOK_RANGE");

I’ve provided a sample excel document with first chart having workbook-scoped range for xvalues and second chart having sheet-scoped range for xvalues.
The java class TestXValues simply get xvalues et re-set it with the obtained text.
It succeeds for sheet-scoped range but fails for workbook scoped range.

Hi Sébastien,


Thank you for contacting Aspose support.

We have evaluated the presented scenario while using the latest version of Aspose.Cells for Java 8.6.2.1 and we are able to observe the same issue. In order to further investigate the matter, we have logged this incident in our bug tracking system as CELLSJAVA-41608. Please spare us little time to look further into this matter. We will keep you posted with updates.

Hi again,


This is to update you that we have fixed the problem logged earlier as CELLSJAVA-41608. We will shortly provide the fix here after ensuring the quality and incorporating other enhancements.

The issues you have found earlier (filed as CELLSJAVA-41608) have been fixed in this update.


This message was posted using Notification2Forum from Downloads module by Aspose Notifier.