fre 2011-04-22 klockan 12:50 -0500 skrev Seb: > On Sat, 16 Apr 2011 07:46:29 +0200, > "Simone Krais" <simone.kr...@gmx.net> wrote: > > > Dear openoffice team, I am trying to establish an open office database > > for my work as an anthropologist. I need tables with the size of > > around 300 columns (data fields). It would be very complicated to > > spread it into multiple tables since the data is to be evaluated all > > together. But with the size of 128 columns I can not go on. What is > > the problem? Can you help me?
Yes, upgrade your OpenOffice.org. Recent version of OpenOffice.org Calc has 2¹⁰ columns (1 024): A-AMJ. Also the number of rows is increased from 2¹⁶ (65 536) to 2²⁰ (1 048 576). > > I'd seriously reconsider the database design *very* carefully; 300 > fields in a table rarely makes sense. It will pay off in the long run. > There's plenty of books out there. A very good one is: Database Design > for Mere Mortals by Mike Hernandez. > Good point. > > -- > Seb > -- Best regards Johnny Rosenberg -- ----------------------------------------------------------------- To unsubscribe send email to discuss-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help