Regarding Graphs linked to the cell data

Aspose.Cells Product Family
1

The graph displayed in the viewer is dynamically linked to the cell data. Any modifications to the cell content are impacting the graph. Is there a way to prevent the graph from updating automatically.

2

@sarathepiq

Summary
In Aspose Cells a chart is automatically refreshed whenever the cells it references change. You can stop this behavior by turning off the chart‑auto‑update feature either for the whole workbook or for individual charts.

Why it happens
When a workbook is loaded Aspose Cells reads the Excel AutoUpdate flag that belongs to each chart. The flag is true by default, so the library recalculates the chart data each time the source range is modified or when the workbook is saved/rendered. As a result the displayed chart always reflects the latest cell values.

What to do next

  1. Disable auto‑update for the entire workbook (useful when you have many charts).
// Load the workbook
var workbook = new Aspose.Cells.Workbook("input.xlsx");

// Turn off automatic chart refresh for all charts in the workbook
workbook.Settings.EnableChartAutoUpdate = false;

// Save the workbook (or render it) after the change
workbook.Save("output.xlsx");
  1. Disable auto‑update for a single chart (when you need finer control).
var workbook = new Aspose.Cells.Workbook("input.xlsx");
var sheet = workbook.Worksheets[0]; // first worksheet
var chart = sheet.Charts[0]; // first chart on the sheet

// Prevent this chart from updating automatically
chart.AutoUpdate = false;

// Optionally keep the current data as‑is
// chart.RefreshData(); // only if you want to force a refresh now

workbook.Save("output.xlsx");
  1. Render or view the workbook after setting the flag.
    Once EnableChartAutoUpdate or AutoUpdate is set to false, subsequent changes to the source cells will no longer modify the chart until you manually refresh it (e.g., by calling chart.RefreshData() and saving again).

Note

  • EnableChartAutoUpdate = false affects all charts in the workbook; chart.AutoUpdate = false affects only the selected chart.
  • If you later need the chart to reflect new data, re‑enable the flag and call chart.RefreshData() (or simply save the workbook again).

:warning: I could not fully verify this explanation against the retrieved sources. Please double-check the behaviour in your environment and confirm the exact SDK/version.

3

@sarathepiq,

May be you could set editable/read-only range for the source (data) cells in GridJs for the graph on client side via the method:

xs.sheet.setEditableRange(range,isenable)

// the parameters are:
range: the cell range ,etc. {sri:0,sci:0,eri:2,eci:2} reprensents range start from cell A1 to C3
isenable: when set to true,the range is editable.other wise,the range is readonly.

See the document for your complete reference. Working with GridJs Client Side|Documentation