Apache OpenOffice (AOO) Bugzilla – Issue 37725
window/freeze -> split in excel format / ugly view
Last modified: 2013-08-07 15:15:02 UTC
when using window/freeze on several tables and save in ms-excel-format the freeze becomes a window/split. the real bad thing is that this destroys the view in ooo and excel: - the tabs with the table-names are hidden (only the horizontal scrolling bar is visible). You have to pull the splitting to the total right of the window then pull the border between the (not visible) tab-name-area and the horizontal scrollbar to the middle. - sometimes you have to do the same with the vertical splitting. - you have to change window/split to window/freeze and if you save as ms-execl file the chance is high that the problem is the same the next time you open the excel-file. sometime it helps to store as sxc file - sometimes not. i attached four versoins of the same file: (sorry for that, but this happens regulary with large files and the attached are the smallest files that i can offer it is always the same (nearly) unchanged file - maybe i added or deleted one character to get the save-button) when opening dont update external link. - windowfreeze1.xls: the file before ooo is involved (only used by ms-office) - windowfreeze2.xls: (corrupt) the same file after deleting and adding some window/freeze - windowfreeze2.sxc: the same file after correcting _one_ table in ooo and save in xml-format (all tables are correct) - windowfreeeze3.sxc: the same file after correcting _one_ table in ooo and save in xml-format (this time only the one table is partially ok - may be i did not all the corrections) i hope i could explain what happens and the attatchments helps. yours gerhard
Created attachment 19616 [details] original execl-file
Created attachment 19617 [details] execl file after ooo miss-saved windows/freeze
Created attachment 19618 [details] corrected version saved as sxc
Created attachment 19619 [details] saved as sxc (partial corrected)
Hi, Checked with OOo1.1.3 and found correct freeze settings in Excel after saving wiindowfreeze1 to new XLS File. Please use the latest available Version, in this case OOo1.1.3 Frank
closed wfm
hallo 1) it happens with 1.1.3 too and 2) i did some investigation and can give you now a step by step instruction for one special case to reproduce the error a) open windowfreeze1.xls (dont update external links/data) b) you are now on tab "C_Büroeinricht_" c) remove the window/freeze d) klick to cell A1 (a "joined cell" fro A1 to K1) e) set window/freeze by main menu (f) open window-menu: freeze is _not_ checked - not necessary, but may be of interrest - close window-menu by clicking somewhere in the spreadsheet) (g) save as openoffice-calc - not necessary) h) use "save as", give a new name, use type microsoft-excel 97/2000 (it should work with the same name too and also by enter a space somewhere and then use "save") i) close document (so now no document is open) or close openoffice at all j) open the excel sheet and have funny tab "C_Büroeinricht_" (when opening the ooo-calc from step g) everything looks fine) gerhard ps: i could swear i never used window/freeze on a "joined cell" so i think the same happens under other circumstances too, but may be this disapears when this bug is solved or i can give you again instructions how to reproduce. but the result here is exactly the same that i discovered in other tables.
Hi Daniel, not present freeze is converted to a split and confuses Calc on import. Frank If possible target 2.0
first thank you for verifying as you wrote it would be a good idea to harden the inputfilter (to not been refused), but the bug is in the _export_ because ms-excel also has problems with this ooo-created files (seeing a split with zero rows and zero columns before the split and cannot recover simply by doing "unsplit window"). best regards gerhard
gerhard_oettl, thanks for the hint, I will take this into account accepted/started
will be fixed in OOo 2.0, setting target
Fixed by reimplementing export of view settings. The wrong exported file windowfreeze2.xls contains a split at pixel position (1;1), which is re-imported by Calc and Excel (it overwrites the row/column headers). To remove it, select Window->Split in Calc. See also issue 41422.
reopened
back to QA
fixed
verified in internal build cws_dr32
closed because fix available in OOo1.9m87