To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=5658
------- Additional comments from [EMAIL PROTECTED] Thu Feb 21 00:17:23 +0000
2008 -------
@kohei: I opt for the following:
- All cases where a numeric parameter is expected and an argument is
passed either as a literal string or a single cell reference where the
cell has textual content should generate an error. No differentiation
between ="3"+4 and =A1+4. You simply can't handle text as numbers
across locales reliably as soon as it involves floating point and
maybe even group separators and not integers only.
- There could be one exception to this rule: in date calculation
context a date string of the ISO 8601 form "yyyy-mm-dd" could be
accepted.
@philhibbs: To my knowledge all significant spreadsheet applications
treat range references (A1:B3) when expecting a numeric parameter such
that they are taken as a number sequence, ignoring text cells. Text
cells are not touched or converted to 0 if the function specification
doesn't say different. This will not be changed.
@daxkelson:
> When opening a ... file
You'd end up with different modes to be maintained in the interpreter,
documentation, online help, the user not knowing which mode he's
currently in, loosing the source information when saving in a different
format, and different calculations just because you (re)opened a file in
a different format. You don't really want that.
@all: Discussions in issues tend to get lengthy, repeat arguments
because newcomers don't read all previous comments, have no proper
quoting, and make it hard to follow a thread, if there was one, if one
wasn't involved from the beginning. I think such discussions are best
carried out on the mailing lists, in this case maybe
[EMAIL PROTECTED], where at least quoting and threading are
helpful instruments. The outcome or certain milestones could be added to
the issue then. Just imagine you wanted someone from the User Experience
team take a look at this issue, do you really expect her to wade through
all this?
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
