You could even do this dynamically by using the TRANSPOSE() function. So, i would strongly recommend transforming the data using Paste Special together with the Transpose option.

It's much easier just to transform your data so that rows get columns and vice versa. You can't, under the assumption of reasonable expense. 'to filter all columns even before the filtercolumnĬolumns(i).Hidden = Cells(R, i) FilterValue LC = Cells(R, Columns.Count).End(xlToLeft).Column All of the answers I found are containing some macros to get the job done, but they were written for MS Excel, and are not compatible with OpenOfficeįor example, this macros should get the rows filtered, but is not working in OpenOffice Calc: Option ExplicitĬonst FilterColumn = 1 '1 is most logical value but you may change this I have found some information regarding this matter. What I would like to do is to filter only the rows that contain '2' (in this case the rows are second, third and the last in this case). What I can do is to set an autofilter and filter only the rows containing 'B' in the first column. Lets say that I have the following table: The autofilter is sorting data vertically, but I want to filter rows horizontally.

Openoffice calc recalculate