Link to issue number:

Closes #6959

Summary of the issue:

When multiple cells are selected, pressing commands that move the active cell (even in a selection) do not allow to report which cell is active in the selection. We should more clearly distinguish between the selection and the active cell in Excel.

This had already been done for Libre Office in #12849.

Description of user facing changes

When multiple cells are selected in an Excel sheet, pressing enter, tab combined or not with shift to move the active cell now reports the new active cell rather than the whole selection.

If needed, the whole selection can still be reported with NVDA+shift+upArrow.

Description of development approach

• Spit the original script in two separate script to handle selection and focus (active cell) reporting separately.
• For charts, the selection is reported in any case as before, there is no concept of active cell

Testing strategy:

In a worksheet test for single selected cell and multiple cells selected:

• pressing arrows
• pressing enter, tab combined or not with shift
• report focus: NVDA+tab
• report navigator object: NVDA+pavnum5
• report selection: NVDA+shift+upArrow

Also test these scripts in a chart.

Known issues with pull request:

None

Code Review Checklist:

• Documentation:
  • Change log entry
  • User Documentation
  • Developer / Technical Documentation
  • Context sensitive help for GUI changes
• Testing:
  • Unit tests
  • System (end to end) tests
  • Manual testing
• UX of all users considered:
  • Speech
  • Braille
  • Low Vision
  • Different web browsers
  • Localization in other languages / culture than English
• API is compatible with existing add-ons.
• Security precautions taken.

@coderabbitai summary