Apache OpenOffice (AOO) Bugzilla – Issue 128285
Calc Insert > Sheet From File... - two windows
Last modified: 2020-04-11 13:34:46 UTC
Created attachment 86830 [details] Insert Sheet - two windows In an aged Issue 62448 - canceling Insert Sheet From File leaves Insert Sheet dialogue behind I found interesting statement: "The Sheet from File... Menu entry is for the convenience of the user and calls the Insert Sheet dialog with the file selector box open. Closing the import wizard with Cancel jumps to the calling dialog itself which is the same as shown then used Insert Sheet." Choose Insert > Sheet From File... Aforementioned "convenience" has unfortunately one weak point: first dialog "Insert sheet" is fully shown for a very short time and then over it opens up another dialog "Insert" - a modal one. Once suitable file is picked, that dialog disappears and dialog "Insert sheet" becomes fully visible. (see attached file - it doesn't reflect necessarily actual layout i.e. relative position of both windows). I hardly see any logic in this approach. It also seems to me counterintuitive in light of other examples within AOO (of course proportion wise): - AOO Writer let's assume that one intends to insert text file choose Insert > File... after choosing file in dialog "Insert", dialog "ASCII Filter Options" is shown - NOT BEFORE - AOO Calc let's assume that one intends to import text file (possibly in CSV format) choose File > Open... after choosing file in dialog "Insert", dialog "Text import" is shown - NOT BEFORE In brief: please do not show both window (dialog "Insert & dialog "Insert Sheert") one over the other. Simply first display dialog "Insert" and upon closure - if a file was choosen - display dialog "Insert Sheet".
This behavior is correct. This dialog can be called with other ways. Example: copy CSV datas into clipboard and special paste with Calc.
(In reply to oooforum (fr) from comment #1) > This behavior is correct. > > This dialog can be called with other ways. > Example: copy CSV datas into clipboard and special paste with Calc. I was aware of scenario(s) you mentioned. It does not invalidate my point. Let me then repeat it: do not show both dialogs at the same time as only one of them is needed (step by step procedure). I suggest therefore that we both agree do disagree.
I don't think that it is that bad. When opening a CSV file, in the underlying "Insert Sheet" dialog you can choose on which position the file with a new sheet will appear. So, for me a little advantage compared with Writer as there the text will be simply inserted where the cursor is at the moment.
(In reply to Marcus from comment #3) > I don't think that it is that bad. > > When opening a CSV file, in the underlying "Insert Sheet" dialog you can > choose on which position the file with a new sheet will appear. > > So, for me a little advantage compared with Writer as there the text will be > simply inserted where the cursor is at the moment. Apologies for the late reply. Had to do more research. It turned out that in the broader context you are absolutely right and I am wrong. Thanks for your valuable comment.
(In reply to Czesław Wolański from comment #4) > (In reply to Marcus from comment #3) > Had to do more research. It turned out that in the broader context > you are absolutely right and I am wrong. due to this comment I think the issue can be closed as it doesn't seem to be a problem.