[libreoffice-users] Re: Calc: How to refresh advanced filter automatically

David S. Crampton wrote
> It might help us to know more about your application. There are functions  
> within Calc to do this under the menu item: Data.  Using these  
> database-like operations in Calc (or any other spreadsheet) requires a  
> reasonably experienced level of user.  The user must place the "15" in  
> exactly the correct cell and then navigate to the portion of the  
> spreadsheet which will display the result.
You are right, I had to provide more details.

Spreadsheet is used to parse fixed-length messages. There are around 100
different messages, and each contains different fields. For example, message
01 contains 3 fields with length 10, and 1 field with length 5, and message
02 contains 2 fields with lengths 3 and 2.

I have XLS file (prepared by another person) like:
A | B | C | D
M02My-very-complex-message
M01 | =MID($A$1;C2;D2) | 1 | 10
M01 | =MID($A$1;C3;D3)  | 11 | 10
M01 | =MID($A$1;C4;D4)  | 21 | 10
M01 | =MID($A$1;C4;D4)  | 31 | 5

M02 | =MID($A$1;C5;D5) | 1 | 3
M02 | =MID($A$1;C6;D6) | 4 | 2

So when I need to parse a message, I enter it into A1, then go to autofilter
and select message type (01, if it's message 01)
What I want is to eliminate this last step, so filter should change
automatically when I enter message into A1.

Oleg.

--
View this message in context: 
http://nabble.documentfoundation.org/Calc-How-to-refresh-advanced-filter-automatically-tp3561522p3563813.html
Sent from the Users mailing list archive at Nabble.com.

-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted