Re: [libreoffice-users] LO Base report Auto Grow function

I have not tested, but would suspect it is evaluating the length of the
formula rather then the length of the content the formula produces.

If your data source is a query it should be possible to produce the
string you want in the query, then just reference the field instead of
using a formula.

I mainly work with PostgreSQL, not sure if this exact syntax and
functions are available in Base (hsqldb) but your formula in SQL would
start something like this:

"Ort1" || COALESCE(CHR(10) || CHR(13) || NULLIF("Ort2", ''), '')
|| COALESCE(CHR(10) || CHR(13) || NULLIF("Ort3", ''), '')
...


On 10/30/24 07:57, Harvey Nimmo wrote:
> I have a report field that contains the following data Value
>
> =[Ort1]&IF(NOT(ISBLANK([Ort2]));UNICHAR(13)&UNICHAR(10)&[Ort2];"")&IF(N
> OT(ISBLANK([Ort3]));UNICHAR(13)&UNICHAR(10)&[Ort3];"")&IF(NOT(ISBLANK([
> Staat]));UNICHAR(13)&UNICHAR(10)&[Staat];"")
>
> As the field from the attached database query may have anything from 2
> to 5 lines of text, I would like to use the function Auto Grow. There
> is enough free room below the report field for the maximum line number.
>
> 'Auto Grow = Yes' is accepted and apparently saved without objection on
> exiting edit. But on generating the report, the field is not autogrown.
> And the setting has returned to 'Auto Grow = No'.
>
> I want to use autogrow to optimise the use of paper space. The thought
> occurs to me that, for Auto Grow to make more sense, the report
> sections, in particular the Detail section, should also have
> autogrow/(autoshrink?) settings.
>
> For the moment, is there a way to Autogrow my field, or am I obliged to
> set the field to the maximum available?
>
> Cheers
> Harvey

--
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