Office 2011: Really? Really? - Page 13 - ehMac.ca
Facebook
Twitter
YouTube
Register FAQ Members List Calendar Search Today's Posts Mark Forums Read Advertise


Reply
 
LinkBack Thread Tools Display Modes
Old Sep 27th, 2017, 05:40 PM   #121
Honourable Citizen
 
CubaMark's Avatar
 
Join Date: Feb 2001
Location: Nova Scotia, Canada
Posts: 17,908
Send a message via AIM to CubaMark
Quote:
Originally Posted by wonderings View Post
I cannot imagine using Word for anything but text. In my opinion if you are wanting to mix text and images you need a page layout program.
Word struggles to do basic page layout correctly (something we could do in friggin' ClarisWorks and AppleWorks!), but it's not out of its declared capabilities. I'm not asking it to do anything extraordinary! But in academia our documents typically are text-heavy with varying amounts of charts and tables, sometimes photographs. When we get to the level of preparing books, on the author's end we submit a fairly detailed collection of files according to the publisher's specifications (most often tables / charts / photos are provided separately, at proper resolutions, with in-text markers to show where a given element should be placed). The publisher's layout gurus then pop things into InDesign (or whatever) to do the actual print-ready layout.

Quote:
At least Microsoft has given options for their software and not forced a subscription model on people. You can still buy outright the core apps.
Office 2016 for Mac is the most recent (and quite probably the last) standalone version of Office that we can expect for macOS. Details.
__________________
* * * * * * * * * * * * * * * * * * * *
The Cuban Revolution as Socialist Human Development Brill Books (Amazon Paperback)
CubaMark is offline   Reply With Quote
Sponsored Links
Advertisement
 
Old Oct 29th, 2020, 06:49 PM   #122
Honourable Citizen
 
CubaMark's Avatar
 
Join Date: Feb 2001
Location: Nova Scotia, Canada
Posts: 17,908
Send a message via AIM to CubaMark
Thread resurrection so I can keep all my dumping on Microsoft Office contained....

I've been working on a chronology of family history, and figured an Excel sheet would make sense.

Off I go, willy-nilly entering names, dates, events, etc., random order, figuring I can just sort by the date column later to get everything lined up.

Nope. Not with Microsoft.

G-D Excel is incapable of handling dates prior to 1900. o_O

There are workarounds, involving VBA scripts, add-ons, blah blah blah.

I just want to do a simple bloody sort. I don't want to have to gain an advanced calculus degree to do so.

Grrrrrrrr......


UPDATE: SoftMaker's PlanMaker (Excel substitute) is likewise afflicted. Sigh.

UPDATE 2: Dammit. Numbers does it too. SEE BELOW

CORRECTION: Numbers will work with pre-1900 dates. For whatever reason, it would not recognize the pre-1900 dates in the spreadsheet imported from Excel, and once re-entered, they now sort properly.

Great! Now I can do what I need to do. But I suspect that if I export to Excel format to share with anyone else in the family, they'll be unable to make any additions to the file and expect it to sort properly in the future.
__________________
* * * * * * * * * * * * * * * * * * * *
The Cuban Revolution as Socialist Human Development Brill Books (Amazon Paperback)

Last edited by CubaMark; Oct 29th, 2020 at 07:29 PM.
CubaMark is offline   Reply With Quote
Old Oct 29th, 2020, 08:48 PM   #123
Rob
Honourable Citizen
 
Rob's Avatar
 
Join Date: Sep 2002
Location: Close to Windsor, Ont.
Posts: 1,769
Dates often cause problems in spreadsheets since there are different formats used in different countries. In the US, the default is month,day,year, but in Canada the default is day,month,year. There is a similar problem with number formats. For example, most of Europe uses decimal points to differentiate thousands, whereas we in Canada/US use commas.

My suggestion to avoid future date issues is to separate the date into separate columns for the month day and year. In that way you just enter a plain number in each column. For sorting, the primary sort will be on the year column, the secondary sort on the month column, at the third sort criteria on the day column.
__________________
Real Macsters don't repair permissions.

Opinions are like toothbrushes. Everybody has one, so there's no need to share. - Red Green
Rob is offline   Reply With Quote
 
Old Oct 30th, 2020, 10:07 AM   #124
Full Citizen
 
Join Date: Jul 2004
Location: Oakville, ON
Posts: 641
Spreadsheet: use separate columns for year, month and day.

Better: use a genealogy software package.

BTW, did you know that calendars were corrected (for miscounted leap years) starting in 1582 with the adoption of the Gregorian calendar in certain countries. Adoption was slow. In the USA in 1752, Wednesday Sep. 2 was followed by Thursday September 14! So the recorded date in different countries could differ for the same day. Wanna blame Excel for that too?

Craig
WCraig is offline   Reply With Quote
Old Oct 30th, 2020, 02:12 PM   #125
Honourable Citizen
 
CubaMark's Avatar
 
Join Date: Feb 2001
Location: Nova Scotia, Canada
Posts: 17,908
Send a message via AIM to CubaMark
Quote:
Originally Posted by Rob View Post
Dates often cause problems in spreadsheets since there are different formats used in different countries. In the US, the default is month,day,year, but in Canada the default is day,month,year. There is a similar problem with number formats. For example, most of Europe uses decimal points to differentiate thousands, whereas we in Canada/US use commas.

My suggestion to avoid future date issues is to separate the date into separate columns for the month day and year. In that way you just enter a plain number in each column. For sorting, the primary sort will be on the year column, the secondary sort on the month column, at the third sort criteria on the day column.
Thanks, Rob.

I'm aware of the different uses of yyyy/mm/dd dd/mm/yyyy mm/dd/yyyy and whatever other variation thereof. I prefer dd/mm/year since it makes sense

My next step if I hadn't found resolution would have been separate columns, but as much as I'm happy to employ workarounds when needed, it bugs me that this doesn't *just work*.
__________________
* * * * * * * * * * * * * * * * * * * *
The Cuban Revolution as Socialist Human Development Brill Books (Amazon Paperback)
CubaMark is offline   Reply With Quote
Old Oct 30th, 2020, 02:14 PM   #126
Honourable Citizen
 
CubaMark's Avatar
 
Join Date: Feb 2001
Location: Nova Scotia, Canada
Posts: 17,908
Send a message via AIM to CubaMark
Quote:
Originally Posted by WCraig View Post
Spreadsheet: use separate columns for year, month and day.

Better: use a genealogy software package.

BTW, did you know that calendars were corrected (for miscounted leap years) starting in 1582 with the adoption of the Gregorian calendar in certain countries. Adoption was slow. In the USA in 1752, Wednesday Sep. 2 was followed by Thursday September 14! So the recorded date in different countries could differ for the same day. Wanna blame Excel for that too?

Craig
My genealogy package of choice is MacFamilyTree

On the matter of the dates - YES! I just came across that bit of historical knowledge. Fascinating that in some places, a ship could have arrived at a port that was still running 11 days behind it's departure from the port of origin, and that some places just skipped a week or so in September. Fascinating!
__________________
* * * * * * * * * * * * * * * * * * * *
The Cuban Revolution as Socialist Human Development Brill Books (Amazon Paperback)
CubaMark is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Office 2011 Goes On Sale Izzy Mac Masters 24 Nov 8th, 2010 10:52 PM
Office 2011 - Importing .PST file from Outlook for WIndows - Problem ehMax Mac Masters 2 Nov 4th, 2010 11:31 PM
Office 2011 cchaynes Anything Mac 10 Oct 1st, 2010 07:28 PM
Anyone try MS Office for Mac 2011? hhk Anything Mac 2 Aug 3rd, 2010 04:40 PM
Office Depot USA Now Carries Apples!!! interact Anything Mac 16 Jul 14th, 2004 11:40 PM


All times are GMT -4. The time now is 11:47 AM.



Powered by vBulletin® Version 3.8.8
Copyright ©2000 - 2021, vBulletin Solutions, Inc.
vBulletin Security provided by vBSecurity v2.2.2 (Pro) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
Copyright 1999 - 2012, ehMac.ca All rights reserved. ehMac is not affiliated with Apple Inc. Mac, iPod, iTunes, iPhone, Apple TV are trademarks of Apple Inc. Content Relevant URLs by vBSEO 3.6.0 RC 2

Tribe.ca: Urban living in Toronto!