Hi Chuck,
On 24/7/14 at 3:24 AM, chuck...@hotmail.com (chuck ef) 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.
Forgive my silly question: have you tried to simply open the
Excel file in OO instead of copying and pasting?
On your Mac you should be able to do this in a few different
ways - eg:
- In the Finder window showing your Excel file: right- or
CTRL-click on the file name and choose Open Office in the
drop-down "Open with..." menu
- Launch Open Office and drag your Excel file (from the Finder
window) onto its icon in the Dock
- Launch Open Office and navigate to your Excel spreadsheet in
the "Open file..." dialog (from the menu bar at the top of the
OO window)
(Forgive me if you already knew and tried all of the above!)
You can even change the default application for all Excel files,
so that they open directly in Open Office when you double-click
on their icons. Let us know if you'd like some help with that.
I have no suggestions to offer for your other issues, and hope
this helps somehow.
Cheers,
marina
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. 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.
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?
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org