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



On 4/26/2015 4:16 PM, Brian Barker wrote:
At 14:31 26/04/2015 -0400, Charles Meyer wrote:
I'm learning the function keys between MS Excel and Libre Calc work quite differently. In Excel if you wish text in a cell to return to the next line in that cell, you choose Ctrl + Enter.

I think you are a bit confused here! In Microsoft Excel, Ctrl+Enter is used in place of Enter to complete an entry when you have selected a range of cells and want them all populated with the same entry. In Excel, if you want to create a manual line break within a cell, you use Alt+Enter, not Ctrl+Enter.

That doesn't seem to work in Libre Calc. Could you please share how that is done in Libre Calc?

To add to the confusion, Ctrl+Enter is precisely how you achieve the same thing in Calc! But this works only in the cell, not in the Input Line. And - you've guessed it! - Alt+Enter is how you perform multiple insertions. The two keyboard shortcuts swap their effects between Excel and Calc, that is.

Has anyone happened upon any comparison chart showing how to accomplish certain functions in Libre Calc compared with how you perform them in MS Excel?

https://wiki.openoffice.org/wiki/Documentation/UserGuide/Migration_Guide/Calc_and_Excel is written for OpenOffice and may or may not be helpful. It's part of OpenOffice's Migration Guide.

I trust this helps.

Brian Barker


It certainly helps me! Your "To add to the confusion" paragraph details something I've been wanting for a long time.
-- Tim Deaton


--
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.