Issue 123801 - Calc formatted field not connecting to Base
Summary: Calc formatted field not connecting to Base
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: 4.0.1
Hardware: All All
: P3 Normal with 2 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: needhelp
Depends on:
Reported: 2013-12-02 21:24 UTC by ginny.r.brock
Modified: 2014-02-24 19:11 UTC (History)
2 users (show)

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

Calc file for bug demonstration. Must be connected to a Base file. (23.33 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-12-02 21:24 UTC, ginny.r.brock
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description ginny.r.brock 2013-12-02 21:24:39 UTC
Created attachment 82031 [details]
Calc file for bug demonstration.  Must be connected to a Base file.

Under specific conditions, a formatted field or text box in a Calc stand-alone form will not connect to Base when first opening Calc.  Going into and then out of edit mode will fix the connection.

The bug happens when the formatted field is on a tab other than the first (left-most) tab.  The bug happens when in "Page Break Preview" view (it does not happen in "Normal" view).  The bug happens when the file was last saved when viewing the non-first (non-leftmost) tab.

Because this is a connection bug, it needs two files to be demonstrated. For use with the attached Calc file, create a Base file named BugTestDatabase with one table named Data.  Create two columns, one named ID (auto-integer) and one named Num (integer).  Enter one row of data.  Make sure the file is registered on the testing computer.

The attached file has two identical tabs.  The refresh buttons are unrelated to the bug and are present for quick identification of when the bug is active.  If the text box does not connect to the Base file, the refresh button will be grayed out.  If the file is saved while viewing the second (right-hand) tab in "Page Break Preview" view, then closed and reopened, the bug will be active (the field will not connect to the base file).  If the file is saved while viewing the first (left-hand) tab, or if it is saved while viewing either tab in "Normal" view, the bug will not occur.
Comment 1 ginny.r.brock 2014-02-24 19:11:26 UTC
I had a file with this bug crash today, with the front tab being the one that triggers the bug.  In the recovered file, the bug was not active.  It seems like something about how files are opened from recovery (no bug) vs. opened normally (bugged) has an effect.