Created attachment 57607 [details] Report shows both phone numbers printed. Problem description: Report Displays a Number incorrectly if formatted as 'number' but correctly if format described as 'text' Steps to reproduce: 1. .... Database from an Excel file contains 11 digit phone numbers 2. .... Query shows all 3. .... Report showing slots configured as Number and Text show differences. There is no warning given is this is the corrct behaviour resulting in report showing last three digits of phone number incorrectly/ See attached database Table1 Query1 and Report1 Current behavior: Expected behavior: Platform (if different from the browser): Browser: Chrome
Thanks for bugreport Please, verify if in last version of LibreOffice still reproducible And if reproducible, please attach screenshot where number shown correct and another where number is wrong.
Your phone-number is formated as VARCHAR in the table. What should the report do with that formatted as number? I have changed the query in your database: SELECT "TOWN", "POSTCODE", CONVERT ( "TELEPHONE" , INTEGER ) AS "Number", "TELEPHONE" FROM "Table1" ... and then linked it to the report. the filed "Number" is correctly shown in a number-format.
As per comment 2. Do not hesitate to reopen in case of mistriage.