That's odd.
I've only just started programming with OpenOffice, so probably did something
stupid.
The macro was stored somewhere else, but I've now moved it into the spreadsheet
and set it to run when the document is opened.
It generates an error as soon as the index exceeds 255. The error lies in Uno
Service.
I guess that the for loop index has been typed as a byte, instead of long, or
integer.
Regards
Steve
The Text of the macro is:
public const maxi = 714
public const starti = 1
public ccell as object
dim cr as integer 'current cell's row
public cc as integer 'current cell's current
rem ----------------------------------------------------------------------
rem define variables
public dispatcher, document, desktop as object
rem
----------------------------------------------------------------------
rem get access to the document
public Sheet As Object
public Cell As Object
public Obj As Object
sub main
document = ThisComponent'.CurrentController.Frame
dispatcher = createUnoService("com.sun.star.frame.DispatchHelper")
rem ----------------------------------------------------------------------
Sheet = document.Sheets.getByName("Sheet1")
'
for cr=250 to maxi
cCell = Sheet.getCellByPosition(cr, 1)
Next
End Sub
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Chris Cheney
Sent: 27 March 2008 17:49
To: [EMAIL PROTECTED]
Subject: [Bug 173891] Re: basic won't access spreadsheet row > 255
Unless I am missing something there isn't even any macros in this
attached file. I turned macro security to warn and opened the file and
it didn't claim there were any macros, and I looked in the Run Macro
area and it didn't list that there were any macros in the file.
--
basic won't access spreadsheet row > 255
https://bugs.launchpad.net/bugs/173891
You received this bug notification because you are a direct subscriber
of the bug.
** Attachment added: "Tags3.ods"
http://launchpadlibrarian.net/12945582/Tags3.ods
--
basic won't access spreadsheet row > 255
https://bugs.launchpad.net/bugs/173891
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
--
ubuntu-bugs mailing list
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
