To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=96191 Issue #|96191 Summary|.dbf export fails on N,x,0 fields Component|Spreadsheet Version|OOo 3.0 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|save-export Assigned to|spreadsheet Reported by|bormant
------- Additional comments from [EMAIL PROTECTED] Thu Nov 13 16:37:14 +0000 2008 ------- 1. Download and open attached tst.ods OR create new spreadsheet and set A1 to "fld,n,4,0", A2 to "99", A3 to "-99" without quotes. 2. Select from menu File / Save as ..., select file name tst, file type dBASE (.dbf) press Save button, accept warning about format (if occured), accept encoding (doesn't matter). Ok. 3. Set A2 to "9999", A3 to "-999" (without quotes) both or any and repeat step 2. Message box "Error saving the document tst: Connection to the file could not be established." appears. NOTE: After this tst.dbf locked, it's another bug, so change name of dbf when save as .dbf on every another try. Expected behavior: in step 3 file saved without error. Explanation: .dbf field of type N,x,0 can contain numbers from -9((x-1) times) to 9(x times). For ex. N,4,0 can contain numbers from range -999..9999. In other words, dbf integer numeric field with length x can contain integer numbers of length is x, where lenghth is: - number of significant digits for positive numbers - number of significant digits minus 1 for negative numbers. OOo mistakenly believed that .dbf field of type N,x,0 can contain (x-2) significant digits regardless to number sign. So, for .dbf field fld,N,len,0 range of acceptable value is min = - 10^(len - 1) + 1 max = 10^(len) - 1 For ex. fld1,N,5,0: min = -10^(5-1)+1 = -10^4+1 = -10000+1 = -9999 max = 10^(5)-1 = 10^5-1 = 100000-1 = 99999 ps. Sorry for my poor English. --------------------------------------------------------------------- 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]
