You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2014/08/18 20:31:26 UTC
[Issue 125457] New: User-defined function call from Calc won't work
with comma parameter separators but will work with semicolons
https://issues.apache.org/ooo/show_bug.cgi?id=125457
Issue ID: 125457
Issue Type: DEFECT
Summary: User-defined function call from Calc won't work with
comma parameter separators but will work with
semicolons
Product: Calc
Version: 4.1.0
Hardware: PC
OS: Windows 8
Status: UNCONFIRMED
Severity: normal
Priority: P3
Component: code
Assignee: issues@openoffice.apache.org
Reporter: jeldredc@comcast.net
Created attachment 83850
--> https://issues.apache.org/ooo/attachment.cgi?id=83850&action=edit
Image of my Calc program w/ image of my function.
Calling a user-defined function from Calc like =VOL(A1,B1,C1) returns an Error
508. Changing the comma separators to semicolons does work and returns the
correct answer like =VOL(A1;B1;C1). Comma separators in the function itself
work fine, but commas in the call to the function in the Calc spreadsheet seem
to not work with comma separators, but do work with semicolon separators. Is
this a bug or am I supposed to know this? Thanks.
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Issue 125457] User-defined function call from Calc won't work with
comma parameter separators but will work with semicolons
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=125457
Regina Henschel <rb...@t-online.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|RESOLVED |CLOSED
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Issue 125457] User-defined function call from Calc won't work with
comma parameter separators but will work with semicolons
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=125457
Regina Henschel <rb...@t-online.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
CC| |rb.henschel@t-online.de
Resolution|--- |NOT_AN_ISSUE
--- Comment #1 from Regina Henschel <rb...@t-online.de> ---
When you are inside a cell in Calc, you have to use the syntax of Calc; and
Calc has a semicolon as delimiter between parameters. When you are inside
BASIC, you have to use the syntax of BASIC, and BASIC has a comma as parameter
delimiter. It is the bridge to BASIC, which converts the delimiters (and a lot
of other things) automatically. You can learn more about it in the BASIC guide
at https://wiki.openoffice.org/wiki/Documentation/BASIC_Guide, in the document
"OpenOffice.org Macros Explained" by Andrew Pitonyak at
http://www.pitonyak.org/oo.php and of cause in our forum and mailing list.
Please use these channels before writing a bug report.
BTW, your attachment is not usable, because it is something for a printer but
no picture.
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.