In libreoffice calc (v184.108.40.206), i create a document with 2 sheets.
In the first sheet, i create 2 named lists.
The first one is global, and the other one local to Sheet1.
I sum these list in both sheet1 and sheet2.
Then using aspose cells .net (v20.1), i simply use this code :
Workbook wb = new Workbook(@“global_scope_range.ods”);
1/ In Sheet1, the global list is still OK, but the local named list does not exist anymore.
2/ In Sheet2, the global list does not exist.
I join the input and output file to illustrate the bug.
Can you help me ?
Debug.zip (14.4 KB)