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: [email protected]
ReportedBy: [email protected]
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
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
