Apache OpenOffice (AOO) Bugzilla – Issue 15638
database, hidden cells, can't actuallice, mail-merge
Last modified: 2006-05-31 14:29:06 UTC
Hello *, there are 3 bugs in the versions I use (1.0.1, 1.0.3.1 and 1.1.beta2) : 1) I create a table-document like a b c 1 2 3 4 5 6 d-1 d-2 d-3 d-4 d-5 d-6 format all cells as text and make from this documet a database-source. Looking at this database with F4, I can only see the column-heads(a,b,c) and the numbers (1-6) but not the cells with d-(1:6). The boarders of the 6 cells are shown, but the cells are emty. If I make the table-document like the one above but insert a new row like a b c d-1 d-2 d-3 1 2 3 4 5 6 d-1 d-2 d-3 d-4 d-5 d-6 then all cells are shown correctly. Interesstingly is, I formated all cells as text in the original document but in the first (and false) example the cells in the database where formated as numbers. But even if I change the format to text in the database I'm not able to see the last 6 cells. 2) I'm not able to actuallice my database until I delete it and make a new one. If I create a database from test.sxc, after that I make some changes to test.sxc and save it with the same name, the datebase has the old content even if I press the actuallice-button. Where does ooo.o stores the old content? So I have to delete the database and make a new one with the same file to see the changed cells. I think this is a bug, because no one has a static database. Every database is changeing and if a database-source is linked to a file then the database has to be the same content as the file and not an old content saved anythere. 3) If I make a document with a mail-merge and connect it to a database, go to an other computer then I couldn't open the document with the correct content until I made a database with the same name as on the first computer. Wouldn't it be much better to save all informations about a document in the document, so that we are able to work with the document on separate computer without frustration because on some computers aren't the databases open or if they are open then may be with an other name. I mean if a letter has a mail-merge with adress.sxc than this infomation has to be in the document. About the OS: we are using WinXP, Win2000 and Win98. On Win98 a team-member told me, that if he want to make a mail-merge, ooo.o closes with a runtime-error. With best regards Marcus Daub
clu->marcusdaub: dear marcus, thank you for this task but it would be nice if you could write a task for every case you find (in present state we can't really work with your description) 1. (no bug) text databases have no real cell format - the first value will be taken for the field as format - so mixed fields are problematic - if they are shown corecctly it only means that the field format is f.e. text and a number is also shown as a 'text' CLU: text database format is really restricted so that i would suggest you to take a little bit more confortable format like dBase if you are not bound to text databases and you don't want to take a 'real' database instead of a database format (you can also save spreadsheets in dBase format;) 2. (bug) please make a seperate bug of this 3. (this is an enhancement not a bug) you are right, that the connection settings should be saved in the document - please write an enhancement for that 4. (not repro) the problem with the runtime error is not reproducible without a step by step description - so if you can reproduce it, please write a seperate complete bug thank you for your effort
this discription closed -> waiting for resulting tasks
I confirm part 2 of this bug, and created bug 16798 for it with further information.
change subcomponent to 'none'