I noticed some time ago, that a thousands separator space became smaller in width. No matter if I change locale in system settings, the size of a space stays the same. Can't find any setting to change this. Can barely see any difference.

I have a spreadsheet with a list of months as the columns with the value 1/1/2020, 2/1/2020, 3/1/2020, etc. The cell format has been set to January, February, March, etc. When I attempt to use date for calculation, it uses the month name and not the date. Example: =SUMIFS($Amount,Date,">="&E1,Date,"=03/01/2020" it works as expected. Is there a way to force Apple Numbers to use the Actual value and not the formatted one? The documentation says it should be doing this, but it does not.

It seems like something that should be simple, and it probably is but my mind is being dense and not helping me. I have a table with two columns. The first acts as a master list of titles, and the second acts as a list of titles used. I simply want a way to remove everything that has been used from the master list so that the first table no longer contains them. Can someone help me with a script or simple way to do this? Have tried scripts when I had this both on one table: tell application "Numbers" activate tell front document tell sheet 1 set masterList to value of cells of column "B" set usedList to value of cells of column "C" repeat with i from (count of masterList) to 1 by -1 set masterItem to item i of masterList if masterItem is in usedList then delete cell i of column "B" end if end repeat end tell end tell end tell Here's how it is set up:

I just purchased a used 2006 MacBook Pro with OS X 10.6.8. I went to the Mac App Store and tried to load Pages, Numbers and Keynote, and it said it could not load them unless I had 10.7. When I try to upgrade to Mountain Lion, it says my computer does not have the requirements. I can't find Lion—not sure if I could even upgrade to that? My question I guess: Is there an older version of Pages, Numbers and Keynote that I could get that would work on my machine as-is, without any upgrades?

Will Pages/Keynote/Numbers (ex. iWork) be free for old macs?

Apple introduced Pages, Numbers, and Keynote as a Mac native platform for documents such as letters, spreadsheets, and presentations. These applications come pre-loaded with OS X, as they did with my computer, however, after re-installing OS X after having unrelated issues with my computer, I found that these iWork applications were simply no longer there. So, I transferred the suite from a colleague's computer to my own, however, said applications soon became obsolete, as I couldn't update them without my colleague's password. So, I deleted the applications once more, as they were rendered useless. This wasn't too much of a problem until recently, as I began to need the applications for other projects. Whenever I visit the Mac App Store, I'm not able to simply download them, rather, I have to pay money for them. Which, eventually I succumbed to, grudgingly paying the $15 for Pages, but it didn't download. I lost the $15, with no result from the App Store. Pages doesn't show up in the Purchased section of the Store, and there's nothing in my Applications folder that would suggest that it did indeed download. Any suggestions? Or does this warrant a visit to the Genius Bar? Specs: iMac 27" Late 2013 running OS X 10.11 El Capitan

I create a numbered list: 1. Point 1 2. Point 2 and so on. Now I realised that the content of 2 requires two paragraphs 1. Point 1 2. Point 2, paragraph 1 Point 2, paragraph 2 but pressing enter in a list just creates a new list entry. Shift-Enter gives a new line but not the extra space you want to separate the paragraphs (c.f., this paragraph and the previous paragraph): 1. Point 1 2. Point 2, paragraph 1 Point 2, paragraph 2 (There is too much space in this example but you hopefully get the point.) How can this be achieved?

Amazingly, a year after Lion has been released, iWork still does not support Lion / ML's global text substitution settings. I use these widely for special technical symbols. Although global text substitution is not supported in iWork, Keynote and Pages do have their own local text substitution function, which performs the same as the global one, but doesn't use the global settings. My problem? I have about 100 text substitutions set up in Lion, so entering them in each iWork application would take an age. Does anyone know a way (e.g. by editing preference files etc.) to transfer all the settings from Lion's text substitution feature into Keynote and Pages? This would be a huge time saver for me.

In Keynote I am inserting multiple connection lines to a single image. As soon as I drag one end point near the image the end point of the connection line snapped onto the image. I would like to have complete manual control over the positioning and depth of connecting lines. How do I stop Keynote from auto snapping my connection line?

Is it possible to select all of the hyperlinks in a document? I want to change the colours for every link in the document but it seems a bit odd that i have to go through all of them manually.

I have something like this | Start time (A) | End time (B) | Time passed (C) | Units done (D) | How many units per 24h (E)| | -------- | ---------- | ----------- | ---------- |------------------------- | 08:25 | 15:40 | 7h15m | 43 | **???** I can manually calculate that 7h15m = 26 100 seconds. 26 100/43 returns the time it takes to finish 1 unit = 607 seconds. 24h are 86 400 seconds. Therefore, per 24 h 142 units will be done (86 400/607 ≈ 142). I can calculate the value in E using this formula = D/(B - A) * 24 - but when C is bigger than 24 h this formula no longer works - you have to remove the multiplication with 24 then. How can this be done in Numbers?

Is it possible to measure the time spent in each slide in Keynote, during a rehearsal? Something like this feature of PowerPoint: https://support.microsoft.com/en-us/office/rehearse-and-time-the-delivery-of-a-presentation-8424270a-d865-4aed-a321-1d2dd656381a

In a numbers file I am using, whenever I open it I need to manually import a specific value from a webpage. Specifically, from [this webpage](https://www.xe.com/currencyconverter/convert/?Amount=1&From=USD&To=EUR) I want to import the USD to EUR ratio. Any other similar webpages are welcome of course. :) Any ideas on how to do it automatically?

I am working on my first Keynote presentation, and my first slide has a series of complex animations which results in a slide which is very different from how it started. I wish to maintain the end state of the first slide when I transition into the next slide so that I can keep some continuity in the story. I was wondering, is there any way of viewing the final state of a slide, after all animations are complete? I can then copy everything into the next slide. I'm not able to find anything that would let me do this. The designer only shows me elements as at the beginning sans any translations/animations.

I have read https://apple.stackexchange.com/questions/288324/wrap-words-in-pages but my question is different. How do I prevent a specific word from being hyphenated (because Pages is wrong - "IS-P:er" (!!))? I have a vague memory that there used to be a list of words, in the settings for Pages, that shouldn't be hyphenated but that might be in the "old" version of Pages (09? - when the icon was dark/black).

I have a 2010 MacPro running Mojave. I've been trying to buy, copy, or steal copies of Pages and Numbers for hours just so I can work on a client's Pages file. Why is this so hard?

I have a diagram in macOS Numbers 12.2.1 with two trendlines where I also inserted the equation for each trendline. The problem is that those two equations are on top of each other and I can't find a way to move them: Clicking on them shows that they are selected: and I can change e.g. font size when I am in this "mode", but I am unable to move them. If I click, hold and drag I just move the everything, both equations and the actual diagram. No difference if I click and drag the number or the "handles" (the empty circles) Doubleclicking does nothing. **How do I move the equations?** I want them separated, preferably close to the their corresponding trend line. ---- **Update 1:** Tried removing and re-inserting the trendlines, but the result was the same.

I was trying to make a presentation in Keynote since it had a direct LaTeX equation writer embedded. However, I soon realised that some of the commands (and therefore packages) were not supported. I've searched online and it seemed that the only possibility would be to add equations as a PDF. But I was wondering if there is a way to install new packages directly in the blahTeX used in Keynote or, even better, make Keynote use the MacTeX I've installed. Thanks!

Starting with [this post](https://apple.stackexchange.com/questions/452018/how-to-import-file-to-shape-in-pages) , I am trying to insert my own Shapes into Pages and one of the challenges is being to generate a valid [UUID](https://docs.oracle.com/en/database/other-databases/nosql-database/21.1/sqlreferencefornosql/using-uuid-data-type.html) for the identifier. I have tried UUID version 1, 3, 4 and 5, none of which Pages seems to recognize as a valid UUID. I learned that 3 and 5 can accept a namespace. So am wondering if there's a specific namespace that needs to seed the UUID when it's generated. Apple documents [it's own UUID](https://developer.apple.com/documentation/foundation/uuid) , which perhaps I could generate with X-Code, but I'm not sure. This is one of the Pages-generated UUID's:

9B7722F5-8029-4454-A8CA-AE6202BB5CA6 | my_shape

Any suggestions?

I recently downloaded a resume template file for Pages, which has a some "shapes" in it and I'd like to add my own icons as shapes (for Github, StackExchange, etc), which I haven't come across any docs about. I tried importing an .eps file, but it just comes in as an image. Pages doesn't import .svgs. Looked in

/Applications/Pages.app/Contents/Resources

And found

-rw-r--r--@ 1 root  wheel   4.9M Mar 17  2022 shape_library.json

Which is full of vector paths:

"178": {
      "id": 178,
      "shapePath": "M 478.593750 125.187500 C 416.293752 125.187500 399.593709 186.399994 399.593750 210.500000 C 399.593750 248.899999 422.693705 268.293742 435.593750 290.593750 C 437.793750 294.293750 434.706266 298.906298 430.406250 298.406250 C 350.606252 289.506250 305.412435 324.687501 274.312500 325.187500 C 256.412500 325.487500 227.393692 277.506254 204.093750 296.906250 C 187.893751 310.306250 184.693736 486.906254 314.593750 486.906250 C 444.393748 486.906250 485.500020 486.906250 485.500000 486.906250 C 485.500000 486.906250 595.406250 483.906311 595.406250 391.406250 C 595.406250 298.906250 539.406250 300.987528 539.406250 271.687500 C 539.406250 242.387499 591.606242 244.693736 595.406250 236.593750 C 599.606250 227.693750 582.312510 222.006271 582.312500 219.406250 C 582.312500 216.806250 600.106201 201.087508 595.406250 193.687500 C 590.906250 186.687500 582.187459 201.999990 556.187500 195.000000 C 553.487500 194.300000 551.512606 192.200014 550.812500 189.500000 C 545.912500 170.199999 536.193629 125.187523 478.593750 125.187500 Z M 478.593750 125.187500",
      "localizationKey": "Rubber Duck_178",
      "categories": {
        "37": {
          "position": 56
        }
      }
    },

But this is obviously not meant to be edited. Pages doesn't have a directory in /Library/Application\ Support/ or ~/Library/Application\ Support/. What am I missing? # UPDATE Based on answer from @grg, I found my way into the db that stores the user-defined shapes and am hoping to make some updates there. 1. Get into the db sqlite3 ~/"Library/Containers/com.apple.iWork.Pages/Data/Library/Application Support/com.apple.iWork.CloudKitStorage/com.apple.iWork.TSKCloudKitPrivateZone.db" 2. Look around

sqlite> pragma table_info(TSDUserDefinedShapeLibraryShape);
0|identifier|TEXT|0||1
1|cloudKitMetadata|TEXT|0||0
2|needs_first_fetch|INTEGER|0|0|0
3|TSDUserDefinedShapeLibraryBezierPathStringKey|TEXT|0||0
4|TSDUserDefinedShapeLibraryName

sqlite> select identifier, TSDUserDefinedShapeLibraryNameKey   from TSDUserDefinedShapeLibraryShape;
E52A91BC-3774-45AE-B7A8-456EA04E4C0B|Envelope
E19F63AC-23B4-4495-B401-A83544A7AF37|Globe
7C133FEE-8C55-45B5-BB6A-D7A264898555|Location
9B7722F5-8029-4454-A8CA-AE6202BB5CA6|triangle

3. Make a modification

update TSDUserDefinedShapeLibraryShape set TSDUserDefinedShapeLibraryNameKey = "not a circle" where TSDUserDefinedShapeLibraryNameKey  = 'triangle';

4. Confirm updated

sqlite> select identifier, TSDUserDefinedShapeLibraryNameKey   from TSDUserDefinedShapeLibraryShape;
9B7722F5-8029-4454-A8CA-AE6202BB5CA6|not a circle

5. Quit and Restart Pages - updated name not there. However if I update the name _within_ pages, the new name shows up right away:

9B7722F5-8029-4454-A8CA-AE6202BB5CA6|treehouse

So it seems that Pages is writing to the db in realtime, but not reading from it. Perhaps it's the cloudkitMetadata that needs to change. Perhaps I just shouldn't be trying to use the application in this way. ### Safety To backup db before hacking at it:

.sqlite ~/"Library/Containers/com.apple.iWork.Pages/Data/Library/Application Support/com.apple.iWork.CloudKitStorage/com.apple.iWork.TSKCloudKitPrivateZone.db" \
    ".backup 'iword_cloudkit_backup_file.sq3'"

## Second Update Possibly due to having disconnected from the internet, my database changes are now showing up after restarting the Pages application. I can now successfully run CRUD commands on the db and as they will work if certain specs are met: 1. location needs to be a UUID of the correct format. Not sure what format that is. [This website](https://hashes.com/en/tools/hash_identifier) suggested the app is generating either version 1 or 4. I have tried generating my own and they don't seem to work. I can only INSERT if I use a location previously generated by the app. 2. Am still unsure if being connected to the internet makes any difference. 3. The TSDUserDefinedShapeLibraryBezierPathStringKey needs to be a [Bezier curve](https://en.wikipedia.org/wiki/B%C3%A9zier_curve) . Not an svg path. I have tried using a [tool to generate a Bezier curve from svg path](https://itchylabs.com/tools/path-to-bezier) , but so far not in a way that renders correctly. In testing I copy-pasted paths from the shapy_library.json file referenced above.