Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenWed, 14 Apr 2021 00:49:46 +0200high precision, calculate correction valuehttps://ask.libreoffice.org/en/question/304044/high-precision-calculate-correction-value/ hi @all,
a question: '5 minutes' represented as a fraction of a day (represented by '1') are an 'odd' 'uneven' - 'endless fraction' value, already in decimals, and also in doubles (can be calculated as '=time(0;5;0),
thus there is a gap between the value calc can deal with ('=1/24/60*5' or '=1/24/12', or '=1/288', all resulting in '0,00347222222222222') and the ideal precise value of 0,003472222222222222222222222222222... , something like 0,000000000000000002222222222222222... or - as calc has one digit more hidden from users view: 0,000000000000000000222222222222222....
i can! calculate that gap quite precise to 1.9274705288631189921192130137104208E-19 with the 128 bit variant of 'weitz' (www.weitz.de/ieee), doe's anybody have an idea how i can get that value in a calc sheet? wouldn't need 35 digit precision, 15 or 16 digits acc. normal double is sufficient, just 10 digit could be enough.
i know the value cannot be added to the 5 minute value as it's beyond it's ULP, but if one can get such correction values i see some nice possibilities to do correct calculations.
let's say: 1/288 is a fraction which we know, exact, we can check that calc calculates with something like '0,0034722222222222220294, how to calculate the difference 'in the sheet'?
(sorry, i am! somewhat overworked, normally i should know such things by myself ... let me change the question ... what is the best - most elegant - way do get such values ?)newbie-02Wed, 14 Apr 2021 00:49:46 +0200https://ask.libreoffice.org/en/question/304044/two problems with pivot pointshttps://ask.libreoffice.org/en/question/136986/two-problems-with-pivot-points/One problem I'm having with pivot points (in draw) is that when I zoom in and try and get a pivot point to be at the approximate center of a circle (The circle is made of rings, I haven't found a way to duplicate the method in illustrator of creating precise shapes of other shapes...) the pivot point will not remain where I placed it. Its almost as if the resolution of the pivot point has a limitation, and cannot be adjusted beyond a certain precision.
The second problem is that the help page suggests that I am able to move a pivot point outside its parent object. This does not happen in practice. As soon as I rotate the object, the pivot point is returned to its original position (object center).
Greatly appreciate ANY suggestions. Thanks!dogsallowedinheavenSat, 04 Nov 2017 22:19:02 +0100https://ask.libreoffice.org/en/question/136986/