https://bugs.documentfoundation.org/show_bug.cgi?id=92981
--- Comment #13 from ady <adylo811...@gmail.com> --- I'm not sure the problem has something to do with un-matching brackets. The problem seems more related to either "uncommon" characters in named ranges and in the worksheet name (which perhaps used to have a space or some other special character in its name?), or related to formulas depending on named ranges. Every cell showing Err:508 depends on a named range. Note that cell B2 is named Taux and it has no error. Note that cell B1 is named Montant_du_prêt and it has no error. Neither of these depend on other named ranges. In contrast, B4 is named Mensualité and depends on Taux. B7 depends on it, and B9 depends on B7. The range B12:E12 also depend on these named ranges. Then B13:E13 and down are just a drag copy of B12:E12. Once you solve the "errors" in B4 and B12:D12 (by re-typing the last character in each), the rest is OK. Re-saving at that point solves the problem for the next time you open the file. I don't really know what these named ranges (or the names themselves) have so special that trigger this problem. If this hunch is relevant, the title/subject of this bug report should be modified, because unmatched brackets seems not to be the issue, but rather some kind of importing problem from xls regarding named ranges (and/or special characters in worksheet names?). -- You are receiving this mail because: You are the assignee for the bug.
