Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Working with Calc it is bad practise to code relevant information using attributes only. Creating explicit data to give this information would also allow to save it in a csv, a "B(111,222,333)" e.g. telling there is a BckColor described by the specific RGB triple.

To do so will require using custom code. It's a complication - but not a prohibitive one. I can provide an approptiate function if you are interested.

(Irrelevant information needn't be transmitted.)

Working with Calc it is bad practise to code relevant information using attributes only. Creating explicit data to give this information would also allow to save it in a csv, a "B(111,222,333)" e.g. telling there is a BckColor described by the specific RGB triple.

To do so will require using custom code. It's a complication - but not a prohibitive one. I can provide an approptiate function if you are interested.

(Irrelevant information needn't be transmitted.)transmitted.)

===Edit 2019-05-10:25 UTC+02:00 reagrding the comment below===
This thread is very old, and I do not exactly remember what function I had in mind when I first answered.
I posted related code here later, and in the very well structured forum https://forum.openoffice,org/en (branch "Code Snippets e.g.) you find more specialised related routines by others, mostly under the terms "introspection" or "introspective".
I don't think a link would be sufficient, and I will continue to prefer explaining answers if you kindly accept.

Working with Calc it is bad practise to code relevant information using attributes only. Creating explicit data to give this information would also allow to save it in a csv, a "B(111,222,333)" e.g. telling there is a BckColor described by the specific RGB triple.

To do so will require using custom code. It's a complication - but not a prohibitive one. I can provide an approptiate function if you are interested.

(Irrelevant information needn't be transmitted.)

===Edit 2019-05-10:25 UTC+02:00 reagrding the comment below===
This thread is very old, and I do not exactly remember what function I had in mind when I first answered.
I posted related code here later, and in the very well structured forum https://forum.openoffice,org/en (branch "Code Snippets e.g.) you find more specialised related routines by others, mostly under the terms "introspection" or "introspective".
I don't think a link would be sufficient, and I will continue to prefer explaining answers if you kindly accept.

Working with Calc it is bad practise to code relevant information using attributes only. Creating explicit data to give this information would also allow to save it in a csv, a "B(111,222,333)" e.g. telling there is a BckColor described by the specific RGB triple.

To do so will require using custom code. It's a complication - but not a prohibitive one. I can provide an approptiate function if you are interested.

(Irrelevant information needn't be transmitted.)

===Edit 2019-05-10:25 UTC+02:00 reagrding the comment below===
This thread is very old, and I do not exactly remember what function I had in mind when I first answered.
I posted related code here later, and in the very well structured forum https://forum.openoffice,org/en (branch "Code Snippets e.g.) you find more specialised related routines by others, mostly under the terms "introspection" or "introspective".
I don't think a link would be sufficient, and I will continue to prefer explaining answers if you kindly accept.

Working with Calc it is bad practise to code relevant information using attributes only. Creating explicit data to give this information would also allow to save it in a csv, a "B(111,222,333)" e.g. telling there is a BckColor described by the specific RGB triple.

To do so will require using custom code. It's a complication - but not a prohibitive one. I can provide an approptiate function if you are interested.

(Irrelevant information needn't be transmitted.)

===Edit 2019-05-10:25 UTC+02:00 reagrding the comment below===
This thread is very old, and I do not exactly remember what function I had in mind when I first answered.
I posted related code here later, and in the very well structured forum https://forum.openoffice,org/en (branch "Code Snippets e.g.) you find more specialised related routines by others, mostly under the terms "introspection" or "introspective".
I don't think a link would be sufficient, and I will continue to prefer explaining answers if you kindly accept.

accept.
===Edit same day 13:53 UTC+02:00===
This may have been the function I had in mind years ago:

Function cellBackColor(pZ As Long, pCellName As String, Optional pDummy)
'pDummy shall only provide a way to trigger execution based on any reference or volatile function in Calc.
'pZ is the 1-based index iof the sheet as returned in Calc by the SHEET() function.
 Dim theCell As Object, backColor As Long
cellBackColor = 4294967295
On Error GoTo errorExit
theCell       = ThisComponent.Sheets(pZ - 1).getCellRangeByName(pCellName)
backColor     = theCell.CellBackColor
cellBackColor = backColor
errorExit:
End Function