https://bugs.freedesktop.org/show_bug.cgi?id=83109
Priority: medium
Bug ID: 83109
Assignee: [email protected]
Summary: Proposition to improve(?) calc merged cells behaviour
Severity: enhancement
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: Other
Status: UNCONFIRMED
Version: unspecified
Component: Spreadsheet
Product: LibreOffice
Hi,
Let me present the problem:
I am used to use a lot spreadsheet programs to categorize data. Let the first
column contain the category, the second the data.
Example:
a | 10
a | 12
a | 30
b | 20
c | 14
d | 12
d | 50
Normally, I am using the identical categories as merged cells, so only one "a"
is visible. It is ok visually.
a | 10
| 12
| 30
b | 20
c | 14
d | 12
| 50
But if I want to count the data belonging to category "a", I have only 1 as
result, because it is the only "a" item in category column.
OK, I could use other methods to count them, but the actual behaviour, I think,
can be better.
If the merged cells would return "a" for each contained cells, the use of
formulas for merged cells could be correct.
Or filtering: using a filter, only the first row is captured, but not the rest.
In the filter, I would like to see for "a":
a | 10
| 12
| 30
and not
a | 10
Maybe a simple checkbox would be enough:
[ ] multiply data for merged cells/ data categorize mode or an icon that change
the behaviour.
... or something similar.
I don't know if it is an improvement or not, for me, it would be fine.
Thanks for your attention.
--
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
