Issue 43157 - Format of text in drop down menu in filter.
Summary: Format of text in drop down menu in filter.
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: 680m79
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2005-02-19 22:47 UTC by alex_rus
Modified: 2013-08-07 15:12 UTC (History)
1 user (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---

Example of filter's drop down menu (51.64 KB, image/jpeg)
2005-02-21 21:30 UTC, alex_rus
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description alex_rus 2005-02-19 22:47:56 UTC
 does it planned  (it will be good to add) the following:
Let say i have the following table

Head 1               Head 2
124.62345234565      133.12346234
123456               1235

when i apply filter it displays value as they are but not as they are formeted
(as does Excel), because in real life the above example will be like:

Head 1               Head 2
125                  133
123456               1235

Is it possible to make value to be shown in drop down menu in filter as they are
in workbook and not with all figures after decimal? As especailly when the
formulas are used there are many digits after point so it's very non-user
friendly to show all these digits.

Comment 1 frank 2005-02-21 21:02:07 UTC

I concur, all digits must be shown as these values could, if rounded, not be
compared to the correct values. 1.35 can be 1.351, 1.352, 1.353 and also 1.354
as well as 1.345, 1.346, 1.347, 1.348, 1.349 and 1.35 .

So I close this as wontfix.

Comment 2 frank 2005-02-21 21:02:28 UTC
closed wontfix
Comment 3 alex_rus 2005-02-21 21:18:38 UTC
sorry for reopen, but may be i didn't clearly stated what i meant.

I don't ask to round digits in filter but to make them show as they are in cells,
so if they are shown in sells as 1.351, 1.352, 1.353 etc, so let filter show
them so,
but there can be many cases (especially when user pastes formula as value) and
when he gets something like:
1.351, 1.352, 1.353135646356
and filter shows exactly as stated above, but user can format these values as
1.351, 1.352, 1.353 - so it can be assumed (i think 100%) that he doesn't
require to know the last nine digits of third value, so and in filter drop down
menu he will see only 3 digits after point and not 3 digits after point for the
first two values and 12 digits after point for the third value.

Please see how it works in Excel: the filter drop down menu shows figures
exactly as they formated in workbook, if they are 1234.111 filter will show
1234.111, if they are 1 234$, i also see in filter 1 234$ and so on.

Comment 4 alex_rus 2005-02-21 21:29:29 UTC
please refer to attached picture:
the value in all cells is the same - 1234,111111, but due to different format of
the cells it is shown differently in the filter's drop down menu (pic 3 and pic
4) - I think it's much more user friendly as how it's made currently.


Comment 5 alex_rus 2005-02-21 21:30:59 UTC
Created attachment 22893 [details]
Example of filter's drop down menu
Comment 6 frank 2005-02-22 08:55:07 UTC
Ok, let's requiorements decide how to proceed.

Comment 7 ace_dent 2008-05-16 00:38:23 UTC Issue Tracker - Feedback Request.

The Issue you raised is currently assigned to 'Requirements' pending review, but
has not been updated within the last 3 years. Please consider re-testing with
one of the latest versions of OOo, as the problem(s) may have already been
addressed. Either use the recent stable version:
or consider trying the new OOo 3 BETA (still in testing):
Please report back the outcome so this Issue may be Closed or Progressed as
necessary - otherwise it may be Resolved as Invalid in the future. You may also
wish to search for (and note) any duplicates of this Issue that may have
advanced further by checking the Issue Tracker:
Many thanks,
Cleaning-up and Closing old Issues as part of:
~ The Grand Bug Squash, pre v3 ~