Skip navigation

Line Breaks/Carriage Returns in Numbers Forms

7756 Views 9 Replies Latest reply: May 5, 2012 6:28 AM by steven.tys RSS
Jason.Goldsmith Calculating status...
Currently Being Moderated
Dec 3, 2010 5:16 PM
I was using the Forms feature in iPad Numbers and when entering data in a text field, there doesn't appear to be any way to enter a line break or carriage return. All of the text has to be in one paragraph. The normal intelligent keyboard for text entry in the standard table view supports a return, but not in the Forms.

Did I miss something or is this a missing feature? Is there some way to work around it?
iPad, iOS 4
  • Bassphil Calculating status...
    I was just about to post this problem as well.

    I have a giant spread sheet of my LP collection in Numbers. There is one field where I want to enter info like this, with a return after the first line:

    Riverside Records RLP-12-320 MONO
    Blue and silver label, Mic and Reels at top, Bill Grauer Productions at bottom

    With the onscreen keyboard, it's not a problem. I hit the return button on the screen and it starts a new line in that cell under the first line.

    With the bluetooth keyboard, I can't seem to find any combination of keys to get the cursor to start a new line. Anytime I try, the result is the cursor jumps to the cell below.

    Any ideas?

    Thanks in advance!

    -Phil

    Intel 8-Core beast, PB 1.67ghz G4, 450mhz Cube etc....   iOS 4   RAM, and lots of it!  
    Report this post
    Intel 8-Core beast, PB 1.67ghz G4, 450mhz Cube etc...., iOS 4, RAM, and lots of it!
  • JimHdk Level 7 Level 7 (21,830 points)
    Currently Being Moderated
    Feb 23, 2011 2:55 PM (in response to Bassphil)
    Have you tried shift+return?
    IPad 64GB, iPod Touch, iMac, iOS 4
  • Bassphil Level 2 Level 2 (215 points)
    Currently Being Moderated
    Feb 23, 2011 3:40 PM (in response to JimHdk)
    Thanks for the reply. Yep, I tried shift and every key there is- fn, control, option, command. Interestingly, the command-return does nothing. Control-return and option-return (with and without the **** key) all make it jump to one cell below.

    It wouldn't be a big deal if I had the option to pull up the on-screen keyboard in addition to the bluetooth keyboard. I could just tap the return key on the screen when I needed to.

    On the full Mac version of the app, you have to option-return to get the curser to start a new line.

    Maybe they didn't write it in to the app.... I'll have to see if I can find a way to pull up the onscreen keyboard as a work around.
    Intel 8-Core beast, PB 1.67ghz G4, 450mhz Cube etc...., Mac OS X (10.5.2), RAM, and lots of it!
  • Bassphil Level 2 Level 2 (215 points)
    Currently Being Moderated
    Feb 23, 2011 3:50 PM (in response to JimHdk)
    Well, on a burst of inspiration, I discovered that if I tap the eject key on the bluetooth keyboard, the onscreen keyboard pops up. I guess that's a decent work-around for the problem.

    Now if I can only figure out why spell check is disabled when I'm using the Bluetooth keyboard...
    Intel 8-Core beast, PB 1.67ghz G4, 450mhz Cube etc...., Mac OS X (10.5.2), RAM, and lots of it!
  • steven.tys Calculating status...

    I figured out how! Slightly not intuitive.

     

    Simple click on the formula bar, and besides the cut copy paste option, you should see a "New Paragraph"

    Choosing new paragraph will give you a line break.

  • Geiger Level 1 Level 1 (25 points)
    Currently Being Moderated
    May 5, 2012 3:40 AM (in response to steven.tys)

    Hi Steven. Thanks for this. Sounds like the answer I need, but not sure what you mean by the formula bar.

     

    Thanks.

  • steven.tys Level 1 Level 1 (0 points)
    Currently Being Moderated
    May 5, 2012 4:00 AM (in response to Geiger)

    Photo 5-5-12 18 52 19.png

     

    Geiger, i hope this helps!

  • Geiger Level 1 Level 1 (25 points)
    Currently Being Moderated
    May 5, 2012 5:22 AM (in response to steven.tys)

    Thanks Steven. I have to admit it is my mistake, because I was looking at Numbers in OSX and not iOS5. Thanks for posting however.

  • steven.tys Level 1 Level 1 (0 points)
    Currently Being Moderated
    May 5, 2012 6:28 AM (in response to Geiger)

    Hey Geiger, maybe that's why you didn't get the right answer here! "Option (or ALT) +Return" will do

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.