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


Hi,

I have recently downloaded and installed LO i.e.:

Version: 5.3.4.2
Build ID: f82d347ccc0be322489bf7da61d7e4ad13fe2ff3
CPU Threads: 4; OS Version: Mac OS X 10.12.6; UI Render: default; Layout Engine: new;
Locale: en-ZA (en_GB.UTF-8); Calc: group

In previous versions of Calc I have many spreadsheets where I drag the thick 'freeze column' line from the bottom left and move it towards the left margin so that only the number of columns I want to freeze is shown. I can then move the columns to the right of the 'freeze' line as I want and the columns to the left of the 'freeze' line stay frozen.

As of version 5.3.4.2, the frozen columns remain frozen however should the columns to the right of the 'freeze' line not have the first column showing the 'frozen' column, entering data into the 'frozen' column forces the columns on the right of the 'freeze' line to re-arrange themselves so that the 'frozen' column is the first column after the 'freeze' line.

This is MOST annoying when needing to enter data only in specific columns once the 'frozen' column has been updated with new data.

There is a workaround with View->Freeze Cells however if you do not want to only 'freeze' the first column, this workaround fails.

Please bring back the functionality of just moving the 'freeze' line and not having the other columns re-arrange if data is entered into the 'frozen' zone.

Can anyone confirm if this also occurs/doesn't occur on the 2.3.5 download release.

Appreciated
Hylton
P.S: I am subscribed to the users mailing list

--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Context


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.