

You can access this window also from the Page Preview by clicking on the last icon of the Toolbar. The size of the sheets will be adjusted to fit that number. There are features that formulas can depend upon that are not provided in the ODF Text Document schema. If AutoCalculate is enabled, the Recalculate command applies only to formulas like RAND or NOW. Fit printout on number of pages allows you to determine the exact number of pages on which the spreadsheet will be printed.

Id like to have a separate column, in which every cell shows a number of characters written in the corresponding cells.) macros selection openoffice-writer. Doing Tools / Word Count every few minutes is very cumbersome. A significant part of the OpenFormula definition depends on there being a workbook within which the formula occurs. The goal is to fill the cells with text that has to have specific number of characters. (Technically, the ODF specification permits formulas in table cells directly, but it would be non-trivial to implement that and all implementations would need to do it in an interoperable way. There might be some complex formatting of a Writer table cell that has to be done differently in Calc.)

(E.g., cross-references and bookmarks probably won't work between the embedded object and the containing Writer document. There might be some feature of a direct OpenOffice Writer table that can't be obtained the way you want. You'll need to use other features of Calc to format cell borders, etc., and control what is shown in the spreadsheet. You will need to fuss a bit to have it appear as just the table with no row and column titles, etc., and you might want to protect it in the final document unless you want recipients to be able to alter it. Inserting an OpenOffice Spreadsheet, etc., is called-out as a special case in the "Insert OLE Object" dialog. Menu options (with Create new) for inserting an embedded OLE Object. You should be able to edit it from within Writer too. What you can do is make the table in OpenOffice Calc and embed it in the Writer document. There is no direct provision for formulas in table cells in OpenOffice Writer.
