Re: [libreoffice-users] trying (again) to get conditional text to work [solved]

On 2023-10-03 11:55, Gary Dale wrote:
> I'm running LibreOffice Writer 7.5.6.2 on a Debian/Trixie system.
>
> I'm driving certificate production from a database (spreadsheet). I'm 
> trying to get a simple text replacement to work. The field is type 
> "Conditional Text".
>
> The condition is [Fun-Run-2023].[Race-17799-final].sex EQ "F" - where 
> the first bit in [] is the database name and the second bit in [] is 
> both the spreadsheet's name and the sheet's name (when I'm in Base, it 
> shows as the table name).
>
> The "Then" & "Else" are defined to do the obvious substitutions except 
> I always get the "Then" branch and never the "Else".
>
> I could just do the substitution in the spreadsheet, but I have other 
> things I need to make conditional as well.
>
> Can anyone identify what I'm doing wrong?
>
> Thanks.
I got it to work by renaming the database to "Fun_Run_2023" and the data 
sheet to "final". Apparently Writer doesn't (currently?) respect the [] 
characters.

--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy