How can I get the color of data

DMakurat · General User Joined: 05 Oct 2006 Posts: 15

I am importing HTML tables into a spreadsheet. Positive numbers are green and negative ones are red.

I need to write a macro to manipulate the numbers.

Is there a way to determine the color of the number so I can tell which are positive and which are negative?

carl · Posted: Mon Oct 09, 2006 10:32 pm Post subject:

In Format /cell/numbers/ there is an option that shows black for positve and red for negative.
If you want another colouryou can adapt the option in the "FORMAT CODE box. just change the name of the colour from red and hit the tick.
_________________
carl
Using OpenOffice.org 2 on XP sp2

DMakurat · General User Joined: 05 Oct 2006 Posts: 15

Thank you for the response. However, I am working on detecting the color rather than changing it.

I used a "DisplayMethods" subroutine from Andrew Pitonyak's Macro write up and found that there is CharColor property of the cell. I can then use Red(color) to get the red component.

Villeroy · Posted: Tue Oct 10, 2006 8:52 am Post subject:

Your imported cells have red fonts instead of negative values?
Save my collection of introspective cell functions in basic-container "My Macros", library "Standard" and add this: