-
All replies
-
Helpful answers
-
Jul 18, 2014 3:48 AM in response to solsticesolutionsby Yellowbox,★HelpfulHi Solstice,
Numbers 3.2 on a Mac
File > Export To > Excel...
Open the Excel file in Numbers:
The usual glitches that I expect (extra cells added, Table name becomes a merged table cell, very thin row 1 added...)
Then I copied and pasted that table with the intention of editing (and giving it a good slap), but (Hallelujah!) I got this:
A working table with checkboxes. I still need to delete the extra columns C,D,E and the extra rows, but the pasted table magically restored the checkboxes.
Cautionary notes:
- 1. I do not have Excel. All I did was Export to Excel then open again in Numbers 3.2 for Mac.
- 2. I do not have iPad or iPhone to test this.
- 3. If your business (and income) depend upon collaborating with clients who use Excel, go with the flow and use Excel or an Excel clone such as Libre Office.
Regards,
Ian.
P.S. I have just realised how I was able to have two Table 1s on the same sheet. They are not named Table 1; those names are now in merged table cells. The real table names are here:
Well done, Apple!
Ian.
-
Jul 18, 2014 8:00 AM in response to Yellowboxby solsticesolutions,Thank you Yellowbox! You helped me to realize that I can copy my entire form (filled with False's) and then paste in the exact same spot and it magically inserts the checkboxes I need. A lot less steps. This likely should have been intuitive but sometimes you need a push in the right direction. Thanks!
-
Jul 18, 2014 8:08 AM in response to Yellowboxby SGIII,That's a great discovery, Ian!
I tried copying a range of cells from Excel and pasting into Numbers. The cells with TRUE and FALSE paste into Numbers as ... checkboxes!
SG
-
Jul 18, 2014 8:18 AM in response to solsticesolutionsby Yellowbox,Hi Solstice,
This likely should have been intuitive but sometimes you need a push in the right direction.
Not intuitive, a lucky find through serendipity!
Thanks for your question. Playing showed me a solution.
Keep playing!
Regards,
Ian.
P.S. Hi SG, I got an email notification of your reply as I was composing this. Good news!
Another tip from ChitlinsCC in "Using Apple Support Communities" Re: Using the new-look forums, asking for positive comments
Now, following that tip, I am posting this reply by typing command s
Ian. (command s)
Edit: Yup! command s worked.
-
Jul 18, 2014 10:40 AM in response to Yellowboxby SGIII,Ian. (command s),
'Command s' works! Is that going to be your new alias?
SG



