CyrilleB79
commented
7 hours ago You can still press F2 and then up/down arrows to count the number of lines in a cell.
Though, the most interesting would be some sort of notification when the row height is automatically increased due to text wrapping.
Is your feature request related to a problem? Please describe.
There are several (conceptually) related issues in Excel: 1) NVDA reports when text is overflowing or cropped, but there is no way to tell whether it is just the edge of a letter which doesn't fit, or three paragraphs worth of text. It would be helpful to be able to find this out.
2) When "Wrap text" is enabled (alt+h, w), text will not exceed the width of the cell but will flow onto new lines. While all the text will be visible, there is no easy way to tell how many lines this is taking up. In some cases wrapping text may result in a cell which is very narrow but ridiculously tall, taking up a lot of space but still not being readable - and again this isn't easy to find out.
Describe the solution you'd like
The best solution might depend on what is technically possible.
It is currently possible to find out the width of a column with alt+h, o, w. This is given in the default unit. For instance mine says the column I am looking at is 8.04. TBH, I have no idea what unit that is using or how wide it is, but if I can find out that is how wide the cell is and that my text is 11.3 wide, I would at least be able to work out that ok, I can wrap this text and it will fit on two rows. Or I can double the width of the column and it will fit.
Ideally it would be good to know how many lines of text are in a (wrapped) cell, but even if this could be given in points it could be helpful. I can see my row height is 14.4 (I really have no idea what unit this is using at that implies that my cells are nearly twice as high as they are wide, but I can assure you they are 3-4 times wider than they are high. Very odd. But even without knowing WHAT unit it is using, I can check the heigh of other rows to get an idea of how high one row is compared to others.
Describe alternatives you've considered
I'm open to anything which will give the user a way of determining how wide the text in a cell is, or how many rows a wrapped cell takes up. This information could possibly be conveyed with either NVDA+numpad delete or NVDA+tab.
Additional context
Windows 11 (64-bit) Version: 23H2, Build: 22631.4460 Office 365 (64-bit) Version: 16.0.18227.20046 NVDA 2024.4.1