This function seems to work fine:
Public Function GetCell(oSheet As com.sun.star.sheet.XSpreadsheet, _
lRow As Long, _
lCol As Long) As com.sun.star.sheet.XCell
GetCell=oSheet.getCellByPosition(lCol, lRow)
End Function
For instance, this works fine:
Dim oLastDateCell As Object
oLastDateCell=GetCell(oSheet, lLastRow, ColDate)
No errors what so ever.
But, on the other hand, this throws an error:
Dim oLastDateCell As com.sun.star.sheet.XCell
oLastDateCell=GetCell(oSheet, lLastRow, ColDate) ' oSheet and more are
correctly defined someplace else.
Error message:
”BASIC syntax error.
Data type com.sun.star.sheet.XCell is unknown”
So it works as a return type for my GetCell function, but when defining a
variable, it's suddenly unknown? Can someone explain this?
Why I use experimental mode? Because I want to learn how it works plus a
few more reasons that are just as irrelevant.
Kind regards
Johnny Rosenberg
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy
