Bug Fixes - I think one was fixed

Here are the lists of fixed and not fixed bugs that I have been keeping track of.

Fixed (I think):

Copy Style Paste Style with “no fill” background does not turn destination cell to “no fill”

If the source cell has no background fill, this property does not get written to the destination cell. The destination cell will keep its existing color. This was reported recently and has been fixed in version 13.1, unless I am doing something different than what I remember this was about.

Not fixed (part 1):

Sorting tables that have COUNTIF formulas

Still a huge glaring bug. Sorting still mangles the cell references and causes error triangles (reference errors). We are at the THREE YEAR mark on this one. Lots of new features since then but they still don't seem to care about this glaring bug in the app.

The calculation engine gives incorrect results when doing repetitive calculations with small numbers.

The results go haywire as compared to Excel and Matlab, which agree with each other. Numbers probably gave correct results prior to the new engine, which was new to version 10 (?). The new engine strayed away from the gold standard of IEEE 754 that we proudly touted in the forum back then as one of its features, even though it sometimes gave results people didn't like (like 1E-17 instead of 0 when adding and subtracting decimal numbers). I suppose in the attempt to meet customer expectations they started massaging the results but I think they went overboard. Correct mathematical calculations are the most important requirement for a spreadsheet app and it is failing that requirement.

Erroneous value labels on charts

If a chart is displaying value labels and the first or last Y data point in the series is a blank cell, it will put a value label on the X axis for that non-existent point as if the point was a zero. This is most annoying when using "series name" value labels. Other blank cells do not get value labels, just the first and last ones. I don't know when it started but it was at least a year ago. Plotting a second series with only a single data point and with Series Name value labels is a way to highlight and label a specific point on a chart but it is useless with this bug.

SUMIFS with dates gives incorrect results in certain regions

The result of SUMIFS, when dates are the conditions, may change if the file region is changed. I only tested this with Canada vs US because that was the original poster's problem. If the spreadsheet is designed in the US then the region changed to Canada, the results change. This bug was in version 11.2, maybe earlier.

TEXTJOIN not ignoring empty cells when it is supposed to

TEXTJOIN when joining a range that has empty cells will not ignore the empty cells, except for the first cell in the range. When using a separator, it results in repeated separators in the list of words (such as One,,Three,Four). This bug was present when TEXTJOIN was released.

CONCAT and TEXTJOIN can be used to create a “blank” cell

CONCAT and TEXTJOIN can both be used to create a "blank" cell, one where ISBLANK returns TRUE even though the cell obviously has a formula in it. Whether this is a bug or an undocumented feature is debatable.

Chart sometimes displays the trendline equation as Y=0

There are cases where a chart will not show the correct trendline equation. The trendline equation simply says Y=0. The trendline is plotted on the chart but the equation Numbers provides is simply Y=0. The actual trendline can be calculated in a table; it does exist. This was first noticed in January 2023.