Hi. In fact if I change your function r(3)=(r(2)-18)*1000000000 Test = r(3)
the result is -2.8421709430404E-005 showing that 17 would be correct. For these situations I often add my own tolerance to limit sensitivity r(3)=int(r(2)+1e-9) steve On 5/07/12 1:50 PM, alex sato wrote:
Hi, I have a problem with functions I made. Let's say I create the function: Function Test (n) dim r(3) r(0)=int(n) r(1)=n-r(0) r(2)=r(1)*100 r(3)=int(r(2)) Test = r End Function Then, in a empty spreadsheet take the following steps: -select A1:D1 -press [F2] -Insert the formula =TEST(E1) -press [CTRL]+[SHIFT]+[ENTER] -insert 11,18 in E1 and see the result in cell D1 I think the result should be 18 but I'm getting 17 Where is the error? By the way, I downloaded and installed the latest version of LibreOffice before write this email to make sure that is not a solved bug. And I tried this at least in 3 computers. Thanks in Advance Alex Mitsio Sato
-- For unsubscribe instructions e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
