Create color scale in a range of cells in Calc

[turulomio]

Hi. This is my first post
I'm trying to make a conditional format color scale in a range of cells, programatically
I'm trying to set in range "B1:B8" the same as in "A1:A8" in attachment example
Any help, please
Thanks

Code: Select all

from os import path
from uno import getComponentContext, systemPathToFileUrl
from com.sun.star.beans import PropertyValue
localContext = getComponentContext()

resolver = localContext.ServiceManager.createInstance('com.sun.star.bridge.UnoUrlResolver')
ctx = resolver.resolve('uno:socket,host=127.0.0.1,port=2002;urp;StarOffice.ComponentContext')
desktop = ctx.ServiceManager.createInstance('com.sun.star.frame.Desktop')

args=(
    PropertyValue('AsTemplate',0,True,0),
)
template=systemPathToFileUrl(path.abspath("colorscale.ods"))
document=desktop.loadComponentFromURL(template,'_blank', 8, args)

sheet=document.getSheets().getByIndex(0)

# I create and select a range of cells
oRangos = document.createInstance("com.sun.star.sheet.SheetCellRanges")
oRangos.addRangeAddress( sheet.getCellRangeByName( "B1:B8" ).getRangeAddress() ,False )
document.getCurrentController().select(oRangos)
        
#I create a conditional format range in the sheet
cfs=sheet.ConditionalFormats.createByRange(oRangos)
cf=sheet.ConditionalFormats.getConditionalFormats()[cfs-1]

# I Create a colorscale conditional format
cf.createEntry(1, 0)   #1 iS COLORSCALE

# I don't know how to follow
#new = createUnoStruct("com.sun.star.sheet.XColorScaleEntry")


save_args=(
    PropertyValue('FilterName', 0, 'calc8', 0),
)
document.storeAsURL(systemPathToFileUrl(path.abspath("output.ods")), (save_args))
document.dispose()

[Zizi64]

- The LibreOffice has more than 3 conditions inthe Conditional Format feature. Therefore you can apply lots of the cell styles based on the cell content.

- The LibreOffice has Color Scale type method in the CF feature.

Try the LibreOffice.


And you can use the additional function STYLE() in the Cell formulas, what can apply various cell styles based on the composed style names like the

Code: Select all

CalculatingFormula+STYLE"MyCellStyle"&TEXT(CalculatingFormula;"0")

Based on the cell values 1, 2, 3, 4, 5, 6, the applied Cell Styles will be:
MyCellStyle1
MyCellStyle2
MyCellStyle3
MyCellStyle4
MyCellStyle5
MyCellStyle6
...and the cell styles must contain the desired background colors.

[Villeroy]

If it can't be done in the GUI, it is very unlikely that it could be done by macro code.
If you can to it in the GUI, simply run MRI to inspect what you have done in the GUI.
[Tutorial] Introduction into object inspection with MRI