Issue 92225 - Wrong multi-Sheet zone selection
Summary: Wrong multi-Sheet zone selection
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 2.4.1
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-07-28 20:54 UTC by frizou
Modified: 2013-01-29 21:45 UTC (History)
1 user (show)

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

Attachments
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 frizou 2008-07-28 20:54:14 UTC 
Sometimes, it could be shine to calculate a SUM or something else on a large 
number of sheets.

Sheet TOTAL, cell A1: formula =SUM(begin.A1:end.A1)
when workbook contains following sheets:
- TOTAL
- BEGIN
- A
- B
- C
- ...
- END

Expected user-interface operation to enter this formula is:
- sheet TOTAL, select cell A1
- type "=SUM(" on keyboard
- with the mouse, select sheet BEGIN, press shift and clic sheet END to select 
sheets BEGIN, A, B, C, ..., and END
- clic cell A1
- press ")" + enter on keyboard

When this user-interface operation is done, the resulting formula is: "=SUM
(BEGIN.A1)" instead of "=SUM(BEGIN.A1:END.A1)".

The user-interface operation to get the correct formula is:
- sheet TOTAL, select cell A1
- type "=SUM(" on keyboard
- with the mouse, select sheet BEGIN, clic A1 cell
- press shift and clic sheet END to select sheets BEGIN, A, B, C, ..., and END
- clic sheet "END" to make it active (name "END" in bold", but sheets BEGIN to 
END still selected)
- press shift and clic cell A1 (in END sheet)
- press ")" + enter on keyboard
--> not very user-friendly...
Comment 1 chl207 2008-08-29 04:49:58 UTC 
In OOO300_m3 On WinXP，it exists. But I think the current way ,which can get 
the correct formula, seems more reasonable and logical. So I believe this 
issue is INVALID.

The user-interface operation to get the correct formula is:
- sheet TOTAL, select cell A1
- type "=SUM(" on keyboard
- with the mouse, select sheet BEGIN, clic A1 cell
- press Shift and clic sheet END to select sheets BEGIN, A, B, C, ..., and END
- clic sheet "END" to make it active (name "END" in bold", but sheets BEGIN to 
END still selected)
- type ":" and clic cell A1 (in END sheet)
- type ")" + press Enter on keyboard
Comment 2 redflagzhulihua 2008-09-01 10:37:35 UTC 
Hi,

In this case, you needn't select the sheets, just do like this:

- sheet TOTAL, select cell A1
- type "=SUM(" on keyboard
- with the mouse, select sheet BEGIN, press shift and click A1 cell
- click sheet "END", press shift and clic cell A1 (in END sheet)
- press ")" + enter on keyboard

I think your proposal is real a good one which is adopted by MS. Maybe it could 
be a enhencement to improve interoperability, but not a defect.
Comment 3 frizou 2008-09-02 18:09:19 UTC 
Thanks for your comments.
You're right I'm MS intoxicated... and Oo UI you explain to me is good too
(because with MS UI let us understand it's possible to have a multi-sheet
selection with hole inside, but it doesn't: it must be from BEGIN to END, like
with Oo).
I propose to delete this Issue. Priority set to P5.