[Libreoffice-bugs] [Bug 107763] Zooming doesn't intelligently center selection ( works in Excel)

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=107763

--- Comment #2 from Kevin <timbacontent at gmail.com> ---

> Shift can also be used with the mouse to center a cell on the screen, even
> if this doesn't produce the same result than Excel.

Could you provide steps? Here are mine:

1. select a cell in the upper right corner of the visible area
2. hold down shift and roll the mouse forward

result: the zoom percentage remains the same but now the horizontal, rather the
the vertical, scrollbar is affected by the mouse wheel

3. hold down shift+control and roll the mouse forward

result: same as with just control: the left-most column stays visible and the
selected cell goes off-screen

To pose the problem from the user's perspective:

1. you have a massive spreadsheet with many rows and columns
2. you zoom out to see a large area and see a cell whose formatting needs to be
changed
3. you click on that cell and zoom in see it clearly and repair the problem,
but it disappears and you then have to use the scrollbars to find it again

This problem is a relative of another problem (already reported by others):
when zooming in and out, the spacing of fonts changes drastically (with
non-monospaced fonts) - so even after you've tediously zoomed in and fixed the
problem, your fix turns out not to be a good fix when you zoom back to 100%.
Many users do not use the calculation features of spreadsheet apps, but use
them to create carefully formatted documents more easily that they could with
tables in Writer or Word. This type of functionality is where both Excel and
Calc are so poor, albeit in very different ways.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20170511/6d5089b0/attachment.html>