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

Reply via email to