https://bugs.freedesktop.org/show_bug.cgi?id=77990
Priority: medium
Bug ID: 77990
Assignee: [email protected]
Summary: Update of function results
Severity: normal
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: Other
Status: NEW
Version: 4.2.3.3 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 98067
--> https://bugs.freedesktop.org/attachment.cgi?id=98067&action=edit
Test case with wrong results in column D
Problem description: MATCH function returns #N/A because it refers to a cell on
a different sheet which is not updated.
Steps to reproduce:
1. Open attached file (a simplified version of
http://trk.free.fr/calendrier/download.html)
Current behavior:
In sheet "Jours fériés", D5 (and other cells in the same column) display
"#N/A".
Expected behavior:
If you open with LibO 4.1.5.3 the cells are empty.
Confirmed on [email protected]
http://nabble.documentfoundation.org/Calc-4-2-Probleme-de-mise-a-jour-des-fonctions-tt4106597.html
with:
- OpenSuse 13.1 Version 4.2.3.3 and fresh master build Version: 4.3.0.0.alpha1+
Build ID: c6c286f14468d341f5fd88edc39a37175a1b6caa
- Windows 7 Home Premium Version 4.2.4.1 Build ID:
d4c441391e20647b3d2e8dde4d20aa868e77e515 and
Version 4.3.0.0.alpha0+
Build ID: d2555ebb240fea2780f152e5ea39d145aab508fe
TinderBox: Win-x86@39, Branch:master, Time: 2014-04-14_07:59:5
The MATCH function returns #N/A. It refers to D1 which value comes from other
sheet "Calendrier perpétuel".
Workaround: edit D1 and validate value, or Ctrl+Shift+F9 to force calculation.
May be resolution of bug 73113 forget some case?
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
