https://bugs.freedesktop.org/show_bug.cgi?id=79770
m.a.riosv <mari...@miguelangel.mobi> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEEDINFO |UNCONFIRMED
Ever confirmed|1 |0
--- Comment #5 from m.a.riosv <mari...@miguelangel.mobi> ---
(In reply to comment #4)
> @m.a.riosv:
> 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.
(1) Ok for me, I think they are account names.
> 2) After that, in sheet "Plan", all the cells in B8:C106 contain "Err
> :522".
(2) Ok for me, accounts with their names.
> 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")
Ok, like in (1)
> 2) in sheet "Plan", cells in B8:C106 contain no error (B8="102",
> C8="Report à nouveau (solde créditeur)")
Ok. like in (2) B7="102" C8 ok.
>
> 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.
There is no cell names.
>
> - 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))
Works fine for me.
>
> - 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:
......
> - 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.
Ranges are database ranges Menu/Data/Define ranges
--
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
