Issue 41533 - Special Filter works only with up to 4 criteria-lines
Summary: Special Filter works only with up to 4 criteria-lines
Status: CLOSED NOT_AN_OOO_ISSUE
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 1.1.4
Hardware: PC Windows 2000
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords: needmoreinfo, oooqa
Depends on:
Blocks:
 
Reported: 2005-01-28 11:53 UTC by tommyads
Modified: 2005-04-24 10:20 UTC (History)
2 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 tommyads 2005-01-28 11:53:20 UTC 
Data lines are on Sheet P1, the filter description is on sheet P1_Filter. 
The options used are: 
* filter-output goes to sheet P1_Filter (from Cell A20 downwards)
* the filter descriptions are on sheet P1_Filter (Cells A1:T7)
* each filter description line is like '<>3' in one cell, and '<>' in another 
cell (the lines differ only in that '<>' is in a different column).

When I use only 4 or less filter-description-lines (not counting the header-
line with the column-titles), then it works well. Using 5 or more filter-
description-lines issues the message "Dieser Bereich enthält keine gültige 
Abfrage." (= "this region does not contain a valid query").

Thanks!
Kind regards
tommyads
Comment 1 tommyads 2005-01-28 12:09:45 UTC 
# -----------------------------------------------------------------
These are the filter-description-lines, i.e. the filter-criteria:
(copy it and paste it into an editor, column separation by tab)

PHASEN 2 & 3 – 2005	Eintrag	Datum	Von	Phase	Kat	Wer	Std.
	Tage	Status	AO	FME	DB	P&T	HB	DM	LYR
	PLOT	IBM	Max-Zeit
				<>3						
		<>							
				<>3						
			<>						
				<>3						
				<>					
				<>3						
					<>				
				<>3						
						<>			
				<>3						
								<>	
# END --- this line is not part of the filter criteria
Comment 2 frank 2005-02-01 10:53:29 UTC 
Hi,

I'm not able to reproduce your problem, please attach a document showing it.

Frank
Comment 3 flibby05 2005-04-24 10:19:08 UTC 
hi tommyads,
we cannot proceed with this issue without having a sample document.
closing as invalid, please reopen if you can repro again with latest snapshot
build and please add an attachment.
thank you,
Max

http://download.openoffice.org/680/index.html
Comment 4 flibby05 2005-04-24 10:20:24 UTC 
.