James:
Have you tried just loading an MS file directly?
James Lambert
-----Original Message-----
From: James Plante
Sent: Friday, July 25, 2014 7:32 AM
To: [email protected]
Subject: Re: Calc issues, Mac OS X 10.9.4
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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
