OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.


Help: OASIS Mailing Lists Help | MarkMail Help

office-comment message

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]

Subject: Re: [office-comment] OpenFormula: Excel FLOOR Function

Hello everyone,

David A. Wheeler wrote:
> Dennis E. Hamilton:
>> FLOOR(x) = -CEILING(-x)
> True. What I _meant_ was that there was no built-in operation
> to do the mathematical FLOOR operation. After all,
> TAN(x) = SIN(x)/COS(x)
> But people would rightly object if we only had SIN and COS.
> We should try to make it _easy_ for users to express
> common cases, using the functions they prefer to use.

Actually, this concept contains a hidden flaw.

People actually want to solve their problem. You might give them special 
functions to solve a problem in a dozen of complex intermediary steps. 
This puts usually the burden on the user.

Or you may devise the spreadsheet in such a way, that the problem is 
solved elegantly and without much effort by the user. This latter 
approach is better, but necessitates a lot of rethinking of existing 
spreadsheets and spreadsheet functions.

Just couldn't resist to post this comment. ;-)

I am planning to challenge a lot of the spreadsheet paradigms, as time 
will permit.



> --- David A. Wheeler

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]