Reply interleaved:
On Jul 24, 2014, at 12:24 PM, chuck ef <[email protected]> wrote:
> I am an OO newbie so bear with me.
> I am on an iMac using 10.9.4 and I have never used OO before. I downloaded
> 4.1.0. I am trying to migrate an MS Excel spreadsheet to Calc. It will be
> nice to get away from MS.
> Anyway, I have noticed two problems right off the bat - maybe they are known
> already and I simply need to be vectored to the appropriate Apache site. But
> in the even that they are not known already ....
> 1.) I seem unable to cut-and-paste "large" amounts from my current MS Excel
> file into OO Calc. I can do a small set of cells. When I do a 'select all' in
> Excel and try to paste into Calc, however, nothing happens.
This is likely because when you "Select All," you're selecting the entire range
of the spreadsheet's capability, not just the cells that contain data. That's a
LOT of cells, and a copy/paste could take a lot of time.
> Work around: Open the Excel spreadsheet from within Calc. That is OK but not
> particularly satisfying when I later have to paste more in from some other
> source. But it is OK for now.
I find that trying Insert->From file... will work, but it often replaces what
I've already imported. Workaround (for me) has been to open each Excel file in
Calc, then save as an .odt. After doing that, opening inserting and copying
work as expected within AOO.
> 2.) I use a so-called Apple Magic Mouse. Excel often is jittery when I
> accidentally slide a finger across the top of the mouse - columns zoom by but
> it is recoverable, though irritating. However, Calc does not seem to be able
> to recover so easily. It can get confused quickly (by a minor though quick
> finger swipe across the mouse - speed of swipe seems to be the issue) and
> head off into columns unknown. I try scrolling back with the mouse (sliding a
> finger across the top of the mouse like a track pad) but it does not seem to
> be able to get back to Column 'A'. It just seems lost (three-letter columns
> will come down to two-letter columns but then go back to three-letter and so
> forth, sort of drifting even though I am making a determined effort to scroll
> back to the origin).
> Work around: Use the Calc scroll bar at the bottom of the Calc spreadsheet.
> Again, that is OK but not very satisfying. I was also able to "recover" by
> reloading (from the Calc menu) but that would probably not be a good solution
> for this apparent column tracking problem if it occurs before I have had a
> chance to save my work - I have not tried that though.
> Has anyone seen this before? Am I retracing old issues?
Another workaround: Use the address box in the lower left corner of the
window's title bar. Click in it, type "A1" and return. It should take you
immediately to cell A1. I have no idea what causes the squirrely behavior, but
it is present with Apple's touch pads, too.
Jim
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
