https://bugs.freedesktop.org/show_bug.cgi?id=74118
Priority: medium
Bug ID: 74118
Assignee: [email protected]
Summary: pb with "sheets.inserByName" function
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: x86 (IA32)
Status: UNCONFIRMED
Version: 4.1.4.2 release
Component: BASIC
Product: LibreOffice
Created attachment 92864
--> https://bugs.freedesktop.org/attachment.cgi?id=92864&action=edit
example of "sheets.inserByName" function
Hello,
following the use of the function 'sheets.insertByName' I've realized it didn't
work properly or at least differently from OpenOffice
example code
Set oSheet2 = objDocument.createInstance ("com.sun.star.sheet.Spreadsheet")
objDocument.Sheets.insertByName "ListField" oSheet2
set ocell oSheet2.getCellRangeByName = ("A1")
oCell.setString ("Field1")
In fact, instead of writing "Field1" in cell A1 of the "ListField" sheet, it
writes "Field1" in cell "A1" of sheet "Sheet1"
To write properly in the "LisftField" sheet, I must use this code :
Set oSheet2 = objDocument.createInstance ("com.sun.star.sheet.Spreadsheet")
objDocument.Sheets.insertByName "ListField" oSheet2
set oSheet2 objDocument.getSheets = (). getByName ("ListField")
set ocell oSheet2.getCellRangeByName = ("A1")
oCell.setString ("Field1")
vd
--
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
