https://bugs.freedesktop.org/show_bug.cgi?id=43326
Bug #: 43326 Summary: TransferTab mixes RangeName and used formulas Classification: Unclassified Product: LibreOffice Version: LibO Master Platform: Other OS/Version: Linux (All) Status: UNCONFIRMED Severity: major Priority: medium Component: Spreadsheet AssignedTo: libreoffice-bugs@lists.freedesktop.org ReportedBy: oooc...@free.fr Created attachment 53943 --> https://bugs.freedesktop.org/attachment.cgi?id=53943 first file to import 2 files (file1, file8 attached), defining there own range names, and use them in formulas using a macro, transferttab in an empty document (see below) result : - the sheets are transfered (ok) - the formulas of the sheets coming from file1 are now using wrong formula (see D1_sheet1$A2 - the formula is d8_name1 instead of d1_name1) note also that named ranges are not defined correctly (based on the index of the sheets, and not names) and d1_name1 and d8_name1 points on the same sheet. maybe the source of the problem ? '------------------ sub problemFormulatranfertTab docDest = thisComponent files = array("/home/lgodard/Bureau/DTEPoc/calc/transfertTab/file1.ods","/home/lgodard/Bureau/DTEPoc/calc/transfertTab/file8.ods") for c = 0 to 1 docSrc = stardesktop.loadComponentFromUrl(convertToUrl(files(c)),"_blank",0, array()) for i = 0 to docSrc.sheets.count-1 nomfeuille = docSrc.sheets(i) if not docDest.sheets.hasByName(nomFeuille.name) then docDest.sheets.importSheet(docSrc, nomfeuille.name,docDest.sheets.count) endif next i docSrc.close(true) next c print "ok" end sub -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. _______________________________________________ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs