OpentTBS formula between sheets in excel

Hello,

I'm now fighting with excel and try to use in a sheet formula counting items in another sheet, as i understand, TBS is generating subtemplates in separate and this reference to another sheet will not work...
How can i bypass this limitation?
Another question: when i run the demo with excel (no modification on the demo file), the graph is not displayed, is there something special to do?

Christophe

Hi Christophe,

> TBS is generating subtemplates in separate and this reference to another sheet will not work...

TBS merges sub-XML files that are in the XLSX which is in fact a zip archive.
The reference to another sheet should be kept. Nevertheless, references to cells won't be changed. Thus is may not be the resulta as you expecte.
This is explain, in the XLSX example.

> when i run the demo with excel (no modification on the demo file),
> the graph is not displayed, is there something special to do?

Charts in DOCX have their own data table. While charts in XLSX are related to Excel cells.
In the XLSX example, the chart is related to cells in a table which is not yet merged.
That's why the chart is empty.