Apache OpenOffice (AOO) Bugzilla – Issue 116205
Frozen row information is lost when calc document is saved
Last modified: 2017-05-20 11:27:42 UTC
I want to convert the ods file with a frozen header row (stays on top while scrolling). When doing this via Calc itself (save as Excel 97/2000/XP), everything works fine - the final xls file has this header row locked. But when exporting via oo api the row "lock" information is lost, and the row in the resulting document is not frozen anymore. I tested the behavior on the ConnectionAwareClient from OO First Steps guide with OO 3.2.1 and java api libraries of the same version (juh, unoil and their transitive dependencies). I slightly changed the code - there is no need for command line arguments, the uno-url is hardcoded in main() and oo daemon is started automatically. The path to source and destination files is defined in private static constants. When the user presses "New calc" button, the source file is opened and saved to destination file. if everything goes right, there is a "connected" message in label. when i run the example, the frozen raw is not preserved in the new file. Moreover, if i remove the save filter and save file as ods - frozen raw is not preserved either.
Created attachment 75396 [details] Sample ods document, resulting xls and source code
jsc -> nn: one for you and the new year ;-)
Reset assigne to the default "issues@openoffice.apache.org".