Apache OpenOffice (AOO) Bugzilla – Issue 70611
Spreadsheets need much time if you dont use a Text making row under the db-fieldname
Last modified: 2013-08-07 15:45:17 UTC
If u use normal formatted Spreadsheets as Source, the mail merge wizard need many time to give data record in mail merge fields. If u have a Number column, and in a datarecord is text, the text is not visible. I have a Trick, u must make in the first line under the Fieldnames insert a text to preset the column as Textcolumn. I use the Fieldnames as Text definition line, in my Source spreadsheet are therefore 2 fieldname lines, one for fieldnames and one for column-format. If u have this setted, the mailmerge wizard work so fast like with a txt source. Ill tell u this that u make that this in future nomor essential is to make 2 fieldnamelines in the spreadsheet source for good usability. Regards Matthias Pester
Sorry my english ist bad, in the text before is: line=row Regards
what the first part of the description and the summary explain is rather a feature enhancement than a bug (it could always be faster) -> so i send it further to the feature requirement team for further analyze - to precise it, please attach a sample database and add your measured time and a step by step description for better evaluation - the second part is defined behavior for text/spreadsheet datasources: first row is the header, second row defines the column format thy
Created attachment 40004 [details] Spreadsheet work fast as Sorce
Created attachment 40005 [details] With this one the mail merge wizard need a lot of time to do a data record to the mail merge fields
Created attachment 40006 [details] This is the mail merge document
I attached some files that u can see, it is not a feature, it is a realy bug. With OOO/Staroffice Spreadsheets is it the same, but the OOO/Staroffice database can read excel, it is not needed to make a export to sdc or ods. Step by step: 1. Create 2 new databases with my 2 spreadsheets as source Open my mail merge document and go to "Edit>> Exchange Database and exchange Hauptdatenbank to your databasename>> Tabelle1 Close before the Benutzer-Database she must be ignored. 2. Test both sources with the mail metrge wizard and look which one need much time to do a datarecord to the fields. Look also how mucch time it need for a serialprint. Press cntrl+P and say yes and print some records and confer the Time between the differential datasources. Regards Matthias Pester
is this issue still valid? this issue is pretty old means, does it still happen in a current version?
no repro
no respond -> close do not hesitate to reopen if still occurs in current version thx