Issue 116205 - Frozen row information is lost when calc document is saved
Summary: Frozen row information is lost when calc document is saved
Alias: None
Product: App Dev
Classification: Unclassified
Component: api (show other issues)
Version: 3.3.0 or older (OOo)
Hardware: All Windows, all
: P3 Trivial
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2010-12-22 11:12 UTC by pahan1980
Modified: 2017-05-20 11:27 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Sample ods document, resulting xls and source code (9.58 KB, application/x-compressed)
2010-12-22 11:13 UTC, pahan1980
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description pahan1980 2010-12-22 11:12:09 UTC
I want to convert the ods file with a frozen header row (stays on top while
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.
Comment 1 pahan1980 2010-12-22 11:13:10 UTC
Created attachment 75396 [details]
Sample ods document, resulting xls and source code
Comment 2 jsc 2010-12-22 12:20:00 UTC
jsc -> nn: one for you and the new year ;-)
Comment 3 Marcus 2017-05-20 11:27:42 UTC
Reset assigne to the default "".