2015-07-30 03:55:19 +0100 answered a question won't print portrait When calling printing service (Ctrl-P) did you click the "property" button for choosing ? If so and doesn't work try to increase the printing scale (reducing the percent of scale factor) 2015-07-30 03:50:41 +0100 answered a question How do I open large (400 MB) .xls file in Calc? Try to reduce the size of your file (check if all macros and colourations are necessary) try to transfer the content in a new Excel document (sometimes you can have an important weight gain). Good luck 2015-07-30 03:44:44 +0100 answered a question How do I add a column to my database? a simple way, if you use a form to fill the field, is you just make a new table with a single column where you put only a field "yes" and a field "no" and close it. Edit your form, separate the field name from the label (ctrl-click, then "delete") and with a button "create a list zone" on your left, vertical Menu zone, indicate the table you just have created (choosing in the "control" window you access by right-clicking) and take the opportunity to set size and colour of the font, and eventually the background and all you want to set-up. 2015-07-30 03:30:28 +0100 answered a question Writer and Impress were often stucked If always happens with the same documents, just transfer the content in new documents and save with a different name. Then delete the originals and rename new documents as you want. 2015-07-30 03:26:46 +0100 answered a question How do I refer to a cell, address from ROW and COLUMN functions very simple : you just set (for example if the cells are c4 and h9) if ( c4=h9 ; yourexpression ; otherexpression ) or if you prefer if ( $c$4=$h$9 ; yourexpression ; otherexpression) 2015-07-30 03:12:13 +0100 answered a question Move a page to another document? In Calc right-click on the tab name and in the context Menu chose Move/Copy Then a small window comes with 3 zones. If you have several tabs the 1st zone allows you to chose between Move an Copy, the 2nd one to chose the destination place with a scrollable Menu that includes "New Document" and in the 3rd zone you can rename the sheet. 2015-07-30 02:51:36 +0100 answered a question Why, in French, does the combo of functions SI(EXACT(cell1,text);cell2;cell3) returns a boolean instead of cell2 or cell3? In French you find "boolean value" as "Valeur logique" in the column "Catégories" of the tab "Nombres" 2015-07-30 02:41:15 +0100 answered a question Enter date range in base query You just put as criteria "Between "+first date + " and " + second date