Issue 56807 - OpenOffice filter does not offer option to ignore trailing spaces
Summary: OpenOffice filter does not offer option to ignore trailing spaces
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 2.0 Beta
Hardware: PC Windows NT
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2005-10-27 18:00 UTC by rvolke
Modified: 2013-08-07 15:12 UTC (History)
3 users (show)

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


Note You need to log in before you can comment on or make changes to this issue.
Description rvolke 2005-10-27 18:00:37 UTC
In Microsoft Office trailing spaces were ignored when filtering a
column.  Is there a way to do this in OpenOffice?  I've looked through
the documentation and was unable to find the answer to this question.
My problem is that when I run the auto-filter on the records, I will
receive multiple representations for the same value because each one has
a different number of spaces trailing the text.  What I really want is
to ignore these trailing spaces like Microsoft Excel did so users don't
need to go in and delete all the trailing spaces.  Thank you for your

I don't know if its needed but I checked this on OpenOffice version 109 and 125 
on two different NT boxes.
Comment 1 frank 2005-11-15 12:07:53 UTC

please use regular expressions for that.

Have a look at the latest comment from Eike on Issue 43156 .

Comment 2 frank 2005-11-15 12:08:25 UTC
closed invalid
Comment 3 rvolke 2005-11-17 17:32:43 UTC
That helps if I want it done at an exact moment, but I'm looking more for 
something that is done automatically by default (like in Excel), I want it such 
that after you apply the autofilter it gives the proper list of values rather 
than having those entries with trailing spaces as sepperate entries in the 
list.  Is there no way to set OpenOffice Calc to ignore trailing spaces by 
default when filtering?  Or is the only option to go through and manually run 
this special filter every time I want spaces ignored?  Thank you
Comment 4 rvolke 2005-12-29 22:58:29 UTC
reopening issue considering my previous post
Comment 5 frank 2006-02-17 09:26:19 UTC
So this is one for the requirements team.