You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2020/02/05 17:03:30 UTC
[Issue 128278] New: Assortment
https://bz.apache.org/ooo/show_bug.cgi?id=128278
Issue ID: 128278
Issue Type: DEFECT
Summary: Assortment
Product: Calc
Version: 4.1.7
Hardware: PC
OS: Windows 10
Status: UNCONFIRMED
Severity: Normal
Priority: P5 (lowest)
Component: programming
Assignee: issues@openoffice.apache.org
Reporter: zalfa@web.de
Target Milestone: ---
Created attachment 86819
--> https://bz.apache.org/ooo/attachment.cgi?id=86819&action=edit
Calc-Sortierung
Hallo,
I wish with the assortment of a table a user-defined method, e.g., assortment
after written colours, very simply like in office Excel MS.
Greetings
Gabi
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 128278] Assortment
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=128278
Gabi <za...@web.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
Keywords| |performance
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 128278] sorting a calc table by a custom sort rule
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=128278
--- Comment #5 from oooforum (fr) <oo...@free.fr> ---
I don't speak german but I don't see any XLS or XLSX document to understand
this feature.
The OP could provide an example?
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 128278] Assortment
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=128278
oooforum (fr) <oo...@free.fr> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
Resolution|--- |NOT_AN_OOO_ISSUE
CC| |oooforum@free.fr
--- Comment #3 from oooforum (fr) <oo...@free.fr> ---
Remember that we don't have MS-Excel and a screenshot is not enough to
reproduce.
You are in wrong place here. This is not a help-desk tool.
If you have some difficulties to use OpenOffice, you must jump our forum or
mailing list dedicated for end-users:
http://www.openoffice.org/support/index.html
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 128278] Assortment
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=128278
--- Comment #2 from Gabi <za...@web.de> ---
Created attachment 86821
--> https://bz.apache.org/ooo/attachment.cgi?id=86821&action=edit
Sortierung
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 128278] sorting a calc table by a custom sort rule
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=128278
Peter <pe...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Summary|Assortment |sorting a calc table by a
| |custom sort rule
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 128278] sorting a calc table by a custom sort rule
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=128278
--- Comment #8 from Peter <pe...@apache.org> ---
Well we should not depend on external description for requirement. That is why
I have uploaded the doc. Please if you need more info then ask away. I can
check the Forum thread too if needed for clues.
We can also enhance based on the input.
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 128278] Assortment
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=128278
Gabi <za...@web.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
Attachment #86819|0 |1
is obsolete| |
--- Comment #1 from Gabi <za...@web.de> ---
Created attachment 86820
--> https://bz.apache.org/ooo/attachment.cgi?id=86820&action=edit
Sortieren_calc
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 128278] sorting a calc table by a custom sort rule
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=128278
--- Comment #6 from Peter <pe...@apache.org> ---
Created attachment 86822
--> https://bz.apache.org/ooo/attachment.cgi?id=86822&action=edit
example and mockup for the sort process
I am not sure if we get an answer.
From my understanding gained from the german discussion I have created a
document that has an example for
1) original order on the first sheet
2) expected result after the "sort tool" has been used
3) and a mockup on the dialog that I mimicked from the screenshots.
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 128278] Assortment
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=128278
Gabi <za...@web.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
Attachment #86819|Sortierung.jpg |Sortierung
filename| |
Attachment #86819|Calc-Sortierung |Sortierung
description| |
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 128278] sorting a calc table by a custom sort rule
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=128278
--- Comment #7 from oooforum (fr) <oo...@free.fr> ---
Well, I ask a document because I don't know how can make this list in MS-Excel.
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 128278] Assortment
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=128278
Peter <pe...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
OS|Windows 10 |All
Issue Type|DEFECT |ENHANCEMENT
Resolution|NOT_AN_OOO_ISSUE |---
CC| |petko@apache.org
Ever confirmed|0 |1
Status|RESOLVED |REOPENED
--- Comment #4 from Peter <pe...@apache.org> ---
Actually she wants to have a way for custom sorting.
In a config she declares a Row, a Property (example color), sets up the order
for existing colors, and the Table gets sorted in this criteria.
Related Forum discussion:
https://de.openoffice.info/viewtopic.php?f=2&t=74276
I did not find a similar Bug, so I reopening.
Maybe this is better solved as extension. (I am not sure maybe there has been
done something in the forum. I mean at least base work)
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 128278] sorting a calc table by a custom sort rule
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=128278
joesch <jo...@web.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |joesch04@web.de
--- Comment #9 from joesch <jo...@web.de> ---
Sorting by color is a normal function in Excel and I also find it useful to
refer to Excel because there you can see the function ready.
For example here is a video:
https://www.youtube.com/watch?v=_IgPAHe0mN8
> description for requirement
in AOO it is possible to sort (and filter) by values and text. In some cases
sorting lists can be used.
Now a function is desired with which it is possible to sort (and filter) in
Calc by colors.
Because colors have no fixed order it will be necessary to use (temporary) sort
lists when implementing such a function.
(By a temporary sort list I do not understand anything else than a GUI where
the user can specify the desired order for the colors which are used for
sorting).
Note:
the issue does _not_ ask for the Filter by color function, but this is a
function very similar to the Sort by color function, which is why I mentioned
it.
--
You are receiving this mail because:
You are the assignee for the issue.