Created attachment 112828 [details] ODS file to reproduce the problem With the attached document, if you click on the header A to select the whole column, hold Ctrl and click on the first cell of the column to unselect it, then go to Insert->Object->Chart, the created chart is not correct, or at least not useful. More precisely, it seems to include all empty cells below the actual data, which makes it unreadable. It would be more useful to create the same graph as if the whole column was selected (i.e. without unselecting manually the first cell). This situation arises in practical cases when the first cell contains some text that you don't want to include in the legend (even more so if there are several cells before the data). Also, probably due to the fact that all cells below the data are used for the chart, operation is very slow and RAM usage very high, to the point that closing the chart dialog can takes a minute, thus giving the impression that Calc crashed. This could lead to data loss if the user kills the app, or if the systems runs out of memory. This is with LO 4.3.5.2-11 on Fedora 21.
(In reply to Milan Bouchet-Valat from comment #0) > With the attached document, if you click on the header A to select the whole > column, hold Ctrl and click on the first cell of the column to unselect it, > then go to Insert->Object->Chart, the created chart is not correct, or at > least not useful. More precisely, it seems to include all empty cells below > the actual data, which makes it unreadable. The Chart incude the data you requested. You select more than 1 million of rows, he use these rows... > It would be more useful to create the same graph as if the whole column was > selected (i.e. without unselecting manually the first cell). You will face the same problem. This have nothing to do with unselected the 1st cell. Just select the needed rows instead of the whole column.
(In reply to GerardF from comment #1) > > It would be more useful to create the same graph as if the whole column was > > selected (i.e. without unselecting manually the first cell). > > You will face the same problem. This have nothing to do with unselected the > 1st cell. The point is, if you select the whole column, Calc is smart enough to understand that you don't want to use the empty cells that are below the data. From the user perspective, unselecting one cell currently has the effect of using those empty cells which were ignored one second later. I understand why this works that way technically, but it's not good for the user experience. > Just select the needed rows instead of the whole column. Yeah, but in that case I had 10 columns with a few thousands rows, and scrolling by hand is very painful. And more fundamentally, the problem is that the operation I did, which is relatively simple, makes Calc appear to hang, which is really bad for a serious program.
I think this is not a bug. Calc is "smart" only when you select whole row/column. When you select only some cells, then you directly says what to use. It's your case. It's like selecting B40:C46 - how should Calc recognize if use "smart select" (without empty rows) or maybe I want to have empty rows in range?? Should be closed as notabug.
Call it a feature request if you like. Let's see the problem from a different angle. When selecting a full column and then subtracting one or several cells from that, instead of keeping all rows selected up to row #1048576, Calc could automatically subtract from the selection all empty cells starting from the bottom. This would be much more useful in 99% of cases. In the 1% remaining cases, people would still be able to select the range by hand (just like people currently need to do for the 99% case).
It is very easy to select the range A2:D44 in your file without scrolling: 1/ select D2, the first non empty cell in the last column you want use in your chart 2/ hit ctrl+arrow down: the last non empty cell in the column D is selected 3/ Shift click on A2: the whole range is selected. Now you can do your chart. Works identically if you have 10 columns with 10000 non empty rows. Closing as NotABug as already suggested. If you think that some improvement can be done in Calc module related to the range selection, please feel to describe what in a detailed way. To do that please, open a new bug report/enhancement. Thank you for your understanding. Best regards. JBF