Table to Excel: saving Table with merged cells to Excel makes Eviews break down
Posted: Wed Oct 30, 2024 6:06 am
Dear Eviews team,
I use Eviews 13 Oct 2022 build.
Eviews breaks down, when saving a table with merged cells to Excel.
This bug seems to happen only when there are no cell entries right of the merged columns (see example code below).
I use Eviews 13 Oct 2022 build.
Eviews breaks down, when saving a table with merged cells to Excel.
This bug seems to happen only when there are no cell entries right of the merged columns (see example code below).
Code: Select all
wfcreate u 1 1
table tab
tab(1,1)="C1"
tab(1,2)="C2"
tab(1,3)= "C3"
'This works, but ...:'
tab.setmerge(1,1,1,2)
tab.save(t=excelxml) tab
'... in the Eccel sheet, the rows are shifted by three rows down
tab.setmerge(1,1) 'unmerge
tab(1,3)="C3"
'This breaks ....
tab.setmerge(1,2,1,3) ' merge columns 2 and 3
' .... with following line:'
tab.save(t=excelxml) tab