sc/source/ui/Accessibility/AccessibleSpreadsheet.cxx

   1 /*************************************************************************
   2  *
   3  * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
   4  *
   5  * Copyright 2008 by Sun Microsystems, Inc.
   6  *
   7  * OpenOffice.org - a multi-platform office productivity suite
   8  *
   9  * $RCSfile: AccessibleSpreadsheet.cxx,v $
  10  * $Revision: 1.51 $
  11  *
  12  * This file is part of OpenOffice.org.
  13  *
  14  * OpenOffice.org is free software: you can redistribute it and/or modify
  15  * it under the terms of the GNU Lesser General Public License version 3
  16  * only, as published by the Free Software Foundation.
  17  *
  18  * OpenOffice.org is distributed in the hope that it will be useful,
  19  * but WITHOUT ANY WARRANTY; without even the implied warranty of
  20  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  21  * GNU Lesser General Public License version 3 for more details
  22  * (a copy is included in the LICENSE file that accompanied this code).
  23  *
  24  * You should have received a copy of the GNU Lesser General Public License
  25  * version 3 along with OpenOffice.org.  If not, see
  26  * <http://www.openoffice.org/license.html>
  27  * for a copy of the LGPLv3 License.
  28  *
  29  ************************************************************************/
  30
  31 // MARKER(update_precomp.py): autogen include statement, do not remove
  32 #include "precompiled_sc.hxx"
  33
  34
  35 #include "AccessibleSpreadsheet.hxx"
  36 #include "AccessibilityHints.hxx"
  37 #include "AccessibleCell.hxx"
  38 #include "AccessibleDocument.hxx"
  39 #include "tabvwsh.hxx"
  40 #include "document.hxx"
  41 #include "unoguard.hxx"
  42 #include "hints.hxx"
  43 #include "scmod.hxx"
  44
  45 #ifndef _UTL_ACCESSIBLESTATESETHELPER_HXX
  46 #include <unotools/accessiblestatesethelper.hxx>
  47 #endif
  48 #ifndef _COM_SUN_STAR_ACCESSIBILITY_XACCESSIBLEROLE_HPP_
  49 #include <com/sun/star/accessibility/AccessibleRole.hpp>
  50 #endif
  51 #ifndef _COM_SUN_STAR_ACCESSIBILITY_XACCESSIBLESTATETYPE_HPP_
  52 #include <com/sun/star/accessibility/AccessibleStateType.hpp>
  53 #endif
  54 #include <com/sun/star/accessibility/AccessibleEventId.hpp>
  55 #include <com/sun/star/accessibility/AccessibleTableModelChangeType.hpp>
  56 #include <rtl/uuid.h>
  57 #include <tools/debug.hxx>
  58 #include <tools/gen.hxx>
  59 #include <svtools/colorcfg.hxx>
  60
  61 #include <algorithm>
  62
  63 using namespace ::com::sun::star;
  64 using namespace ::com::sun::star::accessibility;
  65
  66 //=====  internal  ============================================================
  67
  68 ScAccessibleSpreadsheet::ScAccessibleSpreadsheet(
  69         ScAccessibleDocument* pAccDoc,
  70         ScTabViewShell* pViewShell,
  71         SCTAB nTab,
  72         ScSplitPos eSplitPos)
  73     :
  74     ScAccessibleTableBase (pAccDoc, GetDocument(pViewShell),
  75         ScRange(ScAddress(0, 0, nTab),ScAddress(MAXCOL, MAXROW, nTab))),
  76     mbIsSpreadsheet( sal_True )
  77 {
  78     ConstructScAccessibleSpreadsheet( pAccDoc, pViewShell, nTab, eSplitPos );
  79 }
  80
  81 ScAccessibleSpreadsheet::ScAccessibleSpreadsheet(
  82         ScAccessibleSpreadsheet& rParent, const ScRange& rRange ) :
  83     ScAccessibleTableBase( rParent.mpAccDoc, rParent.mpDoc, rRange),
  84     mbIsSpreadsheet( sal_False )
  85 {
  86     ConstructScAccessibleSpreadsheet( rParent.mpAccDoc, rParent.mpViewShell, rParent.mnTab, rParent.meSplitPos );
  87 }
  88
  89 ScAccessibleSpreadsheet::~ScAccessibleSpreadsheet()
  90 {
  91     if (mpMarkedRanges)
  92         delete mpMarkedRanges;
  93     if (mpSortedMarkedCells)
  94         delete mpSortedMarkedCells;
  95     if (mpViewShell)
  96         mpViewShell->RemoveAccessibilityObject(*this);
  97 }
  98
  99 void ScAccessibleSpreadsheet::ConstructScAccessibleSpreadsheet(
 100     ScAccessibleDocument* pAccDoc,
 101     ScTabViewShell* pViewShell,
 102     SCTAB nTab,
 103     ScSplitPos eSplitPos)
 104 {
 105     mpViewShell = pViewShell;
 106     mpMarkedRanges = 0;
 107     mpSortedMarkedCells = 0;
 108     mpAccDoc = pAccDoc;
 109     mpAccCell = 0;
 110     meSplitPos = eSplitPos;
 111     mnTab = nTab;
 112     mbHasSelection = sal_False;
 113     mbDelIns = sal_False;
 114     mbIsFocusSend = sal_False;
 115     maVisCells = GetVisCells(GetVisArea(mpViewShell, meSplitPos));
 116     if (mpViewShell)
 117     {
 118         mpViewShell->AddAccessibilityObject(*this);
 119
 120         const ScViewData& rViewData = *mpViewShell->GetViewData();
 121         const ScMarkData& rMarkData = rViewData.GetMarkData();
 122         maActiveCell = rViewData.GetCurPos();
 123         mbHasSelection = rMarkData.GetTableSelect(maActiveCell.Tab()) &&
 124                     (rMarkData.IsMarked() || rMarkData.IsMultiMarked());
 125         mpAccCell = GetAccessibleCellAt(maActiveCell.Row(), maActiveCell.Col());
 126         mpAccCell->acquire();
 127         mpAccCell->Init();
 128     }
 129 }
 130
 131 void SAL_CALL ScAccessibleSpreadsheet::disposing()
 132 {
 133     ScUnoGuard aGuard;
 134     if (mpViewShell)
 135     {
 136         mpViewShell->RemoveAccessibilityObject(*this);
 137         mpViewShell = NULL;
 138     }
 139     if (mpAccCell)
 140     {
 141         mpAccCell->release();
 142         mpAccCell = NULL;
 143     }
 144
 145     ScAccessibleTableBase::disposing();
 146 }
 147
 148 void ScAccessibleSpreadsheet::CompleteSelectionChanged(sal_Bool bNewState)
 149 {
 150     if (mpMarkedRanges)
 151         DELETEZ(mpMarkedRanges);
 152     if (mpSortedMarkedCells)
 153         DELETEZ(mpSortedMarkedCells);
 154
 155     mbHasSelection = bNewState;
 156
 157     AccessibleEventObject aEvent;
 158     aEvent.EventId = AccessibleEventId::STATE_CHANGED;
 159     if (bNewState)
 160         aEvent.NewValue = uno::makeAny(AccessibleStateType::SELECTED);
 161     else
 162         aEvent.OldValue = uno::makeAny(AccessibleStateType::SELECTED);
 163     aEvent.Source = uno::Reference< XAccessibleContext >(this);
 164
 165     CommitChange(aEvent);
 166 }
 167
 168 void ScAccessibleSpreadsheet::LostFocus()
 169 {
 170     AccessibleEventObject aEvent;
 171     aEvent.EventId = AccessibleEventId::ACTIVE_DESCENDANT_CHANGED;
 172     aEvent.Source = uno::Reference< XAccessibleContext >(this);
 173     uno::Reference< XAccessible > xOld = mpAccCell;
 174     aEvent.OldValue <<= xOld;
 175
 176     CommitChange(aEvent);
 177
 178     CommitFocusLost();
 179 }
 180
 181 void ScAccessibleSpreadsheet::GotFocus()
 182 {
 183     CommitFocusGained();
 184
 185     AccessibleEventObject aEvent;
 186     aEvent.EventId = AccessibleEventId::ACTIVE_DESCENDANT_CHANGED;
 187     aEvent.Source = uno::Reference< XAccessibleContext >(this);
 188     uno::Reference< XAccessible > xNew = mpAccCell;
 189     aEvent.NewValue <<= xNew;
 190
 191     CommitChange(aEvent);
 192 }
 193
 194 void ScAccessibleSpreadsheet::BoundingBoxChanged()
 195 {
 196     AccessibleEventObject aEvent;
 197     aEvent.EventId = AccessibleEventId::BOUNDRECT_CHANGED;
 198     aEvent.Source = uno::Reference< XAccessibleContext >(this);
 199
 200     CommitChange(aEvent);
 201 }
 202
 203 void ScAccessibleSpreadsheet::VisAreaChanged()
 204 {
 205     AccessibleEventObject aEvent;
 206     aEvent.EventId = AccessibleEventId::VISIBLE_DATA_CHANGED;
 207     aEvent.Source = uno::Reference< XAccessibleContext >(this);
 208
 209     CommitChange(aEvent);
 210 }
 211
 212     //=====  SfxListener  =====================================================
 213
 214 void ScAccessibleSpreadsheet::Notify( SfxBroadcaster& rBC, const SfxHint& rHint )
 215 {
 216     if (rHint.ISA( SfxSimpleHint ) )
 217     {
 218         const SfxSimpleHint& rRef = (const SfxSimpleHint&)rHint;
 219         // only notify if child exist, otherwise it is not necessary
 220         if ((rRef.GetId() == SC_HINT_ACC_CURSORCHANGED))
 221         {
 222             if (mpViewShell)
 223             {
 224                 ScAddress aNewCell = mpViewShell->GetViewData()->GetCurPos();
 225                 sal_Bool bNewMarked(mpViewShell->GetViewData()->GetMarkData().GetTableSelect(aNewCell.Tab()) &&
 226                     (mpViewShell->GetViewData()->GetMarkData().IsMarked() ||
 227                     mpViewShell->GetViewData()->GetMarkData().IsMultiMarked()));
 228                 sal_Bool bNewCellSelected(isAccessibleSelected(aNewCell.Row(), aNewCell.Col()));
 229                 if ((bNewMarked != mbHasSelection) ||
 230                     (!bNewCellSelected && bNewMarked) ||
 231                     (bNewCellSelected && mbHasSelection))
 232                 {
 233                     if (mpMarkedRanges)
 234                         DELETEZ(mpMarkedRanges);
 235                     if (mpSortedMarkedCells)
 236                         DELETEZ(mpSortedMarkedCells);
 237                     AccessibleEventObject aEvent;
 238                     aEvent.EventId = AccessibleEventId::SELECTION_CHANGED;
 239                     aEvent.Source = uno::Reference< XAccessibleContext >(this);
 240
 241                     mbHasSelection = bNewMarked;
 242
 243                     CommitChange(aEvent);
 244                 }
 245
 246                 // active descendant changed event (new cell selected)
 247                 bool bFireActiveDescChanged = (aNewCell != maActiveCell) &&
 248                     (aNewCell.Tab() == maActiveCell.Tab()) && IsFocused();
 249
 250                 /*  Remember old active cell and set new active cell.
 251                     #i82409# always update the class members mpAccCell and
 252                     maActiveCell, even if the sheet is not focused, e.g. when
 253                     using the name box in the toolbar. */
 254                 uno::Reference< XAccessible > xOld = mpAccCell;
 255                 mpAccCell->release();
 256                 mpAccCell = GetAccessibleCellAt(aNewCell.Row(), aNewCell.Col());
 257                 mpAccCell->acquire();
 258                 mpAccCell->Init();
 259                 uno::Reference< XAccessible > xNew = mpAccCell;
 260                 maActiveCell = aNewCell;
 261
 262                 // #i14108# fire event only if sheet is focused
 263                 if( bFireActiveDescChanged )
 264                 {
 265                     AccessibleEventObject aEvent;
 266                     aEvent.EventId = AccessibleEventId::ACTIVE_DESCENDANT_CHANGED;
 267                     aEvent.Source = uno::Reference< XAccessibleContext >(this);
 268                     aEvent.OldValue <<= xOld;
 269                     aEvent.NewValue <<= xNew;
 270                     CommitChange(aEvent);
 271                 }
 272             }
 273         }
 274         else if ((rRef.GetId() == SC_HINT_DATACHANGED))
 275         {
 276             if (!mbDelIns)
 277                 CommitTableModelChange(maRange.aStart.Row(), maRange.aStart.Col(), maRange.aEnd.Row(), maRange.aEnd.Col(), AccessibleTableModelChangeType::UPDATE);
 278             else
 279                 mbDelIns = sal_False;
 280         }
 281         // no longer needed, because the document calls the VisAreaChanged method
 282 /*              else if (rRef.GetId() == SC_HINT_ACC_VISAREACHANGED)
 283         {
 284             AccessibleEventObject aEvent;
 285             aEvent.EventId = AccessibleEventId::VISIBLE_DATA_CHANGED;
 286             aEvent.Source = uno::Reference< XAccessibleContext >(this);
 287
 288             CommitChange(aEvent);*/
 289         // commented out, because to use a ModelChangeEvent is not the right way
 290         // at the moment there is no way, but the Java/Gnome Api should be extended sometime
 291 /*                      if (mpViewShell)
 292             {
 293                 Rectangle aNewVisCells(GetVisCells(GetVisArea(mpViewShell, meSplitPos)));
 294
 295                 Rectangle aNewPos(aNewVisCells);
 296
 297                 if (aNewVisCells.IsOver(maVisCells))
 298                     aNewPos.Union(maVisCells);
 299                 else
 300                     CommitTableModelChange(maVisCells.Top(), maVisCells.Left(), maVisCells.Bottom(), maVisCells.Right(), AccessibleTableModelChangeType::UPDATE);
 301
 302                 maVisCells = aNewVisCells;
 303
 304                 CommitTableModelChange(aNewPos.Top(), aNewPos.Left(), aNewPos.Bottom(), aNewPos.Right(), AccessibleTableModelChangeType::UPDATE);
 305             }
 306         }*/
 307         // no longer needed, because the document calls the BoundingBoxChanged method
 308 /*        else if (rRef.GetId() == SC_HINT_ACC_WINDOWRESIZED)
 309         {
 310             AccessibleEventObject aEvent;
 311             aEvent.EventId = AccessibleEventId::BOUNDRECT_CHANGED;
 312             aEvent.Source = uno::Reference< XAccessibleContext >(this);
 313
 314             CommitChange(aEvent);
 315         }*/
 316     }
 317     else if (rHint.ISA( ScUpdateRefHint ))
 318     {
 319         const ScUpdateRefHint& rRef = (const ScUpdateRefHint&)rHint;
 320         if (rRef.GetMode() == URM_INSDEL && rRef.GetDz() == 0) //#107250# test whether table is inserted or deleted
 321         {
 322             if (((rRef.GetRange().aStart.Col() == maRange.aStart.Col()) &&
 323                 (rRef.GetRange().aEnd.Col() == maRange.aEnd.Col())) ||
 324                 ((rRef.GetRange().aStart.Row() == maRange.aStart.Row()) &&
 325                 (rRef.GetRange().aEnd.Row() == maRange.aEnd.Row())))
 326             {
 327                 // ignore next SC_HINT_DATACHANGED notification
 328                 mbDelIns = sal_True;
 329
 330                 sal_Int16 nId(0);
 331                 SCsCOL nX(rRef.GetDx());
 332                 SCsROW nY(rRef.GetDy());
 333                 ScRange aRange(rRef.GetRange());
 334                 if ((nX < 0) || (nY < 0))
 335                 {
 336                     DBG_ASSERT(!((nX < 0) && (nY < 0)), "should not be possible to remove row and column at the same time");
 337                     nId = AccessibleTableModelChangeType::DELETE;
 338                     if (nX < 0)
 339                     {
 340                         nX = -nX;
 341                         nY = aRange.aEnd.Row() - aRange.aStart.Row();
 342                     }
 343                     else
 344                     {
 345                         nY = -nY;
 346                         nX = aRange.aEnd.Col() - aRange.aStart.Col();
 347                     }
 348                 }
 349                 else if ((nX > 0) || (nY > 0))
 350                 {
 351                     DBG_ASSERT(!((nX > 0) && (nY > 0)), "should not be possible to add row and column at the same time");
 352                     nId = AccessibleTableModelChangeType::INSERT;
 353                     if (nX < 0)
 354                         nY = aRange.aEnd.Row() - aRange.aStart.Row();
 355                     else
 356                         nX = aRange.aEnd.Col() - aRange.aStart.Col();
 357                 }
 358                 else
 359                 {
 360                     DBG_ERROR("is it a deletion or a insertion?");
 361                 }
 362
 363                 CommitTableModelChange(rRef.GetRange().aStart.Row(),
 364                     rRef.GetRange().aStart.Col(),
 365                     rRef.GetRange().aStart.Row() + nY,
 366                     rRef.GetRange().aStart.Col() + nX, nId);
 367
 368                 AccessibleEventObject aEvent;
 369                 aEvent.EventId = AccessibleEventId::ACTIVE_DESCENDANT_CHANGED;
 370                 aEvent.Source = uno::Reference< XAccessibleContext >(this);
 371                 uno::Reference< XAccessible > xNew = mpAccCell;
 372                 aEvent.NewValue <<= xNew;
 373
 374                 CommitChange(aEvent);
 375             }
 376         }
 377     }
 378
 379     ScAccessibleTableBase::Notify(rBC, rHint);
 380 }
 381
 382     //=====  XAccessibleTable  ================================================
 383
 384 uno::Reference< XAccessibleTable > SAL_CALL ScAccessibleSpreadsheet::getAccessibleRowHeaders(  )
 385                     throw (uno::RuntimeException)
 386 {
 387     ScUnoGuard aGuard;
 388     IsObjectValid();
 389     uno::Reference< XAccessibleTable > xAccessibleTable;
 390     if( mpDoc && mbIsSpreadsheet )
 391     {
 392         if( const ScRange* pRowRange = mpDoc->GetRepeatRowRange( mnTab ) )
 393         {
 394             SCROW nStart = pRowRange->aStart.Row();
 395             SCROW nEnd = pRowRange->aEnd.Row();
 396             if( (0 <= nStart) && (nStart <= nEnd) && (nEnd <= MAXROW) )
 397                 xAccessibleTable.set( new ScAccessibleSpreadsheet( *this, ScRange( 0, nStart, mnTab, MAXCOL, nEnd, mnTab ) ) );
 398         }
 399     }
 400     return xAccessibleTable;
 401 }
 402
 403 uno::Reference< XAccessibleTable > SAL_CALL ScAccessibleSpreadsheet::getAccessibleColumnHeaders(  )
 404                     throw (uno::RuntimeException)
 405 {
 406     ScUnoGuard aGuard;
 407     IsObjectValid();
 408     uno::Reference< XAccessibleTable > xAccessibleTable;
 409     if( mpDoc && mbIsSpreadsheet )
 410     {
 411         if( const ScRange* pColRange = mpDoc->GetRepeatColRange( mnTab ) )
 412         {
 413             SCCOL nStart = pColRange->aStart.Col();
 414             SCCOL nEnd = pColRange->aEnd.Col();
 415             if( (0 <= nStart) && (nStart <= nEnd) && (nEnd <= MAXCOL) )
 416                 xAccessibleTable.set( new ScAccessibleSpreadsheet( *this, ScRange( nStart, 0, mnTab, nEnd, MAXROW, mnTab ) ) );
 417         }
 418     }
 419     return xAccessibleTable;
 420 }
 421
 422 uno::Sequence< sal_Int32 > SAL_CALL ScAccessibleSpreadsheet::getSelectedAccessibleRows(  )
 423                     throw (uno::RuntimeException)
 424 {
 425     ScUnoGuard aGuard;
 426     IsObjectValid();
 427     uno::Sequence<sal_Int32> aSequence;
 428     if (mpViewShell && mpViewShell->GetViewData())
 429     {
 430         aSequence.realloc(maRange.aEnd.Row() - maRange.aStart.Row() + 1);
 431         const ScMarkData& rMarkdata = mpViewShell->GetViewData()->GetMarkData();
 432         sal_Int32* pSequence = aSequence.getArray();
 433         sal_Int32 nCount(0);
 434         for (SCROW i = maRange.aStart.Row(); i <= maRange.aEnd.Row(); ++i)
 435         {
 436             if (rMarkdata.IsRowMarked(i))
 437             {
 438                 pSequence[nCount] = i;
 439                 ++nCount;
 440             }
 441         }
 442         aSequence.realloc(nCount);
 443     }
 444     else
 445         aSequence.realloc(0);
 446     return aSequence;
 447 }
 448
 449 uno::Sequence< sal_Int32 > SAL_CALL ScAccessibleSpreadsheet::getSelectedAccessibleColumns(  )
 450                     throw (uno::RuntimeException)
 451 {
 452     ScUnoGuard aGuard;
 453     IsObjectValid();
 454     uno::Sequence<sal_Int32> aSequence;
 455     if (mpViewShell && mpViewShell->GetViewData())
 456     {
 457         aSequence.realloc(maRange.aEnd.Col() - maRange.aStart.Col() + 1);
 458         const ScMarkData& rMarkdata = mpViewShell->GetViewData()->GetMarkData();
 459         sal_Int32* pSequence = aSequence.getArray();
 460         sal_Int32 nCount(0);
 461         for (SCCOL i = maRange.aStart.Col(); i <= maRange.aEnd.Col(); ++i)
 462         {
 463             if (rMarkdata.IsColumnMarked(i))
 464             {
 465                 pSequence[nCount] = i;
 466                 ++nCount;
 467             }
 468         }
 469         aSequence.realloc(nCount);
 470     }
 471     else
 472         aSequence.realloc(0);
 473     return aSequence;
 474 }
 475
 476 sal_Bool SAL_CALL ScAccessibleSpreadsheet::isAccessibleRowSelected( sal_Int32 nRow )
 477     throw (uno::RuntimeException, lang::IndexOutOfBoundsException)
 478 {
 479     ScUnoGuard aGuard;
 480     IsObjectValid();
 481
 482     if ((nRow > (maRange.aEnd.Row() - maRange.aStart.Row())) || (nRow < 0))
 483         throw lang::IndexOutOfBoundsException();
 484
 485     sal_Bool bResult(sal_False);
 486     if (mpViewShell && mpViewShell->GetViewData())
 487     {
 488         const ScMarkData& rMarkdata = mpViewShell->GetViewData()->GetMarkData();
 489         bResult = rMarkdata.IsRowMarked((SCROW)nRow);
 490     }
 491     return bResult;
 492 }
 493
 494 sal_Bool SAL_CALL ScAccessibleSpreadsheet::isAccessibleColumnSelected( sal_Int32 nColumn )
 495     throw (uno::RuntimeException, lang::IndexOutOfBoundsException)
 496 {
 497     ScUnoGuard aGuard;
 498     IsObjectValid();
 499
 500     if ((nColumn > (maRange.aEnd.Col() - maRange.aStart.Col())) || (nColumn < 0))
 501         throw lang::IndexOutOfBoundsException();
 502
 503     sal_Bool bResult(sal_False);
 504     if (mpViewShell && mpViewShell->GetViewData())
 505     {
 506         const ScMarkData& rMarkdata = mpViewShell->GetViewData()->GetMarkData();
 507         bResult = rMarkdata.IsColumnMarked((SCCOL)nColumn);
 508     }
 509     return bResult;
 510 }
 511
 512 ScAccessibleCell* ScAccessibleSpreadsheet::GetAccessibleCellAt(sal_Int32 nRow, sal_Int32 nColumn)
 513 {
 514     ScAccessibleCell* pAccessibleCell = NULL;
 515     ScAddress aCellAddress(static_cast<SCCOL>(maRange.aStart.Col() + nColumn),
 516         static_cast<SCROW>(maRange.aStart.Row() + nRow), maRange.aStart.Tab());
 517     if ((aCellAddress == maActiveCell) && mpAccCell)
 518     {
 519         pAccessibleCell = mpAccCell;
 520     }
 521     else
 522         pAccessibleCell = new ScAccessibleCell(this, mpViewShell, aCellAddress, getAccessibleIndex(nRow, nColumn), meSplitPos, mpAccDoc);
 523
 524     return pAccessibleCell;
 525 }
 526
 527 uno::Reference< XAccessible > SAL_CALL ScAccessibleSpreadsheet::getAccessibleCellAt( sal_Int32 nRow, sal_Int32 nColumn )
 528                     throw (uno::RuntimeException, lang::IndexOutOfBoundsException)
 529 {
 530     ScUnoGuard aGuard;
 531     IsObjectValid();
 532     if (nRow > (maRange.aEnd.Row() - maRange.aStart.Row()) ||
 533         nRow < 0 ||
 534         nColumn > (maRange.aEnd.Col() - maRange.aStart.Col()) ||
 535         nColumn < 0)
 536         throw lang::IndexOutOfBoundsException();
 537
 538     uno::Reference<XAccessible> xAccessible;
 539     ScAccessibleCell* pAccessibleCell = GetAccessibleCellAt(nRow, nColumn);
 540     xAccessible = pAccessibleCell;
 541     pAccessibleCell->Init();
 542     return xAccessible;
 543 }
 544
 545 sal_Bool SAL_CALL ScAccessibleSpreadsheet::isAccessibleSelected( sal_Int32 nRow, sal_Int32 nColumn )
 546     throw (uno::RuntimeException, lang::IndexOutOfBoundsException)
 547 {
 548     ScUnoGuard aGuard;
 549     IsObjectValid();
 550
 551     if ((nColumn > (maRange.aEnd.Col() - maRange.aStart.Col())) || (nColumn < 0) ||
 552         (nRow > (maRange.aEnd.Row() - maRange.aStart.Row())) || (nRow < 0))
 553         throw lang::IndexOutOfBoundsException();
 554
 555     sal_Bool bResult(sal_False);
 556     if (mpViewShell)
 557     {
 558         const ScMarkData& rMarkdata = mpViewShell->GetViewData()->GetMarkData();
 559         bResult = rMarkdata.IsCellMarked(static_cast<SCCOL>(nColumn), static_cast<SCROW>(nRow));
 560     }
 561     return bResult;
 562 }
 563
 564     //=====  XAccessibleComponent  ============================================
 565
 566 uno::Reference< XAccessible > SAL_CALL ScAccessibleSpreadsheet::getAccessibleAtPoint(
 567     const awt::Point& rPoint )
 568         throw (uno::RuntimeException)
 569 {
 570     uno::Reference< XAccessible > xAccessible;
 571     if (containsPoint(rPoint))
 572     {
 573         ScUnoGuard aGuard;
 574         IsObjectValid();
 575         if (mpViewShell)
 576         {
 577             SCsCOL nX;
 578             SCsROW nY;
 579             mpViewShell->GetViewData()->GetPosFromPixel( rPoint.X, rPoint.Y, meSplitPos, nX, nY);
 580             xAccessible = getAccessibleCellAt(nY, nX);
 581         }
 582     }
 583     return xAccessible;
 584 }
 585
 586 void SAL_CALL ScAccessibleSpreadsheet::grabFocus(  )
 587         throw (uno::RuntimeException)
 588 {
 589     if (getAccessibleParent().is())
 590     {
 591         uno::Reference<XAccessibleComponent> xAccessibleComponent(getAccessibleParent()->getAccessibleContext(), uno::UNO_QUERY);
 592         if (xAccessibleComponent.is())
 593             xAccessibleComponent->grabFocus();
 594     }
 595 }
 596
 597 sal_Int32 SAL_CALL ScAccessibleSpreadsheet::getForeground(  )
 598         throw (uno::RuntimeException)
 599 {
 600     return COL_BLACK;
 601 }
 602
 603 sal_Int32 SAL_CALL ScAccessibleSpreadsheet::getBackground(  )
 604         throw (uno::RuntimeException)
 605 {
 606     ScUnoGuard aGuard;
 607     IsObjectValid();
 608     return SC_MOD()->GetColorConfig().GetColorValue( ::svtools::DOCCOLOR ).nColor;
 609 }
 610
 611     //=====  XAccessibleContext  ==============================================
 612
 613 uno::Reference<XAccessibleRelationSet> SAL_CALL ScAccessibleSpreadsheet::getAccessibleRelationSet(void)
 614         throw (::com::sun::star::uno::RuntimeException)
 615 {
 616     utl::AccessibleRelationSetHelper* pRelationSet = NULL;
 617     if(mpAccDoc)
 618         pRelationSet = mpAccDoc->GetRelationSet(NULL);
 619     if (!pRelationSet)
 620         pRelationSet = new utl::AccessibleRelationSetHelper();
 621     return pRelationSet;
 622 }
 623
 624 uno::Reference<XAccessibleStateSet> SAL_CALL
 625     ScAccessibleSpreadsheet::getAccessibleStateSet(void)
 626     throw (uno::RuntimeException)
 627 {
 628     ScUnoGuard aGuard;
 629     uno::Reference<XAccessibleStateSet> xParentStates;
 630     if (getAccessibleParent().is())
 631     {
 632         uno::Reference<XAccessibleContext> xParentContext = getAccessibleParent()->getAccessibleContext();
 633         xParentStates = xParentContext->getAccessibleStateSet();
 634     }
 635     utl::AccessibleStateSetHelper* pStateSet = new utl::AccessibleStateSetHelper();
 636     if (IsDefunc(xParentStates))
 637         pStateSet->AddState(AccessibleStateType::DEFUNC);
 638     else
 639     {
 640         pStateSet->AddState(AccessibleStateType::MANAGES_DESCENDANTS);
 641         if (IsEditable(xParentStates))
 642             pStateSet->AddState(AccessibleStateType::EDITABLE);
 643         pStateSet->AddState(AccessibleStateType::ENABLED);
 644         pStateSet->AddState(AccessibleStateType::FOCUSABLE);
 645         if (IsFocused())
 646             pStateSet->AddState(AccessibleStateType::FOCUSED);
 647         pStateSet->AddState(AccessibleStateType::MULTI_SELECTABLE);
 648         pStateSet->AddState(AccessibleStateType::OPAQUE);
 649         pStateSet->AddState(AccessibleStateType::SELECTABLE);
 650         if (IsCompleteSheetSelected())
 651             pStateSet->AddState(AccessibleStateType::SELECTED);
 652         if (isShowing())
 653             pStateSet->AddState(AccessibleStateType::SHOWING);
 654         if (isVisible())
 655             pStateSet->AddState(AccessibleStateType::VISIBLE);
 656     }
 657     return pStateSet;
 658 }
 659
 660     ///=====  XAccessibleSelection  ===========================================
 661
 662 void SAL_CALL
 663         ScAccessibleSpreadsheet::selectAccessibleChild( sal_Int32 nChildIndex )
 664         throw (lang::IndexOutOfBoundsException, uno::RuntimeException)
 665 {
 666     ScUnoGuard aGuard;
 667     IsObjectValid();
 668     if (nChildIndex < 0 || nChildIndex >= getAccessibleChildCount())
 669         throw lang::IndexOutOfBoundsException();
 670
 671     if (mpViewShell)
 672     {
 673         sal_Int32 nCol(getAccessibleColumn(nChildIndex));
 674         sal_Int32 nRow(getAccessibleRow(nChildIndex));
 675
 676         SelectCell(nRow, nCol, sal_False);
 677     }
 678 }
 679
 680 void SAL_CALL
 681         ScAccessibleSpreadsheet::clearAccessibleSelection(  )
 682         throw (uno::RuntimeException)
 683 {
 684     ScUnoGuard aGuard;
 685     IsObjectValid();
 686     if (mpViewShell)
 687     {
 688         mpViewShell->Unmark();
 689     }
 690 }
 691
 692 void SAL_CALL
 693         ScAccessibleSpreadsheet::selectAllAccessibleChildren(  )
 694         throw (uno::RuntimeException)
 695 {
 696     ScUnoGuard aGuard;
 697     IsObjectValid();
 698     if (mpViewShell)
 699     {
 700         mpViewShell->SelectAll();
 701     }
 702 }
 703
 704 sal_Int32 SAL_CALL
 705         ScAccessibleSpreadsheet::getSelectedAccessibleChildCount(  )
 706         throw (uno::RuntimeException)
 707 {
 708     ScUnoGuard aGuard;
 709     IsObjectValid();
 710     sal_Int32 nResult(0);
 711     if (mpViewShell)
 712     {
 713         if (!mpMarkedRanges)
 714         {
 715             mpMarkedRanges = new ScRangeList();
 716             ScMarkData aMarkData(mpViewShell->GetViewData()->GetMarkData());
 717             aMarkData.MarkToMulti();
 718             aMarkData.FillRangeListWithMarks(mpMarkedRanges, sal_False);
 719         }
 720         // is possible, because there shouldn't be overlapped ranges in it
 721         if (mpMarkedRanges)
 722             nResult = mpMarkedRanges->GetCellCount();
 723     }
 724     return nResult;
 725 }
 726
 727 uno::Reference<XAccessible > SAL_CALL
 728         ScAccessibleSpreadsheet::getSelectedAccessibleChild( sal_Int32 nSelectedChildIndex )
 729         throw (lang::IndexOutOfBoundsException, uno::RuntimeException)
 730 {
 731     ScUnoGuard aGuard;
 732     IsObjectValid();
 733     uno::Reference < XAccessible > xAccessible;
 734     if (mpViewShell)
 735     {
 736         if (!mpMarkedRanges)
 737         {
 738             mpMarkedRanges = new ScRangeList();
 739             mpViewShell->GetViewData()->GetMarkData().FillRangeListWithMarks(mpMarkedRanges, sal_False);
 740         }
 741         if (mpMarkedRanges)
 742         {
 743             if (!mpSortedMarkedCells)
 744                 CreateSortedMarkedCells();
 745             if (mpSortedMarkedCells)
 746             {
 747                 if ((nSelectedChildIndex < 0) ||
 748                     (mpSortedMarkedCells->size() <= static_cast<sal_uInt32>(nSelectedChildIndex)))
 749                     throw lang::IndexOutOfBoundsException();
 750                 else
 751                     xAccessible = getAccessibleCellAt((*mpSortedMarkedCells)[nSelectedChildIndex].Row(), (*mpSortedMarkedCells)[nSelectedChildIndex].Col());
 752             }
 753         }
 754     }
 755     return xAccessible;
 756 }
 757
 758 void SAL_CALL
 759         ScAccessibleSpreadsheet::deselectAccessibleChild( sal_Int32 nChildIndex )
 760         throw (lang::IndexOutOfBoundsException, uno::RuntimeException)
 761 {
 762     ScUnoGuard aGuard;
 763     IsObjectValid();
 764
 765     if (nChildIndex < 0 || nChildIndex >= getAccessibleChildCount())
 766         throw lang::IndexOutOfBoundsException();
 767
 768     if (mpViewShell)
 769     {
 770         sal_Int32 nCol(getAccessibleColumn(nChildIndex));
 771         sal_Int32 nRow(getAccessibleRow(nChildIndex));
 772
 773         if (mpViewShell->GetViewData()->GetMarkData().IsCellMarked(static_cast<SCCOL>(nCol), static_cast<SCROW>(nRow)))
 774             SelectCell(nRow, nCol, sal_True);
 775     }
 776 }
 777
 778 void ScAccessibleSpreadsheet::SelectCell(sal_Int32 nRow, sal_Int32 nCol, sal_Bool bDeselect)
 779 {
 780     mpViewShell->SetTabNo( maRange.aStart.Tab() );
 781
 782     mpViewShell->DoneBlockMode( sal_True ); // continue selecting
 783     mpViewShell->InitBlockMode( static_cast<SCCOL>(nCol), static_cast<SCROW>(nRow), maRange.aStart.Tab(), bDeselect, sal_False, sal_False );
 784
 785     mpViewShell->SelectionChanged();
 786 }
 787
 788 void ScAccessibleSpreadsheet::CreateSortedMarkedCells()
 789 {
 790     mpSortedMarkedCells = new std::vector<ScMyAddress>();
 791     mpSortedMarkedCells->reserve(mpMarkedRanges->GetCellCount());
 792     ScRange* pRange = mpMarkedRanges->First();
 793     while (pRange)
 794     {
 795         if (pRange->aStart.Tab() != pRange->aEnd.Tab())
 796         {
 797             if ((maActiveCell.Tab() >= pRange->aStart.Tab()) ||
 798                 maActiveCell.Tab() <= pRange->aEnd.Tab())
 799             {
 800                 ScRange aRange(*pRange);
 801                 aRange.aStart.SetTab(maActiveCell.Tab());
 802                 aRange.aEnd.SetTab(maActiveCell.Tab());
 803                 AddMarkedRange(aRange);
 804             }
 805             else
 806             {
 807                 DBG_ERROR("Range of wrong table");
 808             }
 809         }
 810         else if(pRange->aStart.Tab() == maActiveCell.Tab())
 811             AddMarkedRange(*pRange);
 812         else
 813         {
 814             DBG_ERROR("Range of wrong table");
 815         }
 816         pRange = mpMarkedRanges->Next();
 817     }
 818     std::sort(mpSortedMarkedCells->begin(), mpSortedMarkedCells->end());
 819 }
 820
 821 void ScAccessibleSpreadsheet::AddMarkedRange(const ScRange& rRange)
 822 {
 823     for (SCROW nRow = rRange.aStart.Row(); nRow <= rRange.aEnd.Row(); ++nRow)
 824     {
 825         for (SCCOL nCol = rRange.aStart.Col(); nCol <= rRange.aEnd.Col(); ++nCol)
 826         {
 827             ScMyAddress aCell(nCol, nRow, maActiveCell.Tab());
 828             mpSortedMarkedCells->push_back(aCell);
 829         }
 830     }
 831 }
 832
 833     //=====  XServiceInfo  ====================================================
 834
 835 ::rtl::OUString SAL_CALL ScAccessibleSpreadsheet::getImplementationName(void)
 836         throw (uno::RuntimeException)
 837 {
 838     return rtl::OUString(RTL_CONSTASCII_USTRINGPARAM ("ScAccessibleSpreadsheet"));
 839 }
 840
 841 uno::Sequence< ::rtl::OUString> SAL_CALL
 842     ScAccessibleSpreadsheet::getSupportedServiceNames (void)
 843         throw (uno::RuntimeException)
 844 {
 845     uno::Sequence< ::rtl::OUString > aSequence = ScAccessibleTableBase::getSupportedServiceNames();
 846     sal_Int32 nOldSize(aSequence.getLength());
 847     aSequence.realloc(nOldSize + 1);
 848     ::rtl::OUString* pNames = aSequence.getArray();
 849
 850     pNames[nOldSize] = rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("com.sun.star.AccessibleSpreadsheet"));
 851
 852     return aSequence;
 853 }
 854
 855 //=====  XTypeProvider  =======================================================
 856
 857 uno::Sequence<sal_Int8> SAL_CALL
 858     ScAccessibleSpreadsheet::getImplementationId(void)
 859     throw (uno::RuntimeException)
 860 {
 861     ScUnoGuard aGuard;
 862     IsObjectValid();
 863     static uno::Sequence<sal_Int8> aId;
 864     if (aId.getLength() == 0)
 865     {
 866         aId.realloc (16);
 867         rtl_createUuid (reinterpret_cast<sal_uInt8 *>(aId.getArray()), 0, sal_True);
 868     }
 869     return aId;
 870 }
 871
 872 ///=====  XAccessibleEventBroadcaster  =====================================
 873
 874 void SAL_CALL ScAccessibleSpreadsheet::addEventListener(const uno::Reference<XAccessibleEventListener>& xListener)
 875         throw (uno::RuntimeException)
 876 {
 877     ScUnoGuard aGuard;
 878     IsObjectValid();
 879     ScAccessibleTableBase::addEventListener(xListener);
 880
 881     if (!mbIsFocusSend)
 882     {
 883         mbIsFocusSend = sal_True;
 884         CommitFocusGained();
 885
 886         AccessibleEventObject aEvent;
 887         aEvent.EventId = AccessibleEventId::ACTIVE_DESCENDANT_CHANGED;
 888         aEvent.Source = uno::Reference< XAccessibleContext >(this);
 889         aEvent.NewValue <<= getAccessibleCellAt(maActiveCell.Row(), maActiveCell.Col());
 890
 891         CommitChange(aEvent);
 892     }
 893 }
 894
 895     //====  internal  =========================================================
 896
 897 Rectangle ScAccessibleSpreadsheet::GetBoundingBoxOnScreen() const
 898     throw (uno::RuntimeException)
 899 {
 900     Rectangle aRect;
 901     if (mpViewShell)
 902     {
 903         Window* pWindow = mpViewShell->GetWindowByPos(meSplitPos);
 904         if (pWindow)
 905             aRect = pWindow->GetWindowExtentsRelative(NULL);
 906     }
 907     return aRect;
 908 }
 909
 910 Rectangle ScAccessibleSpreadsheet::GetBoundingBox() const
 911     throw (uno::RuntimeException)
 912 {
 913     Rectangle aRect;
 914     if (mpViewShell)
 915     {
 916         Window* pWindow = mpViewShell->GetWindowByPos(meSplitPos);
 917         if (pWindow)
 918             //#101986#; extends to the same window, because the parent is the document and it has the same window
 919             aRect = pWindow->GetWindowExtentsRelative(pWindow);
 920     }
 921     return aRect;
 922 }
 923
 924 sal_Bool ScAccessibleSpreadsheet::IsDefunc(
 925     const uno::Reference<XAccessibleStateSet>& rxParentStates)
 926 {
 927     return ScAccessibleContextBase::IsDefunc() || (mpViewShell == NULL) || !getAccessibleParent().is() ||
 928         (rxParentStates.is() && rxParentStates->contains(AccessibleStateType::DEFUNC));
 929 }
 930
 931 sal_Bool ScAccessibleSpreadsheet::IsEditable(
 932     const uno::Reference<XAccessibleStateSet>& /* rxParentStates */)
 933 {
 934     sal_Bool bProtected(sal_False);
 935     if (mpDoc && mpDoc->IsTabProtected(maRange.aStart.Tab()))
 936         bProtected = sal_True;
 937     return !bProtected;
 938 }
 939
 940 sal_Bool ScAccessibleSpreadsheet::IsFocused()
 941 {
 942     sal_Bool bFocused(sal_False);
 943     if (mpViewShell)
 944     {
 945         if (mpViewShell->GetViewData()->GetActivePart() == meSplitPos)
 946             bFocused = mpViewShell->GetActiveWin()->HasFocus();
 947     }
 948     return bFocused;
 949 }
 950
 951 sal_Bool ScAccessibleSpreadsheet::IsCompleteSheetSelected()
 952 {
 953     sal_Bool bResult(sal_False);
 954     if(mpViewShell)
 955     {
 956         //#103800#; use a copy of MarkData
 957         ScMarkData aMarkData(mpViewShell->GetViewData()->GetMarkData());
 958         aMarkData.MarkToMulti();
 959         if (aMarkData.IsAllMarked(maRange))
 960             bResult = sal_True;
 961     }
 962     return bResult;
 963 }
 964
 965 ScDocument* ScAccessibleSpreadsheet::GetDocument(ScTabViewShell* pViewShell)
 966 {
 967     ScDocument* pDoc = NULL;
 968     if (pViewShell)
 969         pDoc = pViewShell->GetViewData()->GetDocument();
 970     return pDoc;
 971 }
 972
 973 Rectangle ScAccessibleSpreadsheet::GetVisArea(ScTabViewShell* pViewShell, ScSplitPos eSplitPos)
 974 {
 975     Rectangle aVisArea;
 976     if (pViewShell)
 977     {
 978         Window* pWindow = pViewShell->GetWindowByPos(eSplitPos);
 979         if (pWindow)
 980         {
 981             aVisArea.SetPos(pViewShell->GetViewData()->GetPixPos(eSplitPos));
 982             aVisArea.SetSize(pWindow->GetSizePixel());
 983         }
 984     }
 985     return aVisArea;
 986 }
 987
 988 Rectangle ScAccessibleSpreadsheet::GetVisCells(const Rectangle& rVisArea)
 989 {
 990     if (mpViewShell)
 991     {
 992         SCsCOL nStartX, nEndX;
 993         SCsROW nStartY, nEndY;
 994
 995         mpViewShell->GetViewData()->GetPosFromPixel( 1, 1, meSplitPos, nStartX, nStartY);
 996         mpViewShell->GetViewData()->GetPosFromPixel( rVisArea.GetWidth(), rVisArea.GetHeight(), meSplitPos, nEndX, nEndY);
 997
 998         return Rectangle(nStartX, nStartY, nEndX, nEndY);
 999     }
1000     else
1001         return Rectangle();
1002 }