View Single Post
  #20   Report Post  
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel
Harlan Grove Harlan Grove is offline
external usenet poster
 
Posts: 733
Default An oddity if not a bug

wrote...
....
Gnumeric returns an integer COMBIN result because it seemed like
a good idea when mucking with logs. Note the floor(0.5 + ...) in this
fragment:

....
And fact will return an exact (and thus integer) value for n<=15 and
probably more.


My appologies. I have created a test file in Excel, then loaded it into
OOo Calc and Gnumeric. Gnumeric didn't recalculate it automatically, so
it appeared that it gave the same results as Excel because it was still
displaying the Excel-calculated values.

Begs the question why Gnumeric didn't automatically recalc the file
when it opened.