Issue 128108 - Phantom records in table display view
Summary: Phantom records in table display view
Status: UNCONFIRMED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: 4.1.6
Hardware: PC Windows 7
: P5 (lowest) Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-05-09 19:12 UTC by Charles Schade
Modified: 2019-05-13 00:25 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments
Open table "Accounting" to see issue. (18.44 KB, application/vnd.sun.xml.base)
2019-05-09 19:12 UTC, Charles Schade
no flags Details
Another example of the 40=58 phenomenon (3.55 KB, application/vnd.sun.xml.base)
2019-05-13 00:25 UTC, Charles Schade
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description Charles Schade 2019-05-09 19:12:00 UTC
Created attachment 86678 [details]
Open table "Accounting" to see issue.

Please see https://forum.openoffice.org/en/forum/viewtopic.php?f=61&t=97969 for description of problem in detail, verification by another user, and workaround.

When a table is opened for display, phantom lines may appear at the end of the table that are duplicates of lines earlier in the table.  The phantom lines cannot be selected, and aren't actually in the table (confirmed by SQL query).  Similar phantom lines may appear in grid controls on forms.

The problem appears to be sensitive to the number of lines in the underlying table as well as to the size of the display window.  

To the best of my knowledge this is a harmless problem, but annoying.  Because I thought the data table might have been corrupted, I spend a lot of time writing macros to inspect the data and recreate the table, learning in the process that the same issue occurred on any table whether I copied it using the GUI or generated and filled it using SQL.

I'm attaching a database that illustrates the problem.  When the table "Accounting" opens, the record counter says there are 58 records, but the actual table only has 40.  The extra 18 are duplicated at the end of the display.
Comment 1 oooforum (fr) 2019-05-11 16:03:27 UTC
Unable to open table: the connection to the datasource "OneTableTest" could not be established
Comment 2 Charles Schade 2019-05-11 17:07:41 UTC
Don't understand that.  I just tested the table in the attachment (correct name is "Accounting-new" by the way).  The database opens and shows the table as described in the bug report.  This is using Open Office 4.1.6 on Windows 7.  I opened the file I had uploaded with the bug report.
Comment 3 Peter 2019-05-12 06:25:04 UTC
This is strange.

When I open the table I see dublicates from 1-36. The shadow rows that you describe.
But as soon as I press sort, there are only 40 left.
Does this happen on your side too?
Comment 4 Charles Schade 2019-05-12 13:01:05 UTC
(In reply to Peter from comment #3)
> This is strange.
> 
> When I open the table I see dublicates from 1-36. The shadow rows that you
> describe.
> But as soon as I press sort, there are only 40 left.
> Does this happen on your side too?

Never tried it previously, but I get the same result.

That makes you a genius for finding a simple workaround to an annoying problem.  

Thanks,

cps
Comment 5 Peter 2019-05-12 13:21:27 UTC
Okay. How did you create the table account-new.

I think your table is corrupted, from the perspective of OpenOffice. 

Do you access the table with another toll?
Comment 6 Charles Schade 2019-05-13 00:25:54 UTC
Created attachment 86684 [details]
Another example of the 40=58 phenomenon

This file was created from scratch.  I added 40 records by hand and when you open the table, it shows 58 with duplicates.

Add one more record and the problem goes away.