Jako základ můžete vyjít z této funkce: Option Explicit
public function barva(byval sheetName as string, byval row as long, byval col as long) as long
dim document as object dim sheets as object, sheet as object, cell as object document = StarDesktop.CurrentComponent sheets = document.sheets sheet = sheets.getByName(sheetName) cell = sheet.getCellByPosition(row, col) barva = cell.CellBackColor end function Řádky a sloupce jsou číslovány od nuly. Zdravím, Jiří Spitz Zbyněk Burget napsal(a):
potreboval bych v Calcu programove (bud funkci v bunce nebo v Basicu) zjistit barvu pozadi urcite bunky. Presnej receno potrebuju spocitat, kolik bunek v urcite oblasti ma jinou barvu pozadi, nez bilou.
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
