Apache OpenOffice (AOO) Bugzilla – Issue 52187
Link to Spreadsheet file not working correctly
Last modified: 2017-05-20 10:44:56 UTC
In the following files youhave a simple database linked to a spreadsheet file. Note that the "Contract Nr." field is missing for some records though it is consistent in the spreadsheet file. This ambiguous link is very unpleasant to work with. We cannot rely on this types of join. Please help.
Created attachment 28060 [details] the database used
Created attachment 28061 [details] the spreadsheet from which we wanted to extract the data
fs->nn: for the cell(s) in question (e.g. Z6), getType at the cell returns TEXT as cell type, thus lcl_SetValue in CTable.cxx sets the respective RowSetValue to NULL.
Reset the assignee to the default "issues@openoffice.apache.org".