Bug 107500 - Database/merge fields displaying numeric content only is shown with different font
Summary: Database/merge fields displaying numeric content only is shown with different...
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Writer (show other bugs)
Version:
(earliest affected)
5.4.0.0.alpha0+
Hardware: x86-64 (AMD64) Linux (All)
: medium major
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisected, regression
Depends on:
Blocks:
 
Reported: 2017-04-28 09:45 UTC by Cor Nouws
Modified: 2018-09-23 08:38 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
test file with description, merge fields, screen prints (29.56 KB, application/vnd.oasis.opendocument.text)
2017-04-28 09:47 UTC, Cor Nouws
Details
spreadsheet used to create datasource (12.01 KB, application/vnd.oasis.opendocument.spreadsheet)
2017-04-28 09:47 UTC, Cor Nouws
Details
datasource from spreadsheet (1.75 KB, application/vnd.oasis.opendocument.database)
2017-04-28 09:49 UTC, Cor Nouws
Details
bibisect in daily Linux dbgutil bibisect repository (2.47 KB, text/plain)
2017-05-11 02:00 UTC, Terrence Enger
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Cor Nouws 2017-04-28 09:45:51 UTC
[I'll attach test files after initial description]

How to reproduce
1. Use file testData_3SheetsWithEmail.ods
2. Create and register datasource <testData_3SheetsWithEmail.odb>
3. Create new Writer document
4. Open datasource window, and open  testData_3SheetsWithEmail.shortlist
5. Drag the following fields to the writer file: Name, Number, Postal code, Phone, Getal_StdOpmaak, Getal_GetalOpmaak
 Note that in the initial situation (see screen print below) all the fields have the same formatting.
6. Now select row 1 and click Data to Fields
Note that fields Phone and Getal_* are displayed larger
7. Now select row 2 and click Data to Fields
Note that also field Number is displayed larger. (content is now 23, was 123 b)
  >> All field only showing numbers, display larger
Comment 1 Cor Nouws 2017-04-28 09:47:06 UTC
Created attachment 132926 [details]
test file with description, merge fields, screen prints
Comment 2 Cor Nouws 2017-04-28 09:47:41 UTC
Created attachment 132927 [details]
spreadsheet used to create datasource
Comment 3 Cor Nouws 2017-04-28 09:49:21 UTC
Created attachment 132928 [details]
datasource from spreadsheet

can maybe used, if placed in same folder as spreadsheet
(I didn't check setting relative/absolute paths)
If so, opening the Writer file, immediately gives the fields needed to test.
Comment 4 Cor Nouws 2017-04-28 09:52:53 UTC
tested in Version: 5.4.0.0.alpha0+
Build ID: 74ccd02eda2d6325a27266fd935aba29b3d75020
CPU threads: 4; OS: Linux 4.10; UI render: default; VCL: gtk2; 
TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2017-04-27_23:51:14
Locale: nl-NL (nl_NL.UTF-8); Calc: group


Was OK in Version: 5.4.0.0.alpha0+
Build ID: b0026125ab60d98cf6705e5d89e2f87575b5d337
CPU threads: 4; OS: Linux 4.10; UI render: default; VCL: gtk2; 
TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2017-03-21_01:15:06
Locale: nl-NL (nl_NL.UTF-8); Calc: group
Comment 5 Buovjaga 2017-04-29 18:58:55 UTC
Repro.

"Larger" meaning that the font is different (Sans instead of Serif).

Arch Linux 64-bit, KDE Plasma 5
Version: 5.4.0.0.alpha0+
Build ID: 9348b322a5c230dfcc2231661b73e480b130fcd9
CPU threads: 8; OS: Linux 4.10; UI render: default; VCL: kde4; 
Locale: fi-FI (fi_FI.UTF-8); Calc: group
Built on April 28th 2016
Comment 6 Cor Nouws 2017-04-29 20:00:45 UTC
thanks for confirming.
Now in my situation I'm not able to adapt the field to the desired font. So that is looking rather ugly, unprofessional, in merged files.. (hint for the severity 'minor' ;) )
Comment 7 Cor Nouws 2017-04-30 19:32:49 UTC
let me raise this one...

 - It turns out that also existing files with the fields have the same problem;
 - It is impossible to correct the problem in the file

NB it is a recent problem. OK in Version: 5.4.0.0.alpha0+
Build ID: 2f5baab8498ce1303dded8aa7e16adbf80341c39
CPU threads: 4; OS: Linux 4.10; UI render: default; VCL: gtk2; 
TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2017-04-17_23:20:42
Locale: nl-NL (nl_NL.UTF-8); Calc: group
Comment 8 Terrence Enger 2017-05-11 02:00:32 UTC
Created attachment 133226 [details]
bibisect in daily Linux dbgutil bibisect repository
Comment 9 Terrence Enger 2017-05-11 02:01:35 UTC
Working on debian-stretch in the daily Linux dbgutil bibisect
repository, I see that the bug started somewhere in the 8 commits ...

          commit    date        s-h
          --------  ----------  --------
    good  8b7f5c9c  2017-04-27  437105b9
    bad   b8d9ccca  2017-04-28  74ccd02e

For this work, I deemed the version bad equally whether the sans-serif
font shows on the first or on the second data-to-fields.

I am removing keyword bibisectRequest and adding bibisected.
Comment 11 QA Administrators 2018-09-14 02:45:55 UTC Comment hidden (obsolete)
Comment 12 Cor Nouws 2018-09-23 08:38:25 UTC
ah how lovely - issue doesn't exist/show any more in Version: 6.2.0.0.alpha0+
Build ID: 3208fcb3a36d75d6290d9c548430682f153b09db
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk2; 
TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2018-09-20_23:54:32
Locale: nl-NL (nl_NL.UTF-8); Calc: threaded