Issue 106521 - setting rows to default format returns previously removed data filter
Summary: setting rows to default format returns previously removed data filter
Status: CLOSED IRREPRODUCIBLE
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: OOO310m19
Hardware: All Linux, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: needmoreinfo
Depends on:
Blocks:
 
Reported: 2009-11-01 11:10 UTC by nadavkav
Modified: 2017-05-20 09:57 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description nadavkav 2009-11-01 11:10:35 UTC 
i got an xls sheet from someone, i saved it to ods format
selected the first row and click (menu) data > filter > auto filter
to remove the filter from the first row.
filter was gone :-)

now, i selected the rows and clicked (from the menu) format > default formatting.
indeed, the default formatting was applied BUT! the auto filter came back ???
not what i was expecting. is this a bug or an intended behavior ?
Comment 1 sshearer 2010-07-22 00:17:04 UTC 
I had a spreadsheet with all columns set with Auto Filter enabled.  I then added
a set of new/additional columns.

At some point in making changes to the spreadsheet, the original columns lost
their 'Auto Filter', but the new columns kept theirs.  

Even if I set all columns to have 'Auto Filter', save, and re-open, I'm back to
the original columns with no 'Auto Filter' and the new columns with 'Auto Filter'.
Comment 2 sshearer 2010-07-22 00:20:49 UTC 
I also have another open/change/save/loose changes problem.

I have a spreadsheet where (I WANT) a few cells in the 1st column have Word Wrap
ON, and then more cells to the right where Word Wrap is OFF.  

I make the above settings, edit the data, print it fine, save, & close.  When I
re-open, the block of cells which SHOULD have Word Wrap OFF is actually set to ON.

In general, it appears there's a series of features which don't save their
settings within the file format.
Comment 3 Edwin Sharp 2013-11-20 20:11:32 UTC 
Please attach example.
Comment 4 Edwin Sharp 2013-12-03 08:49:34 UTC 
No info from author.