Sorunuzu Sorun

newbie-02 isimli kullanıcının profili - etkinlik

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' -