Description: This bug was opened to help in managing bug#84675 and contains the list of remaining functions to document for the Help. Actual Results: Nothing written about. Expected Results: Specific page for the function Reproducible: Always User Profile Reset: No Additional Info: ==Undocumented== AboutStarBasic CallByName CaptureAssertions CompatibilityMode CreatePropertySet CreateUnoServiceWithArguments DDEexecute DDEinitiate DDEpoke DDErequest DDEterminate DDEterminateall DoEvents DumpAllObjects - EnableReschedule Frac GetDialogZoomFactorX GetDialogZoomFactorY GetGUIVersion GetPathSeparator GetSystemType LenB Load LoadPicture Partition QBColor RGB SavePicture SendKeys Spc StrConv TraceCommand TypeLen Unload WaitUntil Tab User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:57.0) Gecko/20100101 Firefox/57.0
I see that functions below exists in code. But I am not sure that every from they design at the end. Me Replace ResolvePath RTL there is a document which gives function names and returned value for them. http://www.imaccanici.org/en.libreofficeforum.org/sites/libreofficeforum.org/files/uploads/ian%20rsbugs_files/LibreOffice%20BASIC%20Functions%20including%20Parameters.pdf
Alain Romedenne committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/help/+/3954a99fbd09ead9543cb0e9c682cbf2f69dae8f%5E%21 tdf#114263 add help page for GetPathSelector()
Olivier Hallot committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/help/+/b1aec63bf053b4a654e3531c32eabd6b0ab035f5%5E%21 tdf#114263 Help page for BASIC WaitUntil statement
From OpenOffice Macro Explained (Andrew Pitonyak) Table 14. Deprecated and not-yet-implemented routines. Routine, Comment AboutStarBasic Deprecated empty stub that used to be an information dialog. SendKeys, Empty stub. "DumpAllObjects(path, bool)",Internal debugging routine. Load(Object), Deprecated. Unload(Object), Deprecated. LoadPicture(path), Deprecated. Loads an image file. "SavePicture(obj, path)", Deprecated. Fails to save an image file. CreatePropertySet(object), Deprecated. Early UNO support function. CCur(expression), Purposely generates a run-time error. Convert to currency. StrConv, Purposely generates a run-time error. Convert strings to different cases. DateAdd, Empty stub. Add date components. DateDiff, Empty stub. Difference between two date components. DatePart, Empty stub. Extract a specific date component.
Olivier Hallot committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/help/+/d7124af74ae46cf33d1c23931b0041a40d845abb%5E%21 tdf#114263 Add Help page for BASIC Frac Function
Olivier Hallot committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/help/+/afdcd47966ebd0a2f379c01aac2ea9b85bb6cb83%5E%21 tdf#114263 Add info for BASIC Spc() function
Olivier Hallot committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/help/+/537807a50d804370f8f6f43c78c5f4ca44d3a11c%5E%21 tdf#114263 Tab BASIC function in Print description
Alain Romedenne committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/help/+/441f600d210bd69e4c485c1520eff55a42aa0a2c%5E%21 tdf#114263 Undocumented BASIC Options
As for Basic "Me" keyword: "Classes & objects in OpenOffice" link on the https://wiki.documentfoundation.org/Macros/fr wiki page is mentioning usage of "Me" keyword within its "self reference" post. Although the mentioned technique is worth recommending in order to avoid property/sub/function name collision. It should be noted that Basic-like OO languages such as VBA, Visual Basic or LotusScript are providing the exposed feature as built-in the language. Indeed "Me" should be provided in the exact same fashion as "this" is for JavaScript or as "self" is for Python languages. One should either consider "Me" as being unsupported or open a Bug for supporting such coding facility.
Summary of the remaining functions to document or ignore. CallByName CaptureAssertions CreateUnoServiceWithArguments DDEexecute DDEinitiate DDEpoke DDErequest DDEterminate DDEterminateall DoEvents EnableReschedule GetDialogZoomFactorX GetDialogZoomFactorY GetGUIVersion - not implemented (always return -1) GetSystemType - not implemented (always return -1) LenB TraceCommand TypeLen Me - see comment #9 Replace ResolvePath RTL
Olivier Hallot committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/help/+/3f27275900a441c45af6c7e91901c98def81623a%5E%21 tdf#114263 Help page for Partition [VBA]
Add VBA Err object to this list, as it can be useful when willing to raises custom errors as VBA, LotusScript VB-like language are offering.
I borrowed from: [Compatibility of Star/OpenOffice Basic to VBA] (https://jezzper.com/jezzper/discussions.nsf/0/3C030B7CC3F24D5FC1256F65002BC1B5) ..to write https://help.libreoffice.org/6.3/en-US/text/sbasic/shared/compatible.html and included this info in my wiki profile. It may be of interest to others
Olivier Hallot committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/help/+/e6dfe7b36ebfda217fe89c18b656d2eee72c18ce%5E%21 tdf#124066, tdf#114263 BASIC Replace function Help
french Basic doc. https://wiki.openoffice.org/w/images/8/8b/Guide_de_programmation_StarOffice_Basic.pdf is full of VBA related notes that may of interest.
Print statement help page is unclear, its related Spc statement in unprecise while its related Tab Statement is missing. MS-VBA Print, Spc, Tab help pages aren't clearer either as for 'how to use Print statement' variations. IBM LotusScript online help pages for these 3 statements are prettier. Some adaptation is needed in order to improve LO respective pages. Links: Online help at https://www.ibm.com/support/knowledgecenter/en/SSVRGU_9.0.1/basic/LSAZ_CHAPTER_7_STATEMENTS_BUILTIN_FUNCTIONS_SUBS_DATA_TYPES_AND_DIRECTIVES.html Acrobat copy at http://www-12.lotus.com/ldd/doc/uafiles.nsf/docs/ls70/$file/lscript.pdf May be worth mentioning in the wiki as available in japanese language too
Alain Romedenne committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/help/commit/401fb641aff217c7c333ce71d22abcf575d3ed09 tdf#114263 tdf#141474 tdf#147262 CallByName() function new help page
Option Compatible help page [1] needs this detail added to the list of the affected things: With it, this is a valid syntax: Dim opt(0) As com.sun.star.beans.PropertyValue Without, it must have New: Dim opt(0) As New com.sun.star.beans.PropertyValue [1] https://help.libreoffice.org/latest/en-US/text/sbasic/shared/compatible.html?DbPAR=BASIC
Alain Romedenne committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/b9b9b3afde384d2e24dcbf9a60fa9ee227576114 tdf#114263 tdf#147262 CallByName() function LibO Basic test unit It will be available in 7.4.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Alain Romedenne committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/help/commit/b6accc5eaf8d547bc9721118caaa9edbc998a333 tdf#114263 Basic 'New' operator is optional when setting 'Option Compatible'
Alain Romedenne committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/help/commit/021a444733a8022967b374642057d2032318634b tdf114263 CreateUnoServiceWithArguments new help page
Alain Romedenne committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/help/commit/cf59121b3e70ffcc53436cb4d1071428d4daa391 tdf114263 DoEvents new help page
(In reply to Olivier Hallot from comment #4) > From OpenOffice Macro Explained (Andrew Pitonyak) > > Table 14. Deprecated and not-yet-implemented routines. > > Routine, Comment > ... > StrConv, Purposely generates a run-time error. Convert strings > to different cases. This example shows that this needs checking. StrConv has been implemented long ago, in https://bz.apache.org/ooo/show_bug.cgi?id=85036, for OOo 3.3.0.
(In reply to Mike Kaganski from comment #23) > (In reply to Olivier Hallot from comment #4) > This example shows that this needs checking. StrConv has been implemented > long ago, in https://bz.apache.org/ooo/show_bug.cgi?id=85036, for OOo 3.3.0. StrConv Help has been implemented since.
(In reply to Olivier Hallot from comment #24) Ah - right, sorry for the noise - and thank you all for your brilliant work!
not clear what remains to be done ...
Summary of the remaining functions to document or ignore. CaptureAssertions DDEexecute DDEinitiate DDEpoke DDErequest DDEterminate DDEterminateall EnableReschedule GetDialogZoomFactorX GetDialogZoomFactorY GetGUIVersion - not implemented (always return -1) GetSystemType - not implemented (always return -1) LenB TraceCommand TypeLen ResolvePath RTL Note: LenB seems to exist and has no Help page.
(In reply to Mike Kaganski from comment #18) > Option Compatible help page [1] needs this detail added to the list of the > affected things: > > With it, this is a valid syntax: > > Dim opt(0) As com.sun.star.beans.PropertyValue > > Without, it must have New: > > Dim opt(0) As New com.sun.star.beans.PropertyValue > > [1] > https://help.libreoffice.org/latest/en-US/text/sbasic/shared/compatible. > html?DbPAR=BASIC Worth to improve the current page.
[Automated Action] NeedInfo-To-Unconfirmed
I'm closing this bug. I Googled around the functions and got several reports that DDE* functions are not working since OO.o and other methods are not used nor implemented. Once these function are usable, we consider writing the Help pages.