Re: [libreoffice-users] Templates not linked in Writer after update to Xubuntu 18.04

2018-11-10 Thread Regina Henschel
Hi, Wiebe van der Worp schrieb am 10-Nov-18 um 20:10: After updating to Xubuntu 18.04 I was quite surprised to find out that ott templates are not linked to documents any more. It might be, that now the templates are not where the document expects it. The information about the template is in

[libreoffice-users] Templates not linked in Writer after update to Xubuntu 18.04

2018-11-10 Thread Wiebe van der Worp
After updating to Xubuntu 18.04 I was quite surprised to find out that ott templates are not linked to documents any more. Trying to solve this, I found out "Template Changer" is broken. Now I am trying to downgrade LibreOffice, but that fails because template changer (1.2.7d) / LO crashes

Re: [libreoffice-users] Calc 6.0.6.2 IF criteria statement help

2018-11-10 Thread Remy Gauthier
Hi, I believe you had a similar (if not identical question) which you posted back on September 27th (topic: IF doesn't respect AND - http://d ocument-foundation-mail-archive.969070.n3.nabble.com/IF-doesn-t- respect-AND-td4249584.html). At the time you had uploaded a file to Google and I had

Re: [libreoffice-users] Calc 6.0.6.2 IF criteria statement help

2018-11-10 Thread Michael H
I'm not sure I follow your logic, but if your source range contains a list of values that includes nulls, and non-numbers, you need to logically exclude those from a math statement, or you get the 'VALUE' error (tried to do math on a non-numeric cell.) ISBLANK, and ISNUMBER are functions that

[libreoffice-users] Calc 6.0.6.2 IF criteria statement help

2018-11-10 Thread Hylton Conacher (ZR1HPC)
Hi, What I need help with is the formula to find any row from Data.$A$3 to Data$A$1000 and after shortening the 8 digit date value to 6 digit value, and having the same 6 digit value as Summary.$A4, forward ONLY those rows onto the next part of the formula i.e. SUMIF. I have a formula shown