You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2012/09/11 09:56:18 UTC
[Bug 120883] New: [From Symphony]AutoFilter: filter data lost when
there are two sheets sharing the same data base range
https://issues.apache.org/ooo/show_bug.cgi?id=120883
Priority: P3
Bug ID: 120883
Assignee: ooo-issues@incubator.apache.org
Summary: [From Symphony]AutoFilter: filter data lost when there
are two sheets sharing the same data base range
Severity: normal
Issue Type: DEFECT
Classification: Application
OS: All
Reporter: louqingle@gmail.com
Hardware: All
Status: CONFIRMED
Version: AOO350-dev
Component: formatting
Product: spreadsheet
Created attachment 79394
--> https://issues.apache.org/ooo/attachment.cgi?id=79394&action=edit
sample file
build: 1381968
1. open the sample file
2. check the autofilter in sheet2
no data in the auto filter list except the three menus "Top 10"...
There are two sheets containing the same data
In sheet1 there is a custom filter for column B: less than 10
In sheet2 there is the filter for column B is Top 10
While the filter data in sheet2 lost...
This happens on both win7 64-bit, XP and suse 11 sp1
But this may be a regression since on my XP against build 1376366, it works
fine.
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 120883] AutoFilter in .XLS (MSO97): filter data lost when there
are two sheets sharing the same data base range
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120883
Rainer Bielefeld <ra...@bielefeldundbuss.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
Keywords| |regression
CC| |rainerbielefeld_ooo_qa@biel
| |efeldundbuss.de
Summary|AutoFilter: filter data |AutoFilter in .XLS (MSO97):
|lost when there are two |filter data lost when there
|sheets sharing the same |are two sheets sharing the
|data base range |same data base range
--- Comment #1 from Rainer Bielefeld <ra...@bielefeldundbuss.de> ---
Without understanding the details, i can CONFIRM reporter'sobervations with
"AOO 4.1.0-Dev – English UI / German locale - [AOO410m1(Build:9750) - Rev.
1516435 2013-08-24]" on German WIN7 Home Premium (64bit)", own separate user
profile:
1. From AOO Start Center open reporter's sample document
2. InSsheet2.B1 click Autofilter dropdown arrrow
> Filter list appears
Expected: Should show all values in column
Actual: only shows "All", "Top 10". "Standard Filter" !!!
3. Continue, click 'Standard Filter'
Expected: Filter Criteria dialog will open
Actual: Nothing !!!
Additional info:
-----------------
a) That still worked fine with server installation of "AOO 3.4.1 – German UI /
German locale [AOO341m1(Build:9593) - Rev.1372282]" on German WIN7 Home Premium
(64bit)", own separate user profile. so REGRESSION
b) already broken in Rev. 1457992 (as expected due to report)
c) competitors: Works fine with LibO 4.0.3.3, Calligra, SoftMaker FreeOffice
d) I saved reporter's sample as Book2fromLibO4.ods, with that document
autofilter worked fine in AOO 4
e) I reopened Book2fromLibO4.ods with LibO and saved as Book2fromLibO4.xls
Problem reappeared with AOO 4
--
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.
[Bug 120883] [From Symphony]AutoFilter: filter data lost when there
are two sheets sharing the same data base range
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120883
louqle <lo...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Keywords| |ms_interoperability
Component|formatting |open-import
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 120883] AutoFilter: filter data lost when there are two sheets
sharing the same data base range
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120883
Yan Ji <ya...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Summary|[From Symphony]AutoFilter: |AutoFilter: filter data
|filter data lost when there |lost when there are two
|are two sheets sharing the |sheets sharing the same
|same data base range |data base range
--
You are receiving this mail because:
You are the assignee for the bug.
[Bug 120883] AutoFilter in .XLS (MSO97): filter data lost when there
are two sheets sharing the same data base range
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120883
Andre <aw...@googlemail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |awf.aoo@googlemail.com
--- Comment #2 from Andre <aw...@googlemail.com> ---
I saved the bug document with Excel (2013) to ODS and XSLX. Loading these with
AOO 4.1 (developer build) results in:
- ODS is loaded without any filter on sheet2
- XLSX is loaded currectly, i.e. filters on sheet2 exist and work as expected.
--
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.
[Bug 120883] AutoFilter in .XLS (MSO97): filter data lost when there
are two sheets sharing the same data base range
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120883
--- Comment #3 from Andre <aw...@googlemail.com> ---
Bug 120478 did not cause this issue but also did not fix it, because it
targeted only OOXML, not the binary format of Excel.
--
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.
[Bug 120883] [From Symphony]AutoFilter: filter data lost when there
are two sheets sharing the same data base range
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120883
Yan Ji <ya...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Blocks| |121014
--
You are receiving this mail because:
You are the assignee for the bug.