[Libreoffice-bugs] [Bug 36737] default values for optional parameters are not processed

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=36737

himajin100...@gmail.com changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=79
   ||426

-- 
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 36737] default values for optional parameters are not processed

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=36737

Xisco Faulí  changed:

   What|Removed |Added

 CC||xiscofa...@libreoffice.org
   Assignee|j.car...@gmx.de |libreoffice-b...@lists.free
   ||desktop.org
 Status|ASSIGNED|NEW

--- Comment #12 from Xisco Faulí  ---
Dear Jens Carl,
This bug has been in ASSIGNED status for more than 3 months without any
activity. Resetting it to NEW.
Please assigned it back to yourself if you're still working on this.

-- 
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 36737] default values for optional parameters are not processed

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=36737

Jens Carl  changed:

   What|Removed |Added

 Status|NEW |ASSIGNED
   Assignee|libreoffice-b...@lists.free |j.car...@gmx.de
   |desktop.org |

-- 
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 36737] default values for optional parameters are not processed

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=36737

--- Comment #11 from Luis  ---
Tested with last version.
Bug still present.

Versión: 6.2.3.2 (x64)
Id. de compilación: aecc05fe267cc68dde00352a451aa867b3b546ac
Subprocs. CPU: 4; SO: Windows 10.0; Repres. IU: predet.; VCL: win; 
Configuración regional: es-ES (es_ES); Idioma de IU: es-ES
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 36737] default values for optional parameters are not processed

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=36737

--- Comment #10 from QA Administrators  ---
** Please read this message in its entirety before responding **

To make sure we're focusing on the bugs that affect our users today,
LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed
bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this
bug report. During that time, it's possible that the bug has been fixed, or the
details of the problem have changed. We'd really appreciate your help in
getting confirmation that the bug is still present.

If you have time, please do the following:

Test to see if the bug is still present with the latest version of LibreOffice
from https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the information
from Help - About LibreOffice.

If the bug is NOT present, please set the bug's Status field to
RESOLVED-WORKSFORME and leave a comment that includes the information from Help
- About LibreOffice.

Please DO NOT

Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular
meaning that is not 
appropriate in this case)


If you want to do more to help you can test to see if your issue is a
REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your
bug pertains to a feature added after 3.3) from
http://downloadarchive.documentfoundation.org/libreoffice/old/

2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to 'inherited from OOo';
4b. If the bug was not present in 3.3 - add 'regression' to keyword


Feel free to come ask questions or to say hello in our QA chat:
https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa

Thank you for helping us make LibreOffice even better for everyone!

Warm Regards,
QA Team

MassPing-UntouchedBug

-- 
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 36737] default values for optional parameters are not processed

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=36737

--- Comment #9 from jan.be...@email.cz ---
bug is still present

LO Version: 5.3.3.2
ID : 5.3.3-1
OS: Linux 4.9
nation: cs-CZ (en_US.utf8)

-- 
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 36737] default values for optional parameters are not processed

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=36737

--- Comment #8 from QA Administrators  ---
** Please read this message in its entirety before responding **

To make sure we're focusing on the bugs that affect our users today,
LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed
bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this
bug report. During that time, it's possible that the bug has been fixed, or the
details of the problem have changed. We'd really appreciate your help in
getting confirmation that the bug is still present.

If you have time, please do the following:

Test to see if the bug is still present on a currently supported version of
LibreOffice 
(5.2.7 or 5.3.3  https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the version of
LibreOffice and 
your operating system, and any changes you see in the bug behavior

If the bug is NOT present, please set the bug's Status field to
RESOLVED-WORKSFORME and leave 
a short comment that includes your version of LibreOffice and Operating System

Please DO NOT

Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular
meaning that is not 
appropriate in this case)


If you want to do more to help you can test to see if your issue is a
REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your
bug pertains to a feature added after 3.3)

http://downloadarchive.documentfoundation.org/libreoffice/old/

2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to "inherited from OOo";
4b. If the bug was not present in 3.3 - add "regression" to keyword


Feel free to come ask questions or to say hello in our QA chat:
http://webchat.freenode.net/?channels=libreoffice-qa

Thank you for helping us make LibreOffice even better for everyone!

Warm Regards,
QA Team

MassPing-UntouchedBug-20170522

-- 
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 36737] default values for optional parameters are not processed

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=36737

--- Comment #7 from jan.be...@email.cz ---
Tested again and problem still occurs on LO version  5.1.2.2, Windows 7 and
Windows XP

-- 
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 36737] default values for optional parameters are not processed

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=36737

--- Comment #6 from tommy27  ---
** Please read this message in its entirety before responding **

To make sure we're focusing on the bugs that affect our users today,
LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed
bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this
bug report. During that time, it's possible that the bug has been fixed, or the
details of the problem have changed. We'd really appreciate your help in
getting confirmation that the bug is still present.

If you have time, please do the following:

Test to see if the bug is still present on a currently supported version of
LibreOffice (5.0.5 or 5.1.2 https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the version of
LibreOffice and your operating system, and any changes you see in the bug
behavior

If the bug is NOT present, please set the bug's Status field to
RESOLVED-WORKSFORME and leave a short comment that includes your version of
LibreOffice and Operating System

Please DO NOT

- Update the version field
- Reply via email (please reply directly on the bug tracker)
- Set the bug's Status field to RESOLVED - FIXED (this status has a particular
meaning that is not appropriate in this case)


If you want to do more to help you can test to see if your issue is a
REGRESSION. To do so: 

1. Download and install oldest version of LibreOffice (usually 3.3 unless your
bug pertains to a feature added after 3.3)

http://downloadarchive.documentfoundation.org/libreoffice/old/

2. Test your bug 

3. Leave a comment with your results. 

4a. If the bug was present with 3.3 - set version to "inherited from OOo"; 
4b. If the bug was not present in 3.3 - add "regression" to keyword


Feel free to come ask questions or to say hello in our QA chat:
http://webchat.freenode.net/?channels=libreoffice-qa

Thank you for your help!

-- The LibreOffice QA Team This NEW Message was generated on: 2016-04-16

-- 
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 36737] default values for optional parameters are not processed

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=36737

LeMoyne Castle lemoyne.cas...@gmail.com changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=59
   ||327

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 36737] default values for optional parameters are not processed

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=36737

--- Comment #4 from Bob bobbux...@gmail.com ---
I was about to open a very similar bug report and can provide a simple test
case to demonstrate the problem still occurs of LO 4.3.0.3

VBA allows an optional parameter to be defined as - optional str as string =
abc - the variable is not initialized to abc in LO

Alternatively if no default is provided - optional mstr as string mstr  -
should not be initialized and isMissing(mstr) should return True it actually
returns false and mstr is a null string

LO works correctly for data type Double and Variant,  I have not tested other
data types

This error is particularly insidious when porting from Excel since no error is
raised and differences in function execution may not be readily apparent.

I used the following function to show the problem:

function TestOpt(optional num as double =123,  optional str as string = abc,
optional numv  =456,  optional strv = def, optional miss as double, optional
mstr as string) as string 
Dim printstr as string 

printstr =  num:  num   isMissing   isMissing(num) 
printstr = printstr  ; str:  str   isMissing   isMissing(str) 

printstr = printstr  ; numv:  numv   isMissing   isMissing(numv) 
printstr = printstr  ; strv:  strv   isMissing   isMissing(strv)
rem print printstr
printstr = printstr  ; miss:  miss   isMissing   isMissing(miss)
printstr = printstr  ; mstr:  mstr   isMissing   isMissing(mstr)
print printstr
TestOpt = printstr
end function 

Output is 
num: 123  isMissing False; str:   isMissing False; numv: 456 
isMissing False; strv: def  isMissing False; miss: Error ǀ  isMissing
True; mstr:   isMissing False

str and mstr are handled incorrectly, Double and Variant formats are correct

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 36737] default values for optional parameters are not processed

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=36737

--- Comment #5 from Bob bobbux...@gmail.com ---
Created attachment 103446
  -- https://bugs.freedesktop.org/attachment.cgi?id=103446action=edit
Function to demonstrate problem

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 36737] default values for optional parameters are not processed

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=36737

--- Comment #3 from QA Administrators qa-ad...@libreoffice.org ---
Please read this message in its entirety before responding.

Your bug was confirmed at least 1 year ago and has not had any activity on it
for over a year. Your bug is still set to NEW which means that it is open and
confirmed. It would be nice to have the bug confirmed on a newer version than
the version reported in the original report to know that the bug is still
present -- sometimes a bug is inadvertently fixed over time and just never
closed.

If you have time please do the following:
1) Test to see if the bug is still present on a currently supported version of
LibreOffice (preferably 4.2 or newer).
2) If it is present please leave a comment telling us what version of
LibreOffice and your operating system.
3) If it is NOT present please set the bug to RESOLVED-WORKSFORME and leave a
short comment telling us your version and Operating System

Please DO NOT
1) Update the version field
2) Reply via email (please reply directly on the bug tracker)
3) Set the bug to RESOLVED - FIXED (this status has a particular meaning that
is not appropriate in this case)

+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + 
LibreOffice is powered by a team of volunteers, every bug is confirmed
(triaged) by human beings who mostly give their time for free. We invite you to
join our triaging by checking out this link:
https://wiki.documentfoundation.org/QA/BugTriage

There are also other ways to get involved including with marketing, UX,
documentation, and of course developing - 
http://www.libreoffice.org/get-help/mailing-lists/. 

Lastly, good bug reports help tremendously in making the process go smoother,
please always provide reproducible steps (even if it seems easy) and attach any
and all relevant material

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 36737] default values for optional parameters are not processed

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=36737

jan.be...@email.cz changed:

   What|Removed |Added

 Status|NEEDINFO|NEW
Version|LibO 3.3.2 release  |LibO 3.5.0 Beta3

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 36737] default values for optional parameters are not processed

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=36737

--- Comment #2 from August Sodora aug...@gmail.com 2012-01-08 16:29:24 PST ---
Reproduced on master with the following code:

REM  *  BASIC  *
Option VBASupport 1
Option Explicit

Sub Main()

MsgBox(func1())
MsgBox func1(Par1_SetValue)

End Sub

Function func1(Optional MyPar1 As String = Par1_DefaultValue) as String
func1 = MyPar1
End Function

--

Result: An empty message box pops up followed by a message box that says
Par1_SetValue

Expected Result: A message box that says Par1_DefaultValue followed by a
message box that says Par1_SetValue

It looks to me like this is in some vba-specific part of the code because I get
syntax errors if I remove the Option VBASupport 1.

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 36737] default values for optional parameters are not processed

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=36737

Björn Michaelsen bjoern.michael...@canonical.com changed:

   What|Removed |Added

 Status|NEW |NEEDINFO

--- Comment #1 from Björn Michaelsen bjoern.michael...@canonical.com 
2011-12-23 12:05:28 PST ---
[This is an automated message.]
This bug was filed before the changes to Bugzilla on 2011-10-16. Thus it
started right out as NEW without ever being explicitly confirmed. The bug is
changed to state NEEDINFO for this reason. To move this bug from NEEDINFO back
to NEW please check if the bug still persists with the 3.5.0 beta1 or beta2
prereleases.
Details on how to test the 3.5.0 beta1 can be found at:
http://wiki.documentfoundation.org/QA/BugHunting_Session_3.5.0.-1

more detail on this bulk operation:
http://nabble.documentfoundation.org/RFC-Operation-Spamzilla-tp3607474p3607474.html

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs