Drop-down form fields import as Input List fields. Like text form fields in operation these display a dialog from which the user can select an option. On export back to Microsoft Office they return to drop-down form fields again. The controls are exported as active controls when there is a Microsoft Office equivalent. As Word does not have the same database functionality of Apache OpenOffice and as the macros are not compatible, it would be very difficult to have one form that works in both environments using standard form controls.
Summary : To work in a shared environment with forms is not easy, but one workaround would be to use other fields like Input field and Input List. A quick and dirty approach in Word for having a different first page like a cover page and then to have the numbering start on the second page but numbered as page 1 is to have a layout of different first page and setting the starting page to be zero.
Unfortunately, on importing such a file into Apache OpenOffice the page number on the second page is 2 instead of 1. To fix this problem in Writer:. On exporting this document back to Word it will work, the only difference being that the document will have a section break at the end of the first page.
Documents created with section breaks like this in Word will work fine importing and exporting with Writer. There is one difference with Word: now there will be a blank page between the cover page and the next page when printed or print previewed.
Summary : For some documents a little work maybe required to fix up the page numbering on importing to Writer. For example, if the fields in the Word document have a format that includes time, then this information is not displayed by default. To include time in the format:.
The following fields are not imported into OpenOffice. Combo boxes, list boxes and checkboxes with links to spreadsheet cells all import and export properly, although due to font handling the number of rows displayed in list boxes may be slightly different. List boxes in Calc can either have multi-selection or not, whereas Excel has two multi-selection modes: multi and extend.
In Excel a link from a multi-selection listbox to a cell is ignored at least in Excel ; the author has not checked Excel XP. Option buttons import into Calc, but the link with cells works differently.
In Calc each option button has its own link to a cell, setting its value to true or false depending on whether the option is selected. In Excel the cell link returns the number of the selected option button. Array constants are not available in Apache OpenOffice. The workaround is to have the constant values in cells on a sheet and refer to them.
Array constants used as parameters to a function in Excel are omitted when imported into Calc. Some formulas have more than one optional parameter at the end of the parameter list. In Excel it is possible to leave an optional parameter blank and specify a later parameter, but this is not possible in Calc.
Formulas with optional parameters are not correctly imported into Calc. In Excel some of the financial functions accept string parameters for dates; in Apache OpenOffice they require a serial number, and thus they are not correctly imported into Calc. Hyperlinks are supported but not as a function; use the Hyperlink button on the Function bar. However there are a number of limitations. Pivot tables import from Excel into Calc although the cells do not have the PivotTable shading but as soon as they are worked on these limitations become apparent.
The limitations are:. AutoFilter imports and exports correctly with the required rows being hidden. However, there are a number of differences between Excel and Calc:.
A workaround would be to have another column to the left that contains the currency symbol. There is no predefined option for bracketing negative numbers.
The author had not noticed the following changes, so this is a direct quote from StarOffice 7 Migration Guide by Sun. Unlike Microsoft PowerPoint, StarOffice Impress does not support three-color gradients, double and triple borders, or round-dotted borders. To improve the results of the import, you have to make the necessary adjusts before import. You can be your own spreadsheet expert thanks to templates with built-in functions, allowing you to concentrate on your real work.
Multiple users support - Encourage collaborative work on spreadsheets. By sharing a spreadsheet, other users can easily add their data to the spreadsheet. The spreadsheet owner can then easily integrate the new data with a few clicks. This collaboration feature helps avoid editing conflicts. Save your spreadsheets in OpenDocument format, the new international standard for office documents. How can this problem of special characters comes in to picture then?
I mean, it is a calculator in the first place. I could also think of a much prettier database report which uses Writer's layout to create printable aggregations of databse tables. It's Excel which does not show the bullets.
You might try changing the font that Excel is using to see if that helps. What character did you use in Calc to indent the lines? I tried to reproduce your sheet; I used spaces to indent the lines below the first. When I exported that to. Excel should be able to display spaces, no? If your client does not need to edit the files, you might consider sending a PDF instead.
You can generate that directly from OOo, and a PDF will work for the client, no matter what office software they have.
LibreOffice 7. But I have attached screenshots which are prettymuch self explaenatory. Please have a look at them. If you want any additional information feel free to either add a new reply to this post or e-mail me.
0コメント