Date: prev next · Thread: first prev next last
2015 Archives by date, by thread · List index

On 18/10/2015, at 08:17, James E. Lang <> wrote:

PLEASE, developers, think about the impact your change will have on existing users.  The longer a 
shortcut has existed the more attention should be given should be given to the impact of changing 
it with shortcuts that have existed for more than one full major release being ALMOST cast in 

This particular change from F4 to Ctrl-Shift_F4 for data source in Calc but not in Writer is a 
massive problem. The F4 shortcut has been around for YEARS.

I now have to re-write my tutorials and workshop examples.
I now have to go back to the hundreds of users that have been using F4 for YEARS and try to explain 
why there is a difference between Calc & Writer.

A large number of the people (I have trained ) that use LibreOffice use F4 for mail merge in Writer 
and Pivot Tables in Calc. 
Because the usual source is a MySQL database where data is being updated on a regular basis, the 
mail merge and pivot tables need updating regularly.

Why was this change made? 
As far as I can see (from the bugzilla history) it was requested in 2013 because 1 or 2 people, 
that are changing from Lotus 123 to Calc could not make the change from F4 to Shift-F4 for the 
"Absolute cell reference shortcut".

I don't remember any of "my" users having ever found it necessary to change the cell reference from 
absolute to relative once they have formatted a cell.

So I agree with James Lang & Alexander Thurgood when they decry this change.
Who made the change 2 years after it was requested, without discussing it with the people on this 

Developers, please do NOT make changes to existing menu options and shortcuts without FULLY 
consulting the "professional" users of LibreOffice. 
Thank you.

Tony Bray

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.