[Libreoffice-bugs] [Bug 106575] Correct VLOOKUP Formula - Incorrect Value shown. Shows correct value if formula reapplied / changes made in other sheets

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=106575

--- Comment #17 from Amit Seal Ami  ---
Dear Buovjaga,
Sorry to revive this dead thread again; but this bug hit me again. 
Since I am in academia, this is a issue that affects the grade of students if
the values are not hard recalculated every time. 

I have went through #82135, and the statement was: "The mentioned behaviour
here is not a bug. We are using cached values and if the file contains wrong
values there is nothing we can do."

However, I have to disagree. 

For a file that was created, edited and maintained only using LibreOffice Calc,
if the cached values are wrong - it should be a problem of LibreOffice, and not
the file itself. 

At least the "Always Recalculate" should be turned on by default in LibreOffice
Calc.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 106575] Correct VLOOKUP Formula - Incorrect Value shown. Shows correct value if formula reapplied / changes made in other sheets

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=106575

Yousuf Philips (jay)  changed:

   What|Removed |Added

 Blocks||109329


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=109329
[Bug 109329] [META] VLookup function bugs and enhancements
-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 106575] Correct VLOOKUP Formula - Incorrect Value shown. Shows correct value if formula reapplied / changes made in other sheets

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=106575

Buovjaga  changed:

   What|Removed |Added

 Status|UNCONFIRMED |RESOLVED
 Resolution|--- |NOTABUG

--- Comment #16 from Buovjaga  ---
The document contains cached values and hard recalc helps with that. Here is an
example of a similar case:
https://bugs.documentfoundation.org/show_bug.cgi?id=82135#c18 I will close this
as notabug just like that other.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 106575] Correct VLOOKUP Formula - Incorrect Value shown. Shows correct value if formula reapplied / changes made in other sheets

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=106575

--- Comment #15 from Amit Seal Ami  ---
(In reply to Buovjaga from comment #14)
> (In reply to Amit Seal Ami from comment #13)
> > Can not there be a feature as an option that will hard recalc the sheet when
> > the file is closed? Doing so by default will hit performance understandably.
> 
> The developers want to keep it as a development/debugging feature.

so... is this a confirmed bug? Anything I can do here to help?

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 106575] Correct VLOOKUP Formula - Incorrect Value shown. Shows correct value if formula reapplied / changes made in other sheets

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=106575

--- Comment #14 from Buovjaga  ---
(In reply to Amit Seal Ami from comment #13)
> Can not there be a feature as an option that will hard recalc the sheet when
> the file is closed? Doing so by default will hit performance understandably.

The developers want to keep it as a development/debugging feature.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 106575] Correct VLOOKUP Formula - Incorrect Value shown. Shows correct value if formula reapplied / changes made in other sheets

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=106575

--- Comment #13 from Amit Seal Ami  ---
(In reply to Buovjaga from comment #12)
> I confirm that it needs a hard recalc (Ctrl-Shift-F9). After that and saving
> & reloading, the values stay.
> 
> There have been some vlookup recalc bugs: bug 61662 (but it went away).
> 
> Not sure what can be done about this.
> 
> Arch Linux 64-bit, KDE Plasma 5
> Version: 5.4.0.0.alpha0+
> Build ID: 54f9a81a1c041c18d209d7eb4659ac18a3ca76dd
> CPU threads: 8; OS: Linux 4.10; UI render: default; VCL: kde4; 
> Locale: fi-FI (fi_FI.UTF-8); Calc: group
> Built on March 25th 2016

Hi Buovjaga,
Thank you for the tips. I didn't know about the shortcut. I will definitely be
using this shortcut every time before pressing ctrl+s.

Can not there be a feature as an option that will hard recalc the sheet when
the file is closed? Doing so by default will hit performance understandably.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 106575] Correct VLOOKUP Formula - Incorrect Value shown. Shows correct value if formula reapplied / changes made in other sheets

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=106575

Buovjaga  changed:

   What|Removed |Added

 CC||todven...@suomi24.fi
Summary|Correct Formula - Incorrect |Correct VLOOKUP Formula -
   |Value shown. Shows correct  |Incorrect Value shown.
   |value if formula reapplied  |Shows correct value if
   |/ changes made in other |formula reapplied / changes
   |sheets  |made in other sheets

--- Comment #12 from Buovjaga  ---
I confirm that it needs a hard recalc (Ctrl-Shift-F9). After that and saving &
reloading, the values stay.

There have been some vlookup recalc bugs: bug 61662 (but it went away).

Not sure what can be done about this.

Arch Linux 64-bit, KDE Plasma 5
Version: 5.4.0.0.alpha0+
Build ID: 54f9a81a1c041c18d209d7eb4659ac18a3ca76dd
CPU threads: 8; OS: Linux 4.10; UI render: default; VCL: kde4; 
Locale: fi-FI (fi_FI.UTF-8); Calc: group
Built on March 25th 2016

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs