2021-03-02 09:03:07 +0100 | cevaba yorum yazıldı | Re: Calc - COS(), can this be fixed? bad news: sorry, '- from '=rawsubtract(sin(pi()/2+x);1) 'jumping' from '0' for small values of 'x' to 1,11022..E-16 at x |

2021-02-28 19:30:35 +0100 | rozet alındı | ● Eleştirmen (kaynak) |

2021-02-28 19:30:30 +0100 | cevaba yorum yazıldı | CALC: why are bits killed in subtractions with heavy cancellation and can this be turned off? heyheyheeyyyy!, learned something again ... 'XL' can be pronounced as ex$el and isn't too bad! ... a silly 'convenience |

2021-02-26 01:52:51 +0100 | soruya yorum yazıldı | How does Calc load file into memory and prepare the calculation to be presented ... continued ... I have the feeling that 'recalc issues' occur frequently with me, I use a 4k screen, if any property |

2021-02-26 01:48:49 +0100 | soruya yorum yazıldı | How does Calc load file into memory and prepare the calculation to be presented heyheyheyyyy!!! @Archetype: somebody thinking and investigating! like that! probably you are overtaxing the scope and f |

2021-02-25 08:45:53 +0100 | cevaba yorum yazıldı | Re: Calc - COS(), can this be fixed? ... continued ... 'There is no way to fix it, because LibreOffice does not make symbolic calculations.' - there is one |

2021-02-25 08:42:51 +0100 | cevaba yorum yazıldı | Re: Calc - COS(), can this be fixed? ... continued ... 'Any software will therefore calculate the cosine or sine of an approximation of pi or pi/2' - never |

2021-02-25 08:41:25 +0100 | cevaba yorum yazıldı | Re: Calc - COS(), can this be fixed? ... continued ... - from '=rawsubtract(sin(pi()/2+x);1) 'jumping' from '0' for small values of 'x' to 1,11022..E-16 at |

2021-02-25 08:38:15 +0100 | cevaba yorum yazıldı | Re: Calc - COS(), can this be fixed? sorry for stepping into an old thread, imho it should be allowed if it - the thread - spreads wrong wisdom ... there |

2021-02-25 00:05:58 +0100 | cevaba yorum yazıldı | CALC: why are bits killed in subtractions with heavy cancellation and can this be turned off? hello @ oweng, hello @Alex Kemp, this answer is not! correct, pls. remove the hook, tdf#37923 isn't unsolvable but sol |

2021-02-23 20:51:47 +0100 | cevaba yorum yazıldı | Issue with calc hours with mins converting to hours with decimal @Lupp: your statement to always round time values - to the value of the 'already completely elapsed units' one is talkin |

2021-02-23 09:55:02 +0100 | cevaba yorum yazıldı | Arithmetics with dates and times? 'i'm neither finished understanding time values, nor their handling in calc, ' ... did i hear rumors about being silly? |

2021-02-23 04:47:35 +0100 | cevaba yorum yazıldı | Arithmetics with dates and times? i'm neither finished understanding time values, nor their handling in calc, just wanted to raise the awareness that: |

2021-02-22 23:57:42 +0100 | bir soru cevapladı | Issue with calc hours with mins converting to hours with decimal would suspect rounding in H5 is 'for display only' and the value taken for downstream calculations has some deviation, |

2021-02-22 23:17:47 +0100 | cevaba yorum yazıldı | Arithmetics with dates and times? @Lupp: :-) 'Catastrophic cancellation not in sight so far' ... not too far away, small impact but it made it already in |

2021-02-22 21:07:58 +0100 | soruya yorum yazıldı | Trying to use advanced data filter in calc needs more detailed explanation or a sample of your file, not the 900k records, just some dozen and the filter definitio |

2021-02-22 21:05:39 +0100 | bir soru cevapladı | Arithmetics with dates and times? i needed to apply a format string like HH:MM:SS;[ROT]-HH:MM:SS to get negatve times activated, be aware that there ar |

2021-02-22 20:44:43 +0100 | soruya yorum yazıldı | Basic macro code for inserting row in calc spreadsheet you can find calc code to do things by 'recording' a similar action, it produces cruel code with 'dispatcher callc' or t |

2021-02-19 01:20:10 +0100 | soruya yorum yazıldı | Search for duplicate numbers in list? try to play with 'format - conditional - is duplicate' in calc, it's not exact your request but quite close, if you don |

2021-02-19 01:13:21 +0100 | soruya yorum yazıldı | How to recover customizations after crash old question, valid question, not yet answered? afaik as long as you didn't change basic storage defaults the 'user' di |

2021-02-11 13:59:36 +0100 | bir soru cevapladı | Rounding down to nearest hundred hello @Bill Derr: calc's round functions are capable to round to 'negative amount of decimals', will say 'make n digi |

2021-02-07 18:19:47 +0100 | cevaba yorum yazıldı | calc: are decimal correct calculations possible? @ajlittoz: 'In a way, you're defining an algorithm over the set.' - yes, may be that describes my understanding and appr |

2021-02-07 15:13:00 +0100 | cevaba yorum yazıldı | calc: are decimal correct calculations possible? 1/3 - 'fractional math' ... we don't have that in decimals, decimals are a subset of fractionals, we don't have that in |

2021-02-07 14:37:52 +0100 | cevaba yorum yazıldı | calc: are decimal correct calculations possible? trying 1/3 - yes, you are right, now you have choosen a value which is problematic for my formula, but! that value is in |

2021-02-07 14:02:02 +0100 | cevaba yorum yazıldı | calc: are decimal correct calculations possible? biggest issue first let's think of engineering use, astromonic: calculate two star positions with 17 digit accuracy an |

2021-02-07 11:54:40 +0100 | cevaba yorum yazıldı | calc: are decimal correct calculations possible? hello @Mike Kaganski, and thanks that you still bear with me ... Wrong. They all use the same first part. no, they calc |

2021-02-06 22:58:16 +0100 | cevaba yorum yazıldı | calc: are decimal correct calculations possible? let me try another approach to explain ... i can't! prove to calculate 100percent correctly, just as little as 'you' or |

2021-02-06 19:07:28 +0100 | cevaba yorum yazıldı | calc: are decimal correct calculations possible? @ajlittoz: :-) no, the suggestion tries balancing between two evils, one is to leave 'cancellation' 'unprocessed, the o |

2021-02-05 18:29:26 +0100 | cevaba yorum yazıldı | calc: calculation: doe's calc use the FPU (coprocessor)? @Lupp: 1E15+1E-5 fails, but that fail is small as well absolute (1E-5) as relative (1E-20 of the result?), you'll hardly |

2021-02-05 12:37:06 +0100 | cevaba yorum yazıldı | calc: are decimal correct calculations possible? ... continued ... spontaneously I would suggest / like to try: 16th significant decimal 0 -> round, 16th sig. decima |

2021-02-05 12:18:46 +0100 | cevaba yorum yazıldı | calc: are decimal correct calculations possible? ... continued ... I think you can not! prove that there is no way to achieve such better results with less effort ... i |

2021-02-05 12:16:38 +0100 | cevaba yorum yazıldı | calc: are decimal correct calculations possible? ... continued ... I lack an understanding why calc uses 'untargeted rounding' in several points ('by scaling to 2^-48 a |

2021-02-05 12:12:53 +0100 | cevaba yorum yazıldı | calc: are decimal correct calculations possible? hello @Mike Kaganski, and excuse me if I'm stubborn (that was often necessary in history to make progress), I read the |

2021-02-04 23:37:37 +0100 | cevaba yorum yazıldı | calc: calculation: doe's calc use the FPU (coprocessor)? @ajlittoz: revising: - '80 bit format' - it would make sense but from statements of @Lupp and from inaccuracies affect |

2021-02-04 16:01:24 +0100 | soruya yorum yazıldı | Calc - Low performance on large spreadsheet 'The data in the spreadsheet is nothing confidential, I will upload it' ... not yet seen ... |

2021-02-04 15:59:56 +0100 | soruya yorum yazıldı | Calc - conditional format gets messed up after sorting or rearranging rows there are plenty of options, and plenty of side effects to observe, would be easier with a sample ... |

2021-02-04 15:50:53 +0100 | soruya yorum yazıldı | Conditional format on cells, based on cell's value hello @ Magdalene Ren.: it's difficult without a sample, your case is clear to you but needs guessing for others, a te |

2021-02-03 23:54:09 +0100 | rozet alındı | ● Önemli Soru (kaynak) |

2021-02-03 17:27:45 +0100 | cevaba yorum yazıldı | calc: calculation: doe's calc use the FPU (coprocessor)? yes, that's about the state of my knowledge ... @Lupp has written several times that calc puts 'everything' in doubles, |

2021-02-03 17:24:44 +0100 | cevaba yorum yazıldı | calc: are decimal correct calculations possible? @Mike Kaganski: you'd write 'Your idea is not new; also it is not correct.' ... do you remember if there are any discuss |

2021-02-03 16:04:57 +0100 | rozet alındı | ● Popüler Soru (kaynak) |

2021-02-03 13:53:58 +0100 | soruya yorum yazıldı | calc: calculation: doe's calc use the FPU (coprocessor)? hello @Lupp: :-) thus we are stuck to 64 bit (52-bitmant) doubles ... ? :-( |

2021-02-03 13:07:49 +0100 | bir soru sordu | calc: calculation: doe's calc use the FPU (coprocessor)? calc: calculation: doe's calc use the FPU (coprocessor)? hello @all, think this qualifies for a separate question: |

2021-02-03 10:14:52 +0100 | cevaba yorum yazıldı | calc: are decimal correct calculations possible? continued: - another point is if calc actually uses my / the FPU? @ajlittoz wrote about '80-bit' and i'd read it in pl |

2021-02-03 09:51:41 +0100 | cevaba yorum yazıldı | calc: are decimal correct calculations possible? hello guys, let me once again say i thank for your help! and please stay with me a little further ... - 'rounding' - |

Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.