GNOME.org
 

Re: [orca-list] Finding the color of a cell in Libre Office Calc

On 31/01/12 08:04, Christopher Chaltain wrote:

I was thinking about this a bit, and on the question of precision, I
don't know that we need to worry about that too much for an office
suite. Obviously, having the ability to get to that precise data would
be important, but if we assume whoever created the document isn't going
to use two colors that are hard to distinguish from one another then a
rough approximation may be all that's needed for most cases.

On 30/01/12 16:34, Peter Korn wrote:

Steve,

For a long time I've thought about writing a function to provide a
best-match reverse lookup of the X Windows color names database (see
http://en.wikipedia.org/wiki/X11_color_names).  This would give you 144
colors (rather than 2^24).  (actually, somewhat less than 144 colors
since some names like "Cyan" and "Aqua" map to the same RGB tuple).

Thus, 255:255:0 is "Yellow", but so would be 255:250:0.  However,
255:215:0 is "Gold", as would be 255:220:0.  Somewhere as green got more
prominent (more than 220 but less than 250) "Gold" would switch to
"Yellow".  And it would get more complex as we get some Blue in the
mix... etc.


Alas I don't have the time to put into something like this, but perhaps
someone else on this list does?


Peter

On 1/30/2012 2:07 PM, Steve Holmes wrote:

I don't think this is a Libreoffice problem.  I think this is what you
get from gnome.  Actually, this is the most precise information you
can get.  Yes, color names would be better but less precise; so as
long as both options are kept available, it would be good.  I have an
idea though.  If I were to write a function, I would merely pass the
RBG values to the function and it could dial in a subscript from an
array of 256 values for each of the 3 numbers.  But as I brain storm
this right now, I see that this wouldn't do it either because you have
combinations so really, you end up with 255 taken to the 3rd power!
that's a huge number! So back to more brain storming<smile>.

On 1/30/12, Paul Hunt<paul-leics virginmedia com>  <mailto:paul-leics virginmedia com>  wrote:

That would be an interesting little programming exercise.

I suppose one could examine each component of the triplet and have a set
of rules that said, okay, if there's that much red and that much green
and that much blue then it's that colour...

Better if Libre Office gave us something more human readable than RG
values though!


On 30/01/12 21:08, Christopher Chaltain wrote:

Great, got it! Thanks! It appears that I'm getting an RGB triplet with
the values ranging from 0 to 255. This seems doable at the moment, but
do you know if anyone has any ideas on how Orca can figure out human
readable colors from this information? Seems like kind of a nasty issue
to solve.


On 30/01/12 14:28, Paul Hunt wrote:

By default, Orca does not include colour information in the list of
attributes that you get with insert + F.

You can add colour info to the list using the text attributes tab of the
Orca preferences dialogue.

Unfortunately though, currently you get a numeric value rather than a
colour name when you do this. I think it's a hexadecimal representation
of the colour.



On 30/01/12 20:08, Christopher Chaltain wrote:

Is there a way to get the color information for a cell in Libre Office
Calc? It doesn't look like this information is part of the text
attributes I get with the Orca+f key. I also didn't see it when looking
around the key bindings or learn mode.

_______________________________________________
orca-list mailing list
orca-list gnome org<mailto:orca-list gnome org>
http://mail.gnome.org/mailman/listinfo/orca-list
Visit http://live.gnome.org/Orca for more information on Orca.
The manual is at
http://library.gnome.org/users/gnome-access-guide/nightly/ats-2.html
The FAQ is at http://live.gnome.org/Orca/FrequentlyAskedQuestions
Log bugs and feature requests at http://bugzilla.gnome.org
Find out how to help at http://live.gnome.org/Orca/HowCanIHelp

_______________________________________________
orca-list mailing list
orca-list gnome org<mailto:orca-list gnome org>
http://mail.gnome.org/mailman/listinfo/orca-list
Visit http://live.gnome.org/Orca for more information on Orca.
The manual is at
http://library.gnome.org/users/gnome-access-guide/nightly/ats-2.html
The FAQ is at http://live.gnome.org/Orca/FrequentlyAskedQuestions
Log bugs and feature requests at http://bugzilla.gnome.org
Find out how to help at http://live.gnome.org/Orca/HowCanIHelp


_______________________________________________
orca-list mailing list
orca-list gnome org<mailto:orca-list gnome org>
http://mail.gnome.org/mailman/listinfo/orca-list
Visit http://live.gnome.org/Orca for more information on Orca.
The manual is at http://library.gnome.org/users/gnome-access-guide/nightly/ats-2.html
The FAQ is at http://live.gnome.org/Orca/FrequentlyAskedQuestions
Log bugs and feature requests at http://bugzilla.gnome.org
Find out how to help at http://live.gnome.org/Orca/HowCanIHelp

--
Oracle<http://www.oracle.com>
Peter Korn | Accessibility Principal
Phone: +1 650 5069522<tel:+1%20650%205069522>
500 Oracle Parkway | Redwood City, CA 94065
Green Oracle<http://www.oracle.com/commitment>  Oracle is committed to
developing practices and products that help protect the environment



_______________________________________________
orca-list mailing list
orca-list gnome org
http://mail.gnome.org/mailman/listinfo/orca-list
Visit http://live.gnome.org/Orca for more information on Orca.
The manual is at http://library.gnome.org/users/gnome-access-guide/nightly/ats-2.html
The FAQ is at http://live.gnome.org/Orca/FrequentlyAskedQuestions
Log bugs and feature requests at http://bugzilla.gnome.org
Find out how to help at http://live.gnome.org/Orca/HowCanIHelp
+1, besides there are other major issues with calc which need to be sorted out. 
For example we need to orca announce cell selection when working on a range.
Happy hacking.
Krishnakant.
[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]