Haz tu Pregunta

perfil de newbie-02 - actividad

2021-05-11 15:32:05 +0200 comentar respuesta calc: rounding: general precision problem?

@Mike Kaganski: imho progress evolves from trying again, even if it looks difficult, even if it is! difficult, do not f

2021-05-10 14:45:32 +0200 comentar respuesta calc: rounding: general precision problem?

mh ... don't like 'impossible' ... much effort - yes, stretching my capabilities - yes, impossible - no, mostly when so

2021-05-09 11:35:04 +0200 comentar respuesta calc: rounding: general precision problem?

since they are not guaranteed to be present on all its supported platforms. understand, thought of that, but that

2021-05-09 00:38:33 +0200 comentar respuesta calc: rounding: general precision problem?

@Mike Kaganski, (since there's no way to store more than 52 significant bits of the result in mantissa) Splitti

2021-05-09 00:08:12 +0200 recibió una medalla  Pregunta Popular (fuente)
2021-05-09 00:01:07 +0200 comentar respuesta calc: rounding: general precision problem?

---- continued ---- the following formula calculates partly with the textual representation of a value which has more d

2021-05-08 23:45:07 +0200 comentar respuesta calc: rounding: general precision problem?

hello @Mike Kaganski, yeah, that sounds logical, the coarser granularity after multiplication increases the error eve

2021-05-08 21:37:17 +0200 editar respuesta Libreoffice writer pastes previous clipboard content

[edit] ---(2021-05-08)--- seems most copy / paste problems are resolved with the retry patches for e.g. tdf#136175, th

2021-05-08 21:36:37 +0200 editar respuesta Libreoffice writer pastes previous clipboard content

hello @icefront, [edit] ------------ the comment from @Opaque is! important: yes, there are plenty reports that usi

2021-05-08 17:32:54 +0200 realizó una pregunta calc: rounding: general precision problem?

calc: rounding: general precision problem? hi @all, one more question for today ... IMHO difficult ... short ver.: d

2021-05-08 17:21:26 +0200 recibió una medalla  Pregunta Notable (fuente)
2021-05-08 15:44:36 +0200 respondió a una pregunta calc: macro: basic: 'MOD' in sheet different to 'MOD' in macros

hello @Zizi64 and @sokol92, thanks for your explanations, have to admit that i forgot to think about compatibility,

2021-05-08 14:49:52 +0200 recibió una medalla  Pregunta Popular (fuente)
2021-05-08 06:17:12 +0200 realizó una pregunta calc: macro: basic: 'MOD' in sheet different to 'MOD' in macros

calc: macro: basic: 'MOD' in sheet different to 'MOD' in macros i @all, in "Macro using MOD and variables produces wr

2021-05-06 14:48:34 +0200 respondió a una pregunta Cloning conditional formatting

multiple possibilities: copy the formatted cell, if necessary adapt the formula and or the formatting conditions, un

2021-05-02 14:06:16 +0200 recibió una medalla  Pregunta Notable (fuente)
2021-05-01 13:55:08 +0200 recibió una medalla  Pregunta Popular (fuente)
2021-05-01 13:45:54 +0200 comentar respuesta Incorrect results produced by simple subtraction

be aware that: - in above sample no digit is 'lost', as there never haven't been more than 8, - roundsig isn't clean

2021-05-01 08:58:20 +0200 realizó una pregunta calc: Clean up/optimize an ods file?

calc: Clean up/optimize an ods file? hi @all, with a document that reproducibly crashed i learned something about the

2021-05-01 08:38:58 +0200 comentar pregunta Calc File Link Keep Breaking When Relaunching File, Help Please?!

similar problem with persistently reappearing links to external svg images, googled and searched a little, there are som

2021-05-01 07:59:26 +0200 comentar respuesta revert embed picture / break link

had a similar problem, links to invisible small online gifs - hyperlink - probably injected by copy/paste data from my b

2021-04-30 23:29:42 +0200 comentar respuesta Calc introduces unbreakable, non-existing links in my sheet

have a quite similar issue, probably pested / infected a file with some picture data from my bank by copying data from t

2021-04-30 20:55:29 +0200 recibió una medalla  Pregunta Popular (fuente)
2021-04-30 20:48:41 +0200 respondió a una pregunta exclude single file from recovery

have found a 'trick' - workaround - myself ... have 'overinstalled' an older version of 7.2 which does not have these ne

2021-04-30 20:30:41 +0200 realizó una pregunta exclude single file from recovery

exclude single file from recovery hi @all, i ran into the following situation: one file opened in calc, did some edi

2021-04-29 19:08:58 +0200 realizó una pregunta copying formulas from one calc version to another

copying formulas from one calc version to another hi @all, silly question, sorry, think i'd known the answer in former

2021-04-27 11:52:21 +0200 comentar pregunta weird Calc results from elapsed-time formula, specific times only

there is one more point to consider: time values represented as a fraction of a day being represented by '1' have 'odd f

2021-04-21 18:13:19 +0200 recibió una medalla  Pregunta Notable (fuente)
2021-04-21 18:13:19 +0200 recibió una medalla  Pregunta Famosa (fuente)
2021-04-21 18:13:11 +0200 recibió una medalla  Pregunta Famosa (fuente)
2021-04-21 18:13:09 +0200 recibió una medalla  Pregunta Famosa (fuente)
2021-04-21 18:13:04 +0200 recibió una medalla  Pregunta Famosa (fuente)
2021-04-21 18:09:10 +0200 recibió una medalla  Pregunta Famosa (fuente)
2021-04-21 17:57:14 +0200 recibió una medalla  Pregunta Notable (fuente)
2021-04-19 14:22:51 +0200 respondió a una pregunta calc: options macro security 7.2

problem vanished in fresh versions since 2 month, worksforme

2021-04-19 14:20:53 +0200 comentar pregunta calc: options macro security 7.2

better with fresh version,

2021-04-19 14:20:09 +0200 recibió una medalla  Pregunta Notable (fuente)
2021-04-18 11:59:57 +0200 recibió una medalla  Pregunta Notable (fuente)
2021-04-17 19:57:45 +0200 comentar respuesta CALC: why are bits killed in subtractions with heavy cancellation and can this be turned off?

tried to look at http://libreofficeforum . org/, but says 'Warning: Potential Security Risk Ahead' :-(

2021-04-17 19:51:36 +0200 comentar respuesta CALC: why are bits killed in subtractions with heavy cancellation and can this be turned off?

... continued ... or it would be due to international standards if results are garbage. If the developers and support

2021-04-17 19:49:21 +0200 comentar respuesta CALC: why are bits killed in subtractions with heavy cancellation and can this be turned off?

hello @Lupp, nice to hear you awake and well, downvoten do not remember, can I check somehow? I have 'reopened'

2021-04-17 14:20:15 +0200 respondió a una pregunta CALC: why are bits killed in subtractions with heavy cancellation and can this be turned off?

better? answer: this case is not 'fp-math' or IEEE 754, but rounding in calc, see [attached sheet - click to downloa

2021-04-15 14:03:04 +0200 recibió una medalla  Pregunta Notable (fuente)
2021-04-15 11:10:46 +0200 comentar pregunta Google Sheets (Excel) Timer

@ebot: and that might help this guy or others ... :-)

2021-04-15 10:34:22 +0200 comentar pregunta Google Sheets (Excel) Timer

think that guy wanted to ask if LO calc can provide such functionality ...

2021-04-15 09:52:44 +0200 comentar pregunta autocalc - shared formula fail? would like a recheck

@Mike Kaganski: no repro with versions up to 7.1.0.0.a0+, repro with 7.2 dev from today: Version: 7.2.0.0.alpha0+ (x64)

2021-04-14 21:52:19 +0200 recibió una medalla  Pregunta Popular (fuente)
2021-04-14 19:23:39 +0200 comentar pregunta autocalc - shared formula fail? would like a recheck

@Mike Kaganski: i don't know if there is a difference, for me both look as wrong results, mentioned in that order as: 1.