Issue 43157

Summary: Format of text in drop down menu in filter.
Product: Calc Reporter: alex_rus <cc>
Component: editingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues
Version: 680m79   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
Example of filter's drop down menu none

Description alex_rus 2005-02-19 22:47:56 UTC 
Hi,
 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.

Alexander
Comment 1 frank 2005-02-21 21:02:07 UTC 
Hi,

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.

Frank
Comment 2 frank 2005-02-21 21:02:28 UTC 
closed wontfix
Comment 3 alex_rus 2005-02-21 21:18:38 UTC 
Hi, 
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.

Alexander
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.

Alexander
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.

Frank
Comment 7 ace_dent 2008-05-16 00:38:23 UTC 
OpenOffice.org 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:
http://download.openoffice.org/index.html
or consider trying the new OOo 3 BETA (still in testing):
http://download.openoffice.org/3.0beta/
 
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:
http://www.openoffice.org/issues/query.cgi
 
Many thanks,
Andrew
 
Cleaning-up and Closing old Issues as part of:
~ The Grand Bug Squash, pre v3 ~
http://marketing.openoffice.org/3.0/announcementbeta.html