fixed : can’t edit cells in Numbers

Question :

I made an extensive table in Numbers yesterday and saved when I was ready for the day. Today I want to work on it again, and it opens without a problem, but I can’t edit any cells… I can’t click in any cell, I can’t type anything inside it and the 1-2-3 numbering of the rows and the A-B-C ‘numbering’ of the columns doesn’t appear either…

The only thing I can edit are three cells at the top of the page…

What is wrong ?

 

Answer :

The solution might be rather simple :  probably, you have accidentally entered the Printing Preview mode.

You can see you are in Printing Preview mode when there are 2 buttons visible at the bottom the Editing pane on the right : “Done” and “Print…”

If so, just click on the “Done”-button to leave the Printing Preview mode and go back to the main Editing screen.

That’s it !

enjoy ūüėČ

fix : send iOS Pages document as Word document from iPad

Question :

I have MS Office running on my Mac, but it’s not Office 365, so on my iPad I can’t unlock all editing features of Word, PowerPoint and Excel for iOS …so I only have the option to open, view and read Word documents, PowerPoint presentations and Excel sheets.

At this moment, I only have my iPad available and not my Mac. Is there any way to quickly do a little editing on a Word document on my iPad, even though I don’t have Office 365 ?

 

Answer :

There are several options to do so. You could use Google Docs or Office 700 (an OpenOffice version for iOS), but you probably have Apple Pages already installed on your iPad, so that is most likely the quickest solution :

  • open Pages.app on your iPad
  • under “Locations” find the Word document you want to edit
  • you will see that the Word document is opened as if it were a Pages document
  • now edit it as you wish
  • when finished, click on the button top-right (the button that looks like a circle with three dots in it)
  • in the menu that appears on the right, click on “Export”
  • in the pulldown menu that appears, click on “Word”
  • in the popup window, click on “Save to Files”
  • in the next window, select a location to save the Word document, then click “Save”

That’s it !

enjoy ūüėČ

fixed : get usable (.tif or .jpg) pictures out of a PowerPoint-presentation

Question :

My colleague¬†sent me a PowerPoint-presentation with pictures in it that I want to use in my own Keynote-presentation. But, whenever I select a picture in the PowerPoint-presentation and drag-&-drop it onto my Desktop (as I usually do in OSX to get a picture out of a website or alike), I get a file named “Picture Clipping.pictClipping”. When I double-click on that, I get a Finder window with the correct preview and a line of info saying “Clipping contents: TIFF image”. But I can’t import that .pictClipping file into my Keynote-presentation as a picture. Neither can I find any way to get the TIFF-image out of the .pictClipping-file.

What can I do ?

 

Answer :

You’ve stumbled upon a hard-to-tackle problem with PowerPoint-presentations.

The solutions is rather simple, but takes a some effort. You can choose to either export  only one picture, or export all pictures from the PowerPoint-presentation :

If you only need one picture :

1- make sure you have GraphicConverter installed (if you don’t have it, you can download it from¬†the LemkeSoft.de website¬†for FREE and use it in “try it”-mode)

2- open your PowerPoint-presentation and drag&drop the picture you need onto the Desktop ; it will appear as a file named “Picture Clipping.pictClipping”

3- right-click on the¬†“Picture Clipping.pictClipping”-icon and select “Open with…” from the pulldown menu that appears, then select “Other…” and select GraphicConverter 9 from the list that appears

4- GraphicConverter will now display¬†the picture ; select “File” from the top menu bar, and “Save As…” from the pulldown menu that appears

5- in the window that opens, select select the destination folder and at¬†“File Format:”¬†choose JPEG/JFIF, PNG or TIFF and click the “Save”-button

6- then in the Finder, go to the destination folder and drag&drop the picture into your Keynote-presentation

…that’s it ūüėČ

If you need multiple (or even all) pictures  :

1- make sure you have GraphicConverter installed (if you don’t have it, you can download it from the LemkeSoft.de website¬†for FREE and use it in “try it”-mode)

2- right-click on the PowerPoint-presentation’s icon and click on “Duplicate” from the pulldown list that appears ;¬†if your original was named “presentation.ppt” the duplicate will be named “presentation copy.ppt”

3- select the icon of the “presentation copy”-file and change the .ppt or .pptx file extension into .dat (when asked¬†“Are you sure… ?”, click on the “Use .dat”-button)

4- now, right-click on the “presentation copy.dat”-file’s icon and click on “Open With” in the pulldown list that appears, then select “GraphicConverter” and click on it

5- in¬†GraphicConverter, you will now see only the first picture from the PowerPoint-presentation, but in the bottom bar, you will see “Page: 1 of X” (in which X is the total number of pictures), there you can scroll through all pictures ;¬†then, from the “File”-menu, select “Convert & Modify”

6- in the window that opens, you will see 3 columns : in the left column, make sure that “Function: Convert” is selected, and “Destination Format:” is set to JPEG/JFIF, PNG or TIFF

7- in the middle column, you will see the “From:”-button and the file named “presentation copy.dat” (with the first picture as it’s icon) ; in the right column you will see the “To:”-button ; there you should select your desired destination folder

8- then, click on the “Go”-button at the bottom of the left column (and all pictures will be exported the way you have asked)

9- do not forget to drag the “presentation copy.dat”-file to the Trash (and empty the Trash)

10- in the Finder, you can now open the destination folder and drag&drop the picture(s) you need into your Keynote-presentation

…that’s it – enjoy !

Donate Button (MacManusNL)

tip : get Keynote, Pages & Numbers for FREE with OSX 10.9 Mavericks

Question :

I heard that you can get the new versions of Keynote, Pages and Numbers for FREE when you upgrade to OSX 10.9 Mavericks.

Is that true ? And how do I get them ?

Answer :

Yes, it’s true !

But… there is a tricky part in this… BEWARE !

This can ONLY be done BEFORE you upgrade to OSX 10.9 Mavericks, as it is a (deliberate) loophole in the OSX 10.9 Mavericks upgrade process :

Apple is shifting all installations of it’s software to the Mac App Store, and the OSX 10.9 Mavericks installer therefore checks for all previous versions of Apple app’s that you have installed on OSX 10.8 Mountain Lion…

all versions of Keynote, Pages, Numbers and Aperture (!) will be ‘upgraded’ to the latest Mac App Store versions of the same apps.

note : even trail-versions and illegally copied versions will be ‘upgraded’ to full legal versions for FREE !

So, get an old version of the iWork apps (and/or Aperture) installed before you upgrade to OSX 10.9 Mavericks, and you get the new versions for FREE.

Enjoy !

Donate Button (MacManusNL)

fixed : change the Currency-format of only a few cells in Numbers (from iWork)

Question :

I’m using the Apple Numbers spreadsheet-app (from iWork) and I want to use multiple currencies in one spreadsheet (US dollars, GB pounds and Euros). I tried “Create / Change Custom Cell Format” from the “Format”-menu, but there the currency is set to default to my local currency (Euros) and I can’t change it…

This must be possible, right ?

But, how do I do it ?

Answer :

The trick is you should change the currency format of a (group of) cell(s) in the “Inspector”…

Here’s how to :

– in Numbers, select the cell or cells of which you want to change the currency

– then click on the “Inspector” (info-sign shaped button on the right of the upper bar of the spreadsheet-window)

– in the “Cells”-window that opens, choose the tab marked “42” (*)

– there, under “Cell Format” you should change the default “Automatic” to “Currency” and choose the one you want to use

That’s it !

ūüėČ

(*) this is probably a subtile reference to “The Hitchhikers Guid To The Galaxy (H2G2)”, where 42 turns out to be the answer to “the ultimate question of life, the universe and everything”

Donate Button (all)