https://bugs.freedesktop.org/show_bug.cgi?id=79770
--- Comment #4 from Miguel <mjul...@free.fr> ---
@m.a.riosv:
It is somewhat different now that I reopen the file.
No need to precise that I must first need to add the file location in the
trusted sources for Basic macros.
Ctrl-Shift-F9 with cursor on Bal/K15 => yes, cell K15 is still OK, but:
1) column G contains all "0"s, this is an error.
2) After that, in sheet "Plan", all the cells in B8:C106 contain "Err :522".
Ctrl-Shift-F9 with cursor on Bal/A1 => K15 is still OK and there are no errors:
1) column G contains French texts (G8="Fonds associatif sans droit de
reprise")
2) in sheet "Plan", cells in B8:C106 contain no error (B8="102", C8="Report à
nouveau (solde créditeur)")
I suspect that there is a problem related to the cell names, let me precise
something:
- The cell range Plan.B7:C106 is named "Plan", and some errors seem to be
tracked down to formulae using this range.
- Some formulae use the name "Plan" and are wrong (value "#N/D") when the
problem happens. For example, cell AD.F9 contains:
=SI(E9="";"";RECHERCHEV(E9;Plan;2;0))
in English probably something like
=IF(E9="","",VLOOKUP(E9,Plan,2,0))
- When I click on Insert / Names / Manage (Ctrl-F3), no name appears, even when
the cells range is selected. However, the name does exist, I can check it by
entering the following formulae:
=ROW(Plan)
=ROWS(Plan)
=COLUMN(Plan)
=COLUMNS(Plan)
=SHEET(Plan)
=SHEETS(Plan)
- I get no improvement when I replace all occurrences of name "Plan" by the
absolute reference "$Plan.$B$7:$C$106"
- However, I cannot remove the name. It has the name of one of the sheets, but
there is also no improvement when I rename the sheet "Plan" to another name.
Thank you for your help.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
