Yes. The file will load just fine--UNLESS you try to Insert-->From file... If you do that, the inserted file overwrites the one you loaded originally. So I have to open each Excel file and save it as an .ott. Then I can copy/paste between them normally.
Jim On Jul 25, 2014, at 12:41 PM, James Lambert <[email protected]> wrote: > 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] > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
