Dear all,
<snip>
I have no problem to create this with Writer but has problem when using spreadsheet. Because say the "Particulars" column is at cell A1, then I cannot have the received By . prepared by , checked by or Approved By columns (of the second table) to aligh right below the upper table. This is because cell A1 has been set to the size for the "Particulars" column (in the upper table), if the "received by" column (of the bottom table) is aligned under the A column then it has to follow the cell width of the above cell (which is A1 for particulars column).
My question is, is there no way to create tables as above in one page one above the other? If yes I couldn't figure out how and anyone knows please teach me. Sorry my explanation might be very complicated, anyone who understand my problem, please help me. Thanks a lot for reading my question,
Regards Fong
Hi!
I think I understand what you are trying to do. You want different cell width in the same column in different rows, right? Unfortunately that's impossible (no matter if you use OpenOffice Calc, MS Excel or any other spreadsheet software, I suppose), but there are a few "workarounds" that I can thing of, of which a few you might not like:
1. Use many small columns and group as many cells as necessary to achieve the wanted cell width. If you need to change the width of a cell, which might be 5 cells grouped together, ungroup them and then group the first of them with one more cell so they will be a group of 6 cells...
2. Just don't have two tables on the same sheet, one above the other. If you want them on the same sheet, have one to the left and one to the right.
3. Use different sheets for the two different tables. There is a sheet tab down to the left of the sheet. Right click the tab and you can create more sheets, remove sheets, rename sheets and so on.
Actually, right now when I opened a spreadsheet and looked around in the menues I found something I never thought of before. In the Window menu in Excel there are (if I remember Excel correctly) options like "Tile horisontally" and "Tile vertically", but those don't exist in OOo Calc! This would be very useful in your case, wouldn't it? Then you could see the two different tables at the same time, one above the other...
If you want to print the two tables out on the same page I suppose my first solution is the one, unless someone else replies with a better idea. Personally, if I use two different sheets and want them on the same page when printing out, I use a printer software called FinePrint, which is free if you can stand the fact that every printed page contains a "footer" looking like this: "Printed with FinePrint - purchase at www.fineprint.com". I also found a bug in it which I reported, but their final response was that they will not fix it. Maybe there are software out there doing the same thing but real freeware?
I guess I didn't answer your question completely, but I tried to the best I can.
Johnny
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
