From Newsgroup: comp.lang.fortran
Your Name <
YourName@YourISP.com> wrote:
On 2026-04-04 03:40:15 +0000, Lynn McGuire said:
xkcd: Day Counter
https://xkcd.com/3228/
Yes, floating point errors are the bane of my life ! Not so much now
with double precision but the single precision days were nightmares.
Explained at:
https://www.explainxkcd.com/wiki/index.php/3228:_Day_Counter
Whatever you do, do not select âSpace Opera Modeâ in the new mode >> drop down list. "Boat mode" made me a little queasy after a while.
And "modem mode" does not seem to do anything.
Lynn
Yep. It's a problem in Excel (still today!), which is relied on by
almost all businesses, thanks to the idiots at Microsoft not being able
to actually program. I discovered it by accident when I had some cross-checking calucations that said there was an error, when, after
quite a lot of time trying to find the error, turned out to in Excel
itself. :-\
Those of us with brains use Apple computers and the Numbers spreadsheet program does not have this issue.
I encountered the following problem with Excel: if you use Excel’s
Automation API (based on the Microsoft COM framework), you can access everything inside an Excel workbook programmatically. Also any charts that
have been added to a spreadsheet. However, if you‘re trying to iterate through the series of the graph and try to access the formatting of the
series (are there lines between the points of the series, if so which
color, thickness, etc.), you‘ll get an error when you’re accessing a series that is not shown in the legend of the chart because the legend is too
small. If you increase the size of the chart to an ridiculous amount (so
that you can be sure that the legend will be big enough to show every
series of the chart), you can access everything without a problem.
If a program contains such incredible errors, I would keep my fingers from
it. Although I haven’t tried to do the same thing with Open/LibreOffice‘s automation API, I‘d vouch that such an error would not occur.
And yes, us professionals prefer Apple over MS, even though Visual Studio
has some features that I sorely miss in other IDEs.
Regards
Stuart
--- Synchronet 3.21f-Linux NewsLink 1.2