Issue 92225

Summary: Wrong multi-Sheet zone selection
Product: Calc Reporter: frizou <cgiraud>
Component: uiAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues
Version: OOo 2.4.1   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---

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.