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

          Priority: medium
            Bug ID: 70081
          Assignee: [email protected]
           Summary: BASIC: after sheets.copybyname or sheets.remove
                    basic-variable points to wrong sheet
          Severity: normal
    Classification: Unclassified
                OS: Windows (All)
          Reporter: [email protected]
          Hardware: Other
        Whiteboard: BSA
            Status: UNCONFIRMED
           Version: 4.1.1.2 release
         Component: BASIC
           Product: LibreOffice

basic variable = sheets.getbyname(..)

After inserting a new sheet with sheets.copybyname before this sheet , the
basic variable points to the wrong sheet, here sheetpositon -1. You get the
same effect after removing a sheet, the variable points then to sheetpositon+1.

The problem is new in  this LO version. A retest in LO 4.0 is OK.

Here a code example :
REM  *****  BASIC  *****
global otabledoc as variant
Sub Main
oTableDoc=ThisComponent
oSheets = oTableDoc.sheets
if osheets.hasbyname("Tabellenew") then
  osheets.removebyname("Tabellenew")
endif

Sheet1 = oSheets.GetbyName("Tabelle1")
oSheets = oTableDoc.sheets
'msgbox osheets.dbg_methods

osheets.copybyname(sheet1.name,"Tabellenew",0) 'because 3.Parameter = 0 --> 
insert the new sheet before the sheet1 Tabelle1
'if you insert the new sheet after the old sheet, everything is ok.

Sheet1.getCellByPosition(0,0).string=sheet1.name 'write to the sheet
Tabellenew, not to the sheet Tabelle1

End Sub



This is a duplicate bug-report to

https://www.libreoffice.org/bugzilla/show_bug.cgi?id=70079

Because I didn't kown the best way to submit a bug.

Operating System: Windows 7
Version: 4.1.1.2 release

-- 
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

Reply via email to