Page 1 of 1
Merge sheets, including formatting
Posted: Fri Jul 31, 2020 9:47 am
by oonk
FJCC wrote:It steps through the sheets, copying the contents to column A …
I tried running code in LibreOffice Calc BASIC 6.2.8.2-2.
Sheet 2 - 6, all their cells came to merge with Sheet1, except Sheet7 came only 1 cell even though used area is A1:F100.
And for Sheet7, there will be only background color and border format, without any contents (values, text, formulas).
Is it the same as in OO Calc ?
Re: Merging different tables in a calc document
Posted: Fri Jul 31, 2020 11:55 am
by Lupp
I checked the code by FJCC and found it basically correct regarding its original purpose.
However, any "special effects" probably caused by formulas using specialized functions (CELL, FORMULA, SHEET, ...) and special formatting / ConditionalFormatting aren't analyzed and taken in account there. Also the formula apparatus of the first sheet can fail as soon as additional content is appended (what about MATCH...?). Measures needed to avoid unwanted effects can be very complicated if not impossible to find in special cases. Plain content is no problem.