• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Numbers Madness – Duplicate Cells
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Numbers Madness – Duplicate Cells


  • Subject: Re: Numbers Madness – Duplicate Cells
  • From: Yvan KOENIG <email@hidden>
  • Date: Mon, 06 Feb 2017 18:11:43 +0100


Le 5 févr. 2017 à 01:03, Christopher Stone <email@hidden> a écrit :

Hey Folks,

Using Numbers 4.0.5 on macOS 10.12.3.

I have a spreadsheet I imported from an Excel worksheet, and I pasted an excerpt into a new Numbers worksheet:

<Screen Shot 2017-02-04 at 13.13.13.jpeg>

As you can see I only have one row selected.

But – this script produces very odd results:

tell application "Numbers"
   tell document 1
      tell active sheet
         set activeTable to (the first table whose class of selection range is range)
         tell activeTable
            set cellValues to cells of selection range
         end tell
      end tell
   end tell
end tell

{
   cell "A2" of table 2 of sheet 1 of document id "80D97BB7-2506-4CD6-98CB-A2938C8D4F38" of application "Numbers", 
   cell "B2" of table 2 of sheet 1 of document id "80D97BB7-2506-4CD6-98CB-A2938C8D4F38" of application "Numbers", 
   cell "B2" of table 2 of sheet 1 of document id "80D97BB7-2506-4CD6-98CB-A2938C8D4F38" of application "Numbers", 
   cell "B2" of table 2 of sheet 1 of document id "80D97BB7-2506-4CD6-98CB-A2938C8D4F38" of application "Numbers", 
   cell "E2" of table 2 of sheet 1 of document id "80D97BB7-2506-4CD6-98CB-A2938C8D4F38" of application "Numbers", 
   cell "F2" of table 2 of sheet 1 of document id "80D97BB7-2506-4CD6-98CB-A2938C8D4F38" of application "Numbers", 
   cell "F2" of table 2 of sheet 1 of document id "80D97BB7-2506-4CD6-98CB-A2938C8D4F38" of application "Numbers", 
   cell "F2" of table 2 of sheet 1 of document id "80D97BB7-2506-4CD6-98CB-A2938C8D4F38" of application "Numbers"
}

I don't normally use Numbers, so this is extra confusing.

Does anyone know what's up with this?

So far I can't replicate the problem with a normally created Numbers workbook.

TIA.

--
Best Regards,
Chris

It seems that columns C and D are hidden.

Yvan KOENIG running Sierra 10.12.3 in French (VALLAURIS, France) lundi 6 février 2017 18:11:35



 _______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:
Archives: http://lists.apple.com/archives/applescript-users

This email sent to email@hidden

  • Follow-Ups:
    • Re: Numbers Madness – Duplicate Cells
      • From: Yvan KOENIG <email@hidden>
  • Next by Date: Re: Numbers Madness – Duplicate Cells
  • Next by thread: Re: Numbers Madness – Duplicate Cells
  • Index(es):
    • Date
    • Thread