• 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
Numbers Madness – Duplicate Cells – 3rd Try
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Numbers Madness – Duplicate Cells – 3rd Try


  • Subject: Numbers Madness – Duplicate Cells – 3rd Try
  • From: Christopher Stone <email@hidden>
  • Date: Sat, 04 Feb 2017 18:26:47 -0600

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:

<Screenshot removed, because the blasted list-serve wasn't passing all 31K of it.>

The yellow-hightlighted lines is selected in the spreadsheet.

eject
Eject removable media
resizepart
Informs the Linux kernel of a new partition size
elvtune
Tune the I/O elevator per blockdevice queue basis
rev
Reverse lines of a file or files
fallocate
Preallocate space to a file
rtcwake
Enter a system sleep state until specified wakeup time

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 "A27" of table 1 of sheet 1 of document id "AA757A17-6DA0-45C3-855F-91206CE474F8" of application "Numbers", 
   cell "B27" of table 1 of sheet 1 of document id "AA757A17-6DA0-45C3-855F-91206CE474F8" of application "Numbers", 
   cell "B27" of table 1 of sheet 1 of document id "AA757A17-6DA0-45C3-855F-91206CE474F8" of application "Numbers", 
   cell "B27" of table 1 of sheet 1 of document id "AA757A17-6DA0-45C3-855F-91206CE474F8" of application "Numbers", 
   cell "E27" of table 1 of sheet 1 of document id "AA757A17-6DA0-45C3-855F-91206CE474F8" of application "Numbers", 
   cell "F27" of table 1 of sheet 1 of document id "AA757A17-6DA0-45C3-855F-91206CE474F8" of application "Numbers", 
   cell "F27" of table 1 of sheet 1 of document id "AA757A17-6DA0-45C3-855F-91206CE474F8" of application "Numbers", 
   cell "F27" of table 1 of sheet 1 of document id "AA757A17-6DA0-45C3-855F-91206CE474F8" 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

 _______________________________________________
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

  • Prev by Date: Re: Numbers Madness – Duplicate Cells
  • Next by Date: Re: Finder troubles in 10.11.6
  • Previous by thread: Re: Numbers Madness – Duplicate Cells
  • Next by thread: Re: Finder troubles in 10.11.6
  • Index(es):
    • Date
    • Thread