Bug Fixes (part 2 of the unfixed ones)
Part 2 of my list of unfixed bugs
WORKDAY with exclude dates gives erroneous results
WORKDAY(date, work-days, exclude-dates) when there are "exclude-dates" gives erroneous results. It will skip over perfectly valid workdays if "date" is an exclude date and "work-days" is +/-1. For instance if the exclude date is Tuesday, it will say the previous workday was Friday, not Monday. The problem may go deeper than that, this is the only test I did. Excel gets it right. I did not write down when this bug was first noticed but my spreadsheet is using dates in May 2021. I know for sure it has been around since before April 2022.
Borders not displaying or printing correctly
This is two related bugs. To see it, make all cells and all borders black. De-select the table and it should be all black, but it is not. If the border are less than 1pt it will have white borders around cells (bug 1). Change it so there are no borders in the entire table. Now it will be black on the screen but if you print it it will have faint white borders around all cells (bug 2). The only way for it to be black on the screen and black when printed is for the borders to be 1 pt or larger.
MATCH not searching in the correct direction
I have been reporting on a bug with MATCH (with the default matching method ) where it appeared to be doing a bottom to top search in some cases when the documentation says it should be doing a top to bottom search (and Excel does it top to bottom). Excel documentation says the table must be sorted in ascending order. The table I was using was not. So I can no longer say it is a “bug” but it does give different results from Excel.
INDIRECT does not update its result on a categorized table when the table is sorted
If INDIRECT is used to refer to a specific cell in a categorized table and then, later, the table is sorted, the result of the INDIRECT function does not update to give the new value at that cell. It keeps displaying the previous value. The table has to be un-categorized to make it update. This was first reported in April.
Wrapped text generated by a pop up menu or formula may cause tables to overlap
Typically if a table is directly below another table, if the upper table expands vertically because of an increased row height, the lower table moves downward to accommodate it. But if that cell height change is the result of a pop up menu item or a formula (by creating text that wraps to multiple lines), the table below does not move. This was reported this month so no expectation it would have been fixed now.
Printing of multi-page sheets does not render properly
If a sheet has a long table that requires multiple pages to print and if there is a table directly below it, the two tables may overlap on the printed page. Numbers appears to misplace/miscount some vertical space each page so the overlap gets larger proportionate to the number of pages.
This was reported in April of this year.
