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: [email protected]
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