Applying row based filter instead of column based in LibreOffice or other SpreadSheet tool

excel libreoffice openoffice-calc libreoffice-calc
Ister picture Ister · Sep 29, 2014 · Viewed 29.7k times · Source

We all know the standard filter, where you pick which rows to show depending on values in a particular column (or columns). Is it at all possible to the the same, but picking which columns should be visible depending on the values of a single row? The only ideas I have so far is to either write a macro or do it manually.

Answer

ZAT picture ZAT · Sep 29, 2014

Can not post comment yet, so:

Can you do normal excel operations in your tool like:

copy the data area and pastespecial as transpose and then apply filter to columns.

Related questions

Row numbering selection auto-fill till the end

I have a table with thousands of lines. I want to number rows by adding 1 2 3 next to first rows, then to select these and drag till end to make a fill with increasing numbers. How to autofill till last row …

Read More
How do I make vba code compatible with libre office

I have recently migrated to pclinuxos from windows and seem to like it. The only problem I am facing is that libreoffice, the default spreadsheet package is not compatible with excel macros. Below is the vba code I have: Option …

Read More
Excel VLOOKUP where the key is not in the first column

"The range where the lookup value is located. Remember that the lookup value should always be in the first column in the range for VLOOKUP to work correctly. For example, if your lookup value is in cell C2 then your …

Read More