[Libreoffice-bugs] [Bug 122378] conditional formatting with formula is VLOOKUP(C14, Region, 1, 0) is VLOOKUP(C14, #NAME?, 1, 0)

2019-08-09 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=122378 Xisco Faulí changed: What|Removed |Added Status|UNCONFIRMED |RESOLVED Resolution|---

[Libreoffice-bugs] [Bug 122378] conditional formatting with formula is VLOOKUP(C14, Region, 1, 0) is VLOOKUP(C14, #NAME?, 1, 0)

2019-07-08 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=122378 --- Comment #10 from Oliver Brinzing --- (In reply to Xisco Faulí from comment #9) > Do you think this is a valid bug ? i think if: > ThisWorkbook.Names("Region").RefersTo = "=Input!$B$4:$C$23" will keep the formula valid (still

[Libreoffice-bugs] [Bug 122378] conditional formatting with formula is VLOOKUP(C14, Region, 1, 0) is VLOOKUP(C14, #NAME?, 1, 0)

2019-07-08 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=122378 --- Comment #9 from Xisco Faulí --- (In reply to Oliver Brinzing from comment #8) > (In reply to Heinrich Padrutt from comment #7) > > Please enplane in more detail this and how to use lo api using my example. > > you can for - example

[Libreoffice-bugs] [Bug 122378] conditional formatting with formula is VLOOKUP(C14, Region, 1, 0) is VLOOKUP(C14, #NAME?, 1, 0)

2019-01-07 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=122378 Roman Kuznetsov <79045_79...@mail.ru> changed: What|Removed |Added Blocks||87351,

[Libreoffice-bugs] [Bug 122378] conditional formatting with formula is VLOOKUP(C14, Region, 1, 0) is VLOOKUP(C14, #NAME?, 1, 0)

2019-01-02 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=122378 --- Comment #8 from Oliver Brinzing --- (In reply to Heinrich Padrutt from comment #7) > Please enplane in more detail this and how to use lo api using my example. you can for - example change - the macro code like this: If ChRange =

[Libreoffice-bugs] [Bug 122378] conditional formatting with formula is VLOOKUP(C14, Region, 1, 0) is VLOOKUP(C14, #NAME?, 1, 0)

2019-01-02 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=122378 Oliver Brinzing changed: What|Removed |Added See Also||https://bugs.documentfounda

[Libreoffice-bugs] [Bug 122378] conditional formatting with formula is VLOOKUP(C14, Region, 1, 0) is VLOOKUP(C14, #NAME?, 1, 0)

2019-01-01 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=122378 Xisco Faulí changed: What|Removed |Added Assignee|hpadr...@ggaweb.ch |libreoffice-b...@lists.free

[Libreoffice-bugs] [Bug 122378] conditional formatting with formula is VLOOKUP(C14, Region, 1, 0) is VLOOKUP(C14, #NAME?, 1, 0)

2018-12-30 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=122378 Heinrich Padrutt changed: What|Removed |Added Assignee|libreoffice-b...@lists.free |hpadr...@ggaweb.ch

[Libreoffice-bugs] [Bug 122378] conditional formatting with formula is VLOOKUP(C14, Region, 1, 0) is VLOOKUP(C14, #NAME?, 1, 0)

2018-12-30 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=122378 Oliver Brinzing changed: What|Removed |Added Ever confirmed|0 |1 CC|