After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 552350 - Orca doesn't recognize it is in a spreadsheet cell in certain builds of OOo Dev 3
Orca doesn't recognize it is in a spreadsheet cell in certain builds of OOo D...
Status: RESOLVED FIXED
Product: orca
Classification: Applications
Component: general
2.23.x
Other All
: Normal normal
: 2.24.0
Assigned To: Joanmarie Diggs (IRC: joanie)
Orca Maintainers
Depends on:
Blocks: 404411
 
 
Reported: 2008-09-15 13:42 UTC by Joanmarie Diggs (IRC: joanie)
Modified: 2008-09-15 23:02 UTC
See Also:
GNOME target: ---
GNOME version: 2.23/2.24


Attachments
revision 1 (2.15 KB, patch)
2008-09-15 13:47 UTC, Joanmarie Diggs (IRC: joanie)
committed Details | Review

Description Joanmarie Diggs (IRC: joanie) 2008-09-15 13:42:29 UTC
Steps to reproduce:

1. Launch any version of OOo Dev 3 where the frame name ends with "Beta" rather than "Calc".

2. Arrow around.

Expected results: We'd recognize that we were in a spreadsheet cell and behave accordingly.

Actual results: We don't recognize that we're in a spreadsheet cell because isSpreadSheetCell() does a string comparison on the frame name. As a result, we treat the spreadsheet as a Writer table.
Comment 1 Joanmarie Diggs (IRC: joanie) 2008-09-15 13:47:47 UTC
Created attachment 118752 [details] [review]
revision 1

isSpreadSheetCell() is brittle because of the string comparison and also the reliance upon a specific hierarchy being present.

In my experience Calc spreadsheets have always had 65536 rows in them. My guess is that this is borrowed from the Excel tradition of doing the same.  Given a table with exactly 65536 rows in it, my money is on it being a spreadsheet. :-) This patch checks for that condition.

I've pylinted it and functionally tested it.  The OOo Calc regression tests are in serious need of some updating so they're not the most reliable way to spot regressions atm. :-(

Will please review. Thanks!
Comment 2 Willie Walker 2008-09-15 14:07:41 UTC
Yes!  Anything to get rid of string compares where the strings are localized strings coming to us from the application.  I like this fix.  Commit!
Comment 3 Joanmarie Diggs (IRC: joanie) 2008-09-15 23:02:29 UTC
Yikes I didn't get a bugzilla notification on this. With one hour until code freeze.... Committed! Phew! :-) Thanks Will. Closing as FIXED.