https://bugs.documentfoundation.org/show_bug.cgi?id=158072
Bug ID: 158072
Summary: Fails to apply filter on mail merge (Writer+Calc)
Product: LibreOffice
Version: 7.6.2.1 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: LibreOffice
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: cardholm2...@yahoo.se
Description:
Premise:
I have a Writer document with data from a Calc spreadsheet linked through
database fields (using mail merge function). When I want to print, LO correctly
asks "Your document contains address database fields. Do you want to print a
form?". I confirm YES and the proper Mail Merge Dialogue comes up.
(a) However, when I try to apply Standard Filter, "field name" drop-down only
states "empty" and nothing else can be selected (all other parts greyed out).
(b) If I instead try to apply AutoFilter, LO states "Error setting the filter
criteria. The column is not searchable!". I can then select MORE or OK
(buttons). As I select MORE I get "Error details" with two errors: "Error
setting the filter criteria" and "SQL Status: 01000 / Error code: 1000 / The
column is not searchable!" (here I can only click OK)
It has been tested and repeated multiple times with the same result. The two
files are stored in the same folder and are standard .ODT and .ODS. I have no
issues with any other of the functions of mail merge (i.e. I have different
database fields selected and shown where and when they should, so links seem to
work)
Steps to Reproduce:
1.Create a Calc ODS with three columns and 3 rows:
----------------
COL1---COL2-COL3
Adam---1----X
Bertil-2----Y
Ceasar-2----Z
----------------
2. Create a Writer ODT and insert field - more fields... - mail merge fields
(select the ODS) - Sheet 1 - COL1 (repeat for COL2 and COL3)
3. Select Print in Writer
4. Select YES as response to "Your document contains address database fields.
Do you want to print a form?"
5. Try to Apply filter (=fails)
Actual Results:
(a) If applying Standard Filter, "field name" drop-down only states "empty" and
nothing else can be selected (all other parts greyed out).
(b) If applying AutoFilter, LO states "Error setting the filter criteria. The
column is not searchable!"
Expected Results:
Able to select filter conditions to print (as mail merge) only those database
records that match the criteria of the filter conditions.
Reproducible: Always
User Profile Reset: Yes
Additional Info:
Version: 7.6.2.1 (X86_64) / LibreOffice Community
Build ID: 56f7684011345957bbf33a7ee678afaf4d2ba333
CPU threads: 8; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win
Locale: da-DK (da_DK); UI: en-US
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
