https://bugs.freedesktop.org/show_bug.cgi?id=77209
Paulo da Silva <psdasi...@yahoo.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|RESOLVED |REOPENED
Resolution|NOTABUG |---
Ever confirmed|0 |1
--- Comment #2 from Paulo da Silva <psdasi...@yahoo.com> ---
Ctrl+Shift+F9 Could serve as a turn around for my work, but it only works after
opening the spreadsheet. This is a bug and a serious one. Until recently it
used to work fine, for several years.
Let's see if I can explain it better.
The small example is only part of a huge spreadsheet to illustrate the problem.
1. The spreadsheet has, among others, two columns: V (values) and C/N (a
confirmation column).
2. I want a sum of the confirmed (those that have a C in the C/N column). I use
dbsum for that.
3. Sometimes I need to confirm a range of values at once. This correspond to
enter a C in each raw of each confirmed value in C/N column. One (unpractical)
way is to enter each C the normal way (C followed by Enter). This works.
Another way is to select the range of column C/N cells for the values I want
confirmed, and enter a C followed by Alt+Enter. This correctly enter the Cs as
pretended but the sum (dbsum) didn't get updated.
4. dbsum cell should be automatically updated.
To see the bug pls. do as follows in the original attached example:
1. Type Ctrl+Shift+F9 after opening the spreadsheet.
The sum is 300 (100 for each C - confirmed value). This is correct.
2. Now, Select for example cells E3:E4. Enter C followed by Alt+Enter.
The sum shows up 100 which is wrong!
BTW, Ctrl+Shift+F9 does not work anymore. It seems to work only immediately
after opening the spreadsheet!
3. You may play with the example entering Cs or Ns the normal way or in ranges
selecting the cells and entering C followed by Alt+Enter. The last way does not
work, unless you save, reopen and type Ctrl+Shift+F9!
Thanks
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
