[Libreoffice-bugs] [Bug 131932] Using OFFSET function makes Calc open file with changes to save although not edited

https://bugs.documentfoundation.org/show_bug.cgi?id=131932 --- Comment #11 from QA Administrators --- Dear tom, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched

[Libreoffice-bugs] [Bug 131932] Using OFFSET function makes Calc open file with changes to save although not edited

https://bugs.documentfoundation.org/show_bug.cgi?id=131932 himajin100...@gmail.com changed: What|Removed |Added See Also|

[Libreoffice-bugs] [Bug 131932] Using OFFSET function makes Calc open file with changes to save although not edited

https://bugs.documentfoundation.org/show_bug.cgi?id=131932 Roman Kuznetsov <79045_79...@mail.ru> changed: What|Removed |Added Blocks||108827,

[Libreoffice-bugs] [Bug 131932] Using OFFSET function makes Calc open file with changes to save although not edited

https://bugs.documentfoundation.org/show_bug.cgi?id=131932 --- Comment #10 from Eike Rathke --- No simple trick there. Apart from maybe external references that are cached until updated (for which the dependency then would have to be individually remembered), as soon as and each time the

[Libreoffice-bugs] [Bug 131932] Using OFFSET function makes Calc open file with changes to save although not edited

https://bugs.documentfoundation.org/show_bug.cgi?id=131932 --- Comment #9 from m.a.riosv --- (In reply to Eike Rathke from comment #8) > OFFSET() is a volatile function recalculated (like RAND() and others) > . > so far no user or macro action whatsoever has occurred. +100 if they lose

[Libreoffice-bugs] [Bug 131932] Using OFFSET function makes Calc open file with changes to save although not edited

https://bugs.documentfoundation.org/show_bug.cgi?id=131932 Eike Rathke changed: What|Removed |Added Status|UNCONFIRMED |NEW Ever confirmed|0

[Libreoffice-bugs] [Bug 131932] Using OFFSET function makes Calc open file with changes to save although not edited

https://bugs.documentfoundation.org/show_bug.cgi?id=131932 Xisco Faulí changed: What|Removed |Added CC||er...@redhat.com,

[Libreoffice-bugs] [Bug 131932] Using OFFSET function makes Calc open file with changes to save although not edited

https://bugs.documentfoundation.org/show_bug.cgi?id=131932 --- Comment #6 from m.a.riosv --- Seems recreate the chart triggers OFFSET(), in many situations OFFSET() can be replaced with INDEX(), which it's not a volatile function. I'm not sure it is really a bug, or a situation to deal when

[Libreoffice-bugs] [Bug 131932] Using OFFSET function makes Calc open file with changes to save although not edited

https://bugs.documentfoundation.org/show_bug.cgi?id=131932 --- Comment #5 from t...@lautenbacher.biz --- (In reply to m.a.riosv from comment #4) > Maybe because OFFSET() It's a volatile function like NOW() or INDIRECT(), so > it is always recalculated with any change in the spreadsheet. I could

[Libreoffice-bugs] [Bug 131932] Using OFFSET function makes Calc open file with changes to save although not edited

https://bugs.documentfoundation.org/show_bug.cgi?id=131932 m.a.riosv changed: What|Removed |Added CC||miguelangelrv@libreoffice.o

[Libreoffice-bugs] [Bug 131932] Using OFFSET function makes Calc open file with changes to save although not edited

https://bugs.documentfoundation.org/show_bug.cgi?id=131932 --- Comment #3 from t...@lautenbacher.biz --- Yes, anything I left over in the file is needed to reproduce the error. If either the cell with the formula or the chart are removed, the error disappears. Originally there were many more

[Libreoffice-bugs] [Bug 131932] Using OFFSET function makes Calc open file with changes to save although not edited

https://bugs.documentfoundation.org/show_bug.cgi?id=131932 raal changed: What|Removed |Added CC||r...@post.cz --- Comment #2 from raal

[Libreoffice-bugs] [Bug 131932] Using OFFSET function makes Calc open file with changes to save although not edited

https://bugs.documentfoundation.org/show_bug.cgi?id=131932 t...@lautenbacher.biz changed: What|Removed |Added Summary|Using the OFFSET command in |Using OFFSET function

[Libreoffice-bugs] [Bug 131932] Using OFFSET function makes Calc open file with changes to save although not edited

https://bugs.documentfoundation.org/show_bug.cgi?id=131932 t...@lautenbacher.biz changed: What|Removed |Added CC||t...@lautenbacher.biz