languagems officesettings
In Windows, List separator (, as shown in my system) is a parameter that we could set:
I'm trying to find this setting in my Mac, but I could not find it. Here is the only thing I could find:
It seems that this separator is used to separate arguments in Excel functions.
Does anyone know how to set the list separator in Mac?
PS: I'm using Mac OS Big Sur 11.4
Office 2011 for Mac is very much like Office 2010 on Windows. You'll see the same equation button in the Ribbon, and more buttons while you're editing an equation. I don't think you'll be disappointed.
Plus, you can always download a trial version of Office 2011 to make sure your files will be compatible!
What you want can be accomplished with Automator which comes with OS X.
Open Automator from the Applications folder
Choose New from the File menu or type ⌘-N and choose 'Application'
Search Actions for Launch and drag Launch Application to the workflow on the right
set the app to Word or whatever else you're having the problem with
search Actions for 'Pause' and drag pause to the workflow, set it to however long it takes word to open for you (e.g. 5 seconds)
search Actions for Open Finder Items and add that to the workflow.
Save it as an Application, drag it to your dock and drag docs on to the icon for it when you want them to open on top of the previous Word docs.
N.B. you can also set all documents to open using your freshly created app, so you can just open them as usual, but then a delay will permanently be added to their opening.
Best Answer
Yes, it is used to delimit arguments in Excel functions and as the default field separator when saving Excel spreadsheets as CSV files.
However, it is only used if "Use system separators" is set in Excel's advanced options (which it is by default). And this setting can be overridden with Excel's own settings.
I'm not actually aware of any other (office) applications that actually use this system setting. (Although no doubt there are.) AFAIK, LibreOffice Calc uses only its own internal settings (Tools > Options > LibreOffice Calc > Foruma > Separators > Function).
AFAIK there is no explicit setting for this in MacOS. It is instead deduced from the "Decimal" setting under "Number separators" (and "Currency"?) in the regional settings. ie. If a comma is used as the "Decimal" number separator (as in your screensheet) then a comma cannot be used as the "list separator" in Excel, so will instead default to a
;(semicolon). If instead a dot (.) is used as the "Decimal" separator, then a comma can be used as the "list separator".This answer to a related question on Superuser.com suggests that it is dependent on both the "Decimal" settings of "Number separators" and "Currency", although it's not clear to me why "Currency" would be significant here (at least not for the function argument delimiter).
Further reference: