![]() ![]() ![]() ![]() Opened the file after the suggested recovery, and all the conditional I opened back in Excel, had an error message. It did allow me to do the change for Column A cell A2 and downwards. The file contained several sheets all filled with INDEX/MATCH, SUMPRODUCT/OFFSET functions so at some point Excel did not allow me to even do the simple change for Column A and it was crashing. Than i wanted to change it to:ĬellA2 =rows($A$1:A2)-1 (I had calculations dependent on the value in this cell being a numbering of items). Than numerous other column with complex formulas. The Excel Sheet had in the first column the formulas I had to spend a hell of time, lost several hours fixing it all gain… Once the file opened in MS Excel: conditional formatting that was entered through rules containing formulas was all gone!! Opening back in MS Excel 2016 pro, it gave an error message saying trying to recover information, and the window showed lines about conditional formatting. So i opened in LO Cacl 6.5 and i could finally enter that formula, and save normally. I had an issue with compatibility of LO Calc with MS Excel… Excel was refusing to enter a simple formula in a complex file and crashing.
0 Comments
Leave a Reply. |