If I Highlight my spreadsheet and go under Data > Define Range... I see four things immediately out of joint: (1) The range being set up is defined with absolute addressing. Hoe about future additions or deletions in the matter of rows or columns? Am Iat risk here od having an old range setting doing something wrong because it does not update automaticallY. (2) I pick out an existing range or enter its name, and suddenly my highted range is replaced with the old range settings instead of vicxe versa. This is backwards from what should happen here. (3) Under Options, I find that none of the choices is set as a default. This seems contrary to good judgement. But you don't even know of these settings or what not having them set entails if you don't first think to click on options. Wouldn't it be better to have them displayed in the above menu so that their importance is more easily identified? (4) Modify does not seem to do anything. I have a range area highlighted, I go into this Data > Define Range.. I see existing ranges, I click on one and get the old range settings in place of my current selection, I click on Modify, and the name box clears. Or am I suppose to click the Modify box first? It's just not evident what is suppose to happen here. (4)
I know that since Excel (and probably earlier), that if you type in something really long, say an URL, and the adjacent cells on either or both sides is empty, that the long entry will visually spill over into them. This has never been a good idea, as it clutters up what you see on the screen. There should be a way to turn this viewing aspect off, rather than having to go into the blank cells and enter a space character. If you have an URL in a cell, you should have the option to bring up a browser of your designation (or the default browser) and go to that web page simply. As it stands now, you have to do a copy, bring up the web browser, clear the address bar (or force a Select All), paste, then press Enter. That is a painful way of getting it done. And if you select a range of cells with URLs in them, why not have it so that each becomes a new Tab in that browser? That would save a lot of copy-and-paste and switching focus between the spreadsheet and the browser. My efforts with browsers show me that they can handle up to 30 or so open Tabs, but this seriously impairs their performance. It really depends on the PC'a cpu (number of cores, rated speed), and RAM (4GB is hardly enough), but this could either be something that the user sets his/her own limit for, or could be part of Calc in deciding what the # limit of URLs should be.
(In reply to Donald Darden from comment #1) > If you have an URL in a cell, you should have the option to bring up a > browser of your designation (or the default browser) and go to that web page > simply. As it stands now, you have to do a copy, bring up the web browser, > clear the address bar (or force a Select All), paste, then press Enter. > That is a painful way of getting it done. And if you select a range of > cells with URLs in them, why not have it so that each becomes a new Tab in > that browser? That would save a lot of copy-and-paste and switching focus > between the spreadsheet and the browser. If you hover your mouse over the hyperlink, it will display a tooltip that says you can Ctrl+click to open the hyperlink in your default browser.
I'm closing this as INVALID. The reason being: 1. We need one bug per bug report - reporting four separate issues in a single bug is not functional for bug reporting/fixing purposes; 2. There are limited and not entirely clear steps on how to reproduce each issue; Please report the issues separately, one bug per issue, with clear and complete reproducible steps (enumerated is best, written assuming the triager has minimal information pertaining to the features you're using). https://wiki.documentfoundation.org/QA/BugReport#Good_Reports Thanks