To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=74895
------- Additional comments from [EMAIL PROTECTED] Thu Mar 1 23:26:29 +0000 2007 ------- Additional information and sample documents:- This is not just a redraw problem, because (using the full application with the PostgreSQL backend) the second sheet actually contains fully working form controls from both sheet 1 and sheet 2. I'm running these tests on the following system: HW: 2400MHz, 1GB RAM, i686, Tower PC OS: FC6 Linux with current updates installed. JRE: 1.5.0_09 PostgreSQL backend running locally on this machine. The attached ZIP file with included ods plus odb documents are cut-down versions of the application and database used originally, but they still show some of the effects although nowhere near as severe. E.g. switching to the second sheet appears ok. Note: I have also removed all events from the document and forms to avoid calling any macros. I use Zoom = Entire Page (in case that matters for redrawing). 1) Register the included odb as a data source. 2) Open the ods document (should open in edit mode and appear ok). 3) Turn edit mode off to enter run mode. 4) I see the first sheet as shown in the screenshot "Screenshot-eWater_RBA_Application-OOo2.2-Bug (read-only) - OpenOffice.org Calc.png" 5) Switching to the second sheet appears ok. 6) Switching back to the first sheet and re-entering edit mode appears as shown in:- "Screenshot-eWater_RBA_Application-OOo2.2-Bug - OpenOffice.org Calc.png" Additional information re the original issue description -------------------------------------------------------- The original full application connects to a PostgreSQL database via the current version of the PostgreSQL-SDBC driver (0.7.4). If I change the document included in this zip file to use that datasource, I get the original behaviour as described. Possible causes --------------- Because I see a much reduced but still residual effect using the Base HSQL database, the effect doesn't appear to be backend or driver related directly, except that I'm beginning to suspect it may be a timing issue. Because, in the full application, the second sheet contains controls from both sheets 1 and 2 I suspect that, in the cut-down version, the doubled up table control shown in point 4 above may actually be a second instance of the same table control. If you have a POstgreSQL backend available I can probably send you the reduced schema which still shows the full effect. Hope this all helps. Thanks. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
