fpspread copyWorksheet and copyRows

Forum > FPSpreadsheet

<< < (3/3)

totya:

--- Quote from: totya on July 08, 2020, 03:12:21 pm ---Thank you master!

But I noticed a problem (I tried office xlsx format only) the copied worksheet column width isn't equal with the original worksheet column width. This is mean the column width information lost.

--- End quote ---

This bug solved via svn 7529, by wp master, thank you! :)

talitaedwiges:
Hello wp
--- Quote from: wp on July 09, 2018, 05:07:38 pm ---This is the signature of the CopyWorksheet function

--- Code: Pascal [+][-]window.onload = function(){var x1 = document.getElementById("main_content_section"); if (x1) { var x = document.getElementsByClassName("geshi");for (var i = 0; i < x.length; i++) { x[i].style.maxHeight='none'; x[i].style.height = Math.min(x[i].clientHeight+15,306)+'px'; x[i].style.resize = "vertical";}};} --- function CopyWorksheetFrom(AWorksheet: TsWorksheet; ReplaceDuplicateName: Boolean = false): TsWorksheet;You obviously did not use the optional second parameter which - if true - forces the copied worksheet to have a new unique sheetname.

CopyRow copies only a row record, it does not copy any cells visible within that row. The row record contains information on row height and row format (default format assigned to empty cells)

--- End quote ---
! I need to create a new worksheet (file) based on a template worksheet. I'm using CopyWorksheetFrom it worked, but the cell values with formulas and links are not copied.

Navigation

[0] Message Index

[*] Previous page