sort by color

answered 2012-08-03 19:44:56 +0200

This post is a wiki. Anyone with karma >750 is welcome to improve it.

updated 2013-01-29 15:06:08 +0200

qubit
5693 ● 3 ● 48 ● 41

Here's one way. Add a macro function that returns a cell's background color as a number. Add a new column filled with that function that addresses the target background-colored cells. Sort on the numbers in the new column (use Ctrl-Shift-F9 to recalculate all functions before sorting. Be sure to include Option/Formats in the sort)

The auxilliary column contains the formula =BGCOLOR(CELL("COL",A1),CELL("ROW",A1)) where A1 is the target cell.

function bgcolor(col,row)
  rem # Returns background color of addressed cell
  s=thiscomponent.getcurrentcontroller.sheets.getbyname("Sheet1")
  cell=s.getcellbyposition(col-1,row-1)
  bgcolor=cell.cellBackColor
end function

answered 2013-03-26 10:48:45 +0200

This post is a wiki. Anyone with karma >750 is welcome to improve it.

updated 2013-03-26 10:49:22 +0200

camel1cz
1 ● 1 ● 2

Same problem as @Nissim. To solve it replace first line:

s=thiscomponent.getcurrentcontroller.sheets.getbyname("Sheet1")

With:

s=ThisComponent.sheets.getbyname("Sheet1")

answered 2013-03-08 22:45:45 +0200

This post is a wiki. Anyone with karma >750 is welcome to improve it.

updated 2013-03-08 22:45:45 +0200

Funkyecat
1

Instructions poor. Do you enter '=BGCOLOR(CELL("COL",A1),CELL("ROW",A1)) where A1 is the target cell." in another column and drag down

where do you enter the macro.

answered 2012-10-04 03:06:25 +0200

This post is a wiki. Anyone with karma >750 is welcome to improve it.

updated 2012-10-04 03:06:25 +0200

Nissim
1

I got this error:

LibreOffice 3.5 BASIC runtime error: property or method not found: sheets.