QXlsx::Document::copySheet() destination sheet column widths? about qtxlsxwriter HOT 3 OPEN

A workaround on this is getting all the column widths + row heights in 2 lists
and then when i copy the sheet i set the widths from the list i have. It works quite well for now.

Also another thing i notice, when i have a formula which divides by 0 or empty cell(i get warning on ms excel) the formula is not saved when i saveAs() the file.
Why is that?

from qtxlsxwriter.

Hi, Thanks for your feedback.

For the first issue, the source code can be found in https://github.com/dbzhang800/QtXlsxWriter/blob/master/src/xlsx/xlsxworksheet.cpp#L191 . As you can see, we only copy cells and merges information at present.

For the second issue, sorry, I'm not catch up with you. Maybe you can give a small example.

from qtxlsxwriter.

Hey, thanks for your reply.

I see, well i guess i can just use the method i describe above and it's all fine.

On the second part; I have an template excel file which has some formating etc. i need but it's empty from data, i just save it under a different file name and on that file i start filling it with sheets and data from my application(the template has cell colors, and formating etc so i need to copy it without losing it).

The template file has some formulas but because all the cells are empty i get error from a specific formula on excel that i divide by 0, no problem, but that specific only formula is not saved when i save my template with the SaveAs() function, but all others, some additions and multiplications are saved just fine. It's not really a big issue for me, i store all the formulas in lists and then i write them on the new file again on top, i'm just asking out of curiosity :)

To make it more simple:
create 2 formulas on two cells, one that divides by a value of a cell, but make that cell empty so it's division by 0(notice excel displays the warning "DIV/0) and one with adding 2 cell values. Then open it with qxlsx and saveAs with another file name and see that only the addition formula will be saved not the division. Weird..

from qtxlsxwriter.