Ask Your Question
0

How to sort columns in rows [closed]

asked 2017-08-20 05:33:03 +0200

seschenburg gravatar image

updated 2020-07-21 23:23:19 +0200

Alex Kemp gravatar image

I've a block of columns and rows that are similar to this:

  • 1 |8 |38|47|43
  • 21|32|3 |37|26
  • 23|12|33|65|51

and I want them to sort into this:

  • 1 |8 |38|43|47
  • 3 |21|26|32|37
  • 12|23|33|51|65

IOW, I want the columns in each row to reorder such that the number values increase to the right. I select a block of cells...Sort...enable the Left to Right (Sort Columns) feature...OK, but it only works on one row at a time, even if I have multiple rows selected in the block. What am I doing wrong?

LibreOffice 5.3 with latest updates TIA

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-07-21 23:24:10.896226

3 Answers

Sort by » oldest newest most voted
0

answered 2019-08-04 23:55:58 +0200

georgebueno gravatar image

hello, you can use a function to solve your problem. Type this =SMALL($A1:$E1,COLUMN()-6) at G1 cell and copy it till K3 (if you have 5 columns and 3 rows). It worked greatly for me, but please don't ask me for details because I just don't know. Ijust made the same question in the portuguese (pt-br) forum and got the answer from a real spreadsheet's master.

Original answer: https://ask.libreoffice.org/pt-br/que...

edit flag offensive delete link more
0

answered 2019-08-05 16:47:49 +0200

karolus gravatar image

@librebel… a kind of nobrainer in python:

def sort_rows_individually(*_):
    """    
    sorts row by row individually 
    in one selected  Cellrange
    """   
    doc = XSCRIPTCONTEXT.getDocument()
    selection = doc.getCurrentSelection()
    inData = selection.DataArray
    outData = [sorted(row) for row in inData]
    selection.setDataArray(outData)

tested with an 15cols x 30000rows Array of random numbers on a RaspberryPi3

edit flag offensive delete link more

Comments

ok ;-) just realize the original thread starts August/2017

karolus gravatar imagekarolus ( 2019-08-05 16:54:31 +0200 )edit
0

answered 2017-08-20 08:24:57 +0200

Lupp gravatar image

If you sort a 2D range the first sortkey will apply.
Additional columns/rows will join the first one. That's the behaviour mostly needed.
You cannot change that. (Neither if a column is used as first key (option top down) nor if it is a row (option left to right.)

edit flag offensive delete link more

Comments

With a bit of work, selecting and sorting row by row.

m.a.riosv gravatar imagem.a.riosv ( 2017-08-20 12:01:22 +0200 )edit

I see. Hmmm, 2000+ rows. bleh.

Ok, thanks.

seschenburg gravatar imageseschenburg ( 2017-08-20 14:19:56 +0200 )edit

it can be automated with a macro.

librebel gravatar imagelibrebel ( 2017-08-20 14:42:41 +0200 )edit

Question Tools

1 follower

Stats

Asked: 2017-08-20 05:33:03 +0200

Seen: 2,988 times

Last updated: Aug 05 '19