Re: [SPAM?] Re: [libreoffice-users] Libre Calc - moving text in cell + comparison chart

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