https://bugs.freedesktop.org/show_bug.cgi?id=43330

             Bug #: 43330
           Summary: TransferTab mixes rangeNames
    Classification: Unclassified
           Product: LibreOffice
           Version: LibO Master
          Platform: Other
        OS/Version: All
            Status: UNCONFIRMED
          Severity: major
          Priority: medium
         Component: Spreadsheet
        AssignedTo: libreoffice-bugs@lists.freedesktop.org
        ReportedBy: oooc...@free.fr


Created attachment 53945
  --> https://bugs.freedesktop.org/attachment.cgi?id=53945
the file to import

using the following macro, imported rangenames are not correctly defined


if targetPos > srcPos, seems ok for global range names
    result = theSheets.importSheet(srcDoc, srcName,3)

if targetPos = pos of the source sheet where named raneg are defined  --> do
not poiint on the ocrrect sheet
    result = theSheets.importSheet(srcDoc, srcName,0)

in fact, named ranges are based on indexes but should refer at sheetname

gdb analysis pointed problems on sc/source/core/data/cell.cxx:183
 created wrong rangenames

'----

the macro

sub newApi


    destDoc = thisComponent

    theSheets = destDoc.sheets

    SrcUrl = convertToUrl("/home/lgodard/Bureau/DTEPoc/smallGlobal.ods")

    srcName = "autreFeuille"

    srcDoc = StarDesktop.loadComponentFromUrl(SrcUrl, "_blank", 1, array() )

    result = theSheets.importSheet(srcDoc, srcName,0)

    srcDoc.close(true)

    print result    

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

Reply via email to