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: [email protected] 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
