Created attachment 38172 [details] cells overprints Hi, I use apache poi tu generate an xlsx file. When I open this file with Excel, a strange behaviour appears. I have a cell containing a formula. The formula references others cells in the same sheet. When I update these other cells, the formula updates itself, but overprints the new value on the previous. If I change sheet or scroll in order to not see anymire the cell and then returns, the cell display correctly. If I copy paste the sheet in a new Excel file, the problem disappears. So I think there is a bug in the generated file from Apache POI.
Can you provide a reproducible test case?
It seems that playing with borders makes appear displaying bugs. When I removed all the borders, I have no more problem like overprint. According to sheets creation order in the workbook, borders appear or not. It is very strange. To avoid some bugs, I do not use anymore RegionUtil to create borders on a range. In place of, I set border style on each cell ... and it' boring but it works better.