[Libreoffice-bugs] [Bug 133910] UNO: `callFunction`does not accept optional Array parameter
https://bugs.documentfoundation.org/show_bug.cgi?id=133910
libre officer changed:
What|Removed |Added
Ever confirmed|1 |0
Status|NEEDINFO|UNCONFIRMED
--- Comment #11 from libre officer ---
(In reply to Xisco Faulí from comment #10)
> Hello libre officer,
> A new major release of LibreOffice is available since this bug was reported.
> Could you please try to reproduce it with the latest version of LibreOffice
> from https://www.libreoffice.org/download/libreoffice-fresh/ ?
> I have set the bug's status to 'NEEDINFO'. Please change it back to
> 'UNCONFIRMED' if the bug is still present in the latest version.
Hello Xisco,
It still raises exceptions for the cases as follow (see code comments):
Sub Main
oFA = createUnoService( "com.sun.star.sheet.FunctionAccess" )
holidays = Array("2020-02-22", "2020-02-23")
' Gives 24.02.2020, which is the result in Calc
Print CDate( oFA.callFunction( "WORKDAY", Array( "2020-02-21", 1 )) )
' Runtime Error. Expected result should be : 25.02.2020
Print CDate( oFA.callFunction( "WORKDAY", Array( "2020-02-21", 1,
"2020-02-24" )) )
' This one is not accepted as the third argument is a list of holidays
Print CDate( oFA.callFunction( "WORKDAY", Array( "2020-02-21", 1,
holidays)))
End Sub
The second `Print` does not accept the 3rd argument. even though it is accepted
in `Calc`.
I wish that in the last `Print`, I can pass the 3rd argument as a list of
holidays to exclude from `WORKDAY`.
Reproducible: Always
User Profile Reset: No
Version: 7.1.0.3 (x64) / LibreOffice Community
Build ID: f6099ecf3d29644b5008cc8f48f42f4a40986e4c
CPU threads: 4; OS: Windows 6.1 Service Pack 1 Build 7601; UI render:
Skia/Raster; VCL: win
Locale: fr-CH (fr_CH); UI: en-GB
Calc: CL
--
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 133910] UNO: `callFunction`does not accept optional Array parameter
https://bugs.documentfoundation.org/show_bug.cgi?id=133910 Xisco Faulí changed: What|Removed |Added Ever confirmed|0 |1 Status|UNCONFIRMED |NEEDINFO CC||xiscofa...@libreoffice.org --- Comment #10 from Xisco Faulí --- Hello libre officer, A new major release of LibreOffice is available since this bug was reported. Could you please try to reproduce it with the latest version of LibreOffice from https://www.libreoffice.org/download/libreoffice-fresh/ ? I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' if the bug is still present in the latest version. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 133910] UNO: `callFunction`does not accept optional Array parameter
https://bugs.documentfoundation.org/show_bug.cgi?id=133910 --- Comment #9 from libre officer --- (In reply to libre officer from comment #2) > (In reply to Oliver Brinzing from comment #1) > > (In reply to libre officer from comment #0) > > > Description: > > > Calling Calc functions which accepts additional argument as an array of > > > values throws a BASIC runtime error. > > > > Are you sure this can work ? > > > > According to: > > https://help.libreoffice.org/7.1/en-US/text/scalc/01/func_workday. > > html?DbPAR=CALC#bm_id3149012 > > > > Holidays is a list of optional holidays. > > Enter a *cell* *range* in which the holidays are listed individually. > > That's the problem, I am obliged to provide a cell range object instead of a > simple array of date values. > > Actually, what I do is to create new temporary Calc file, and insert value > from another generated date list, then get the cell range to feed it to > `workday`, then close that Calc file. > > I use Base form, so it is slower to create a Calc file and do all the stuffs > I mentioned. Instead, it would be much convenient and faster if I feed > `workday` directly with array of values without the need to create a cell > range. > > Other Calc functions don't needs to create a new sheet, you just call it > (weekday, weeknum, etc.). Any enhancement to support array argument instead of cell range, which make it mendatory to create Calc window ? -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 133910] UNO: `callFunction`does not accept optional Array parameter
https://bugs.documentfoundation.org/show_bug.cgi?id=133910 --- Comment #8 from jun meguro --- I have verified that the code I have presented works fine under two conditions. One way is to run it in safe mode after booting. The other way is to rename the user folder and run it after restarting LibO. And when I put the user folder back and then run it, the same error reoccurred. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 133910] UNO: `callFunction`does not accept optional Array parameter
https://bugs.documentfoundation.org/show_bug.cgi?id=133910 himajin100...@gmail.com changed: What|Removed |Added CC||er...@redhat.com --- Comment #7 from himajin100...@gmail.com --- https://opengrok.libreoffice.org/xref/core/sc/source/core/tool/interpr2.cxx?r=80f28e37#402 https://opengrok.libreoffice.org/xref/core/sc/source/core/tool/interpr3.cxx?r=9d4c36d7#4125 https://opengrok.libreoffice.org/xref/core/sc/source/core/tool/interpr3.cxx?r=9d4c36d7#3953 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 133910] UNO: `callFunction`does not accept optional Array parameter
https://bugs.documentfoundation.org/show_bug.cgi?id=133910 --- Comment #6 from himajin100...@gmail.com --- no error with meguro's code. Version: 7.1.0.0.alpha0+ (x64) Build ID: 63d4e8aa10186b4ed0e3106c116ad25c5fb5ed6d CPU threads: 4; OS:Windows 10.0 Build 18363; UI render: default; VCL: win Locale: ja-JP (ja_JP); UI: ja-JP Calc: CL the same error as the reporter's when I ran the reporter's code, whether this should be marked WONTFIX or ASSIGNED. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 133910] UNO: `callFunction`does not accept optional Array parameter
https://bugs.documentfoundation.org/show_bug.cgi?id=133910 --- Comment #5 from Oliver Brinzing --- (In reply to jun meguro from comment #3) > I reproduced the error with the following simpler code. i can not confirm an error with: Version: 7.1.0.0.alpha0+ (x64) Build ID: 63d4e8aa10186b4ed0e3106c116ad25c5fb5ed6d CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: Skia/Raster; VCL: win Locale: de-DE (de_DE); UI: en-US Calc: threaded -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 133910] UNO: `callFunction`does not accept optional Array parameter
https://bugs.documentfoundation.org/show_bug.cgi?id=133910 jun meguro changed: What|Removed |Added CC||jmag...@gmail.com --- Comment #4 from jun meguro --- Created attachment 16 --> https://bugs.documentfoundation.org/attachment.cgi?id=16=edit Error message. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 133910] UNO: `callFunction`does not accept optional Array parameter
https://bugs.documentfoundation.org/show_bug.cgi?id=133910
--- Comment #3 from jun meguro ---
I reproduced the error with the following simpler code.
Sub test
Dim sMoji as string
svc = createUnoService( "com.sun.star.sheet.FunctionAccess" )
sMoji = svc.callFunction("MID",array("ABCＡＢＣ123１２３",1,3))
msgbox(sMoji)
End Sub
Sub test2
Dim sMoji as string
svc = createUnoService( "com.sun.star.sheet.FunctionAccess" )
sMoji = svc.callFunction("ASC",array("ABCＡＢＣ123１２３"))
msgbox(sMoji)
End Sub
On 6.4.4 ,Executed successfully.
On 7.0.0 Beta2 ,Error Occured.
--
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 133910] UNO: `callFunction`does not accept optional Array parameter
https://bugs.documentfoundation.org/show_bug.cgi?id=133910 --- Comment #2 from libre officer --- (In reply to Oliver Brinzing from comment #1) > (In reply to libre officer from comment #0) > > Description: > > Calling Calc functions which accepts additional argument as an array of > > values throws a BASIC runtime error. > > Are you sure this can work ? > > According to: > https://help.libreoffice.org/7.1/en-US/text/scalc/01/func_workday. > html?DbPAR=CALC#bm_id3149012 > > Holidays is a list of optional holidays. > Enter a *cell* *range* in which the holidays are listed individually. That's the problem, I am obliged to provide a cell range object instead of a simple array of date values. Actually, what I do is to create new temporary Calc file, and insert value from another generated date list, then get the cell range to feed it to `workday`, then close that Calc file. I use Base form, so it is slower to create a Calc file and do all the stuffs I mentioned. Instead, it would be much convenient and faster if I feed `workday` directly with array of values without the need to create a cell range. Other Calc functions don't needs to create a new sheet, you just call it (weekday, weeknum, etc.). -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 133910] UNO: `callFunction`does not accept optional Array parameter
https://bugs.documentfoundation.org/show_bug.cgi?id=133910 Oliver Brinzing changed: What|Removed |Added CC||oliver.brinz...@gmx.de --- Comment #1 from Oliver Brinzing --- (In reply to libre officer from comment #0) > Description: > Calling Calc functions which accepts additional argument as an array of > values throws a BASIC runtime error. Are you sure this can work ? According to: https://help.libreoffice.org/7.1/en-US/text/scalc/01/func_workday.html?DbPAR=CALC#bm_id3149012 Holidays is a list of optional holidays. Enter a *cell* *range* in which the holidays are listed individually. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
