Apache OpenOffice (AOO) Bugzilla – Issue 43157
Format of text in drop down menu in filter.
Last modified: 2013-08-07 15:12:27 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
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
closed wontfix
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
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
Created attachment 22893 [details] Example of filter's drop down menu
Ok, let's requiorements decide how to proceed. Frank
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