OogieM wrote: . . . Looked at the font used and it's a font that is only in MS Office. I do not have MS software installed on my system so I don't have that font. I use Open office which is a free replacement for MS Office. OO can open, read and save Excel files. . .
Judy Lewman wrote:[the spreadsheet's refusal to accept your dates as entered (noted in Part 2) is especially bizzare.
OogieM wrote:Been meaning to come back in and update this.
The issue with dates is that My original sheep spreadsheet data was using the original Macintosh start date for dates of 01/02/1904 with proper calculation of leap years. My spreadsheet originated on a Mac Excel system from sometime in 1995 or so. I believe it was originally Excel 5.0. When I converted it to Libre Office back in 2000 I converted to the standard Linux start date of 12/30/1899 as that was the default. The spreadsheet from LambPlan uses the Windows start date of 01/01/1900
Until you get all of them in the same universe, dates will not copy and paste correctly.
Libre Office has an option under Preferences, Calc Calculate to set the start date.
Users browsing this forum: No registered users and 2 guests