Apache OpenOffice (AOO) Bugzilla – Issue 18150
Cub Scout tracking .xls spreadsheet fails in conversion
Last modified: 2003-09-17 10:28:04 UTC
The attached spreadsheet is commonly used for tracking cub scout advancements. It make a nice example of a .xls file that isn't quite converted correctly. The problems are as follows: 1. The opening Notes has an embedded text box that is not displayed at all. (It should start at about B4). 2. Cells formatted in Excel as Horizonal Right (for example, Summary sheet, C3:C6), in Excel, spill over to the left. In OOo, they simply are truncated, making the text unviewable. 3. The end result of a cell("filename") in MS Excel is (for example) y:\xfer\[filename.xls]Scout1 (see A1 in sheet Scout 1). In OOo, it is instead 'file:///home/jwhite/xfer/filename.xls#$Scout1' This causes the calculation in A1 to fail. The good news is the reason this is important is that OOo saves these pages to HTML *much better* than MS Excel does so; so it produces actual useful web pages, unlike Excel. Thanks for any help.
Created attachment 8400 [details] Cub scout tracking spreadsheet showing failure cases
There are three issues: 1. Lost text box: this is an Excel5 document. The Excel5 filter of OOo does not support textboxes or drawing objects. This filter will not be increased. Please resave this document in Excel to the Excel97- fileformat. 2. Right alligned cellcontent does not clipp to the left: this one is duplicate to issue 1171 3. different filenames: Due to differences in the internal naming of files and sheets between OOo and Excel, this problem is not fixable without becoming incompatible with older fileformats. You can only workaround the problem by manually adjusting the functions in OOo. Problem 2 duplicate, Problem1 and 3 will and could not be fixed => wontfix
closed because wontfix