Issue 27871 - Size of horizontal scrollbar / the position of the devider between the sheet tabs and the horizontal scroll bar should be saved/imported to/from Excel
Summary: Size of horizontal scrollbar / the position of the devider between the sheet ...
Status: CLOSED FIXED
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 1.1
Hardware: All All
: P3 Trivial with 1 vote (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@sc
URL:
Keywords: ms_interoperability, oooqa, rfe_eval_ok
Depends on:
Blocks:
 
Reported: 2004-04-16 08:10 UTC by frank
Modified: 2013-08-07 15:15 UTC (History)
3 users (show)

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

Attachments
Scroll Bar in an .odt doc (47.97 KB, image/png)
2005-04-11 23:39 UTC, peschtra 		no flags Details
Reopened as an .xls file (50.23 KB, image/png)
2005-04-11 23:39 UTC, peschtra 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description frank 2004-04-16 08:10:57 UTC 
Open a new document, drag the divider between the scrollbar and the sheetarea to
the left, so it covers the last sheet.
Save this document to an Excel file and close it.
Reload the file. As you can see, currently the position/size is not kept.
Comment 1 frank 2004-04-16 08:21:56 UTC 
set the target
Comment 2 daniel.rentz 2004-04-19 17:11:25 UTC 
accepted
Comment 3 frank 2004-05-04 13:16:39 UTC 
Due to limited time ressources I re-Target this one to OOo Later
Comment 4 peschtra 2004-07-10 06:14:17 UTC 
I would like to echo this! This would be a great feature!
Comment 5 thegerbil 2004-09-23 17:39:00 UTC 
This is a must or those using multiple sheets converting from Excel to Ooo.
Comment 6 peschtra 2004-10-02 05:20:45 UTC 
This is also a problem in Impress.
Comment 7 erwin.tenhumberg 2004-10-26 16:35:28 UTC 
enhanced summary, set keywords and reassigned issue according to RFE process
Comment 8 frank 2004-10-28 08:39:06 UTC 
Hi Dancer,

never touch an Issue assigned to a developer. Such Issues are worked on
especially if the have the staus started.

Frank
Comment 9 frank 2004-10-28 08:39:34 UTC 
reset started
Comment 10 daniel.rentz 2005-01-28 11:33:54 UTC 
Will be fixed in OOo 2.0, setting target
Comment 11 daniel.rentz 2005-02-02 19:36:50 UTC 
Added in SRC680/dr32 (OOo 2.0) for BIFF5 and BIFF8 (Excel 5.0+) import/export.
Comment 12 daniel.rentz 2005-02-07 18:19:13 UTC 
reopened
Comment 13 daniel.rentz 2005-02-07 18:19:55 UTC 
back to QA
Comment 14 daniel.rentz 2005-02-07 18:20:24 UTC 
fixed
Comment 15 peschtra 2005-02-13 03:09:20 UTC 
Verified in 1.9.78 on Win XP & Excel 2002.
Comment 16 oc 2005-02-14 11:35:16 UTC 
Task is available in internal build cws_dr32. Will be available >OOo1.9m79
Comment 17 peschtra 2005-02-15 00:49:15 UTC 
It seemed to work in 1.9.78, was that an anomoly, or did I mis understand what
was happening?

Thanks.
Comment 18 daniel.rentz 2005-02-15 15:00:57 UTC 
@peschtra: How did you verify this issue? Try to export a file to Excel twice, first 
without moving the divider, second after moving it...
Comment 19 peschtra 2005-02-19 18:44:35 UTC 
I followed you instructions in 1.9.78 & 1.9.79 and couldn't duplicate. Can
anyone else duplicate this.

Reopening, because I still have the issue.
Comment 20 oc 2005-02-21 09:37:02 UTC 
This issue is fixed on an internal build (cws_dr32) and will be available in one
of the next OOo versions. Please wait until the version is available. => reset
status to fixed
Comment 21 oc 2005-02-21 09:37:42 UTC 
reset verification status
Comment 22 peschtra 2005-02-21 17:04:21 UTC 
Sorry, you said it would be availabe in 1.9.79, so I checked, and it wasn't. :(
Comment 23 daniel.rentz 2005-02-22 11:51:57 UTC 
cite: "Will be available >OOo1.9m79" - the ">" means a milestone after 1.9.79
Comment 24 peschtra 2005-02-26 04:11:44 UTC 
Thanks sorry, I am still learning the terminology. Is 1.9.80 considered a
milestone? Or is a milestone one that is "publicly" released?

Thanks.
Comment 25 oc 2005-03-18 10:52:58 UTC 
closed because fix available in OOo1.9m87
Comment 26 peschtra 2005-04-11 23:39:09 UTC 
Created attachment 24948 [details]
Scroll Bar in an .odt doc
Comment 27 peschtra 2005-04-11 23:39:28 UTC 
Created attachment 24949 [details]
Reopened as an .xls file
Comment 28 peschtra 2005-04-11 23:41:17 UTC 
So, the scroll bar doesn't move, but the sheet names shift, you can see in the
1st sceen shot, the selected tab is next to the scroll bar edge, but in the
second picture, after I have closed and reopened the file, the select tab is not
next to the tab. This happens when I open as an excel and .ods file.

Should I file a new issue or reopen this one?

Thanks.
Comment 29 daniel.rentz 2005-04-12 09:13:15 UTC 
Yes, I see. Position of first visible sheet tab is not loaded/saved. Please open
a new issue for that.