Usually when you select multiple items, this means you want to do something with all of them. E.g. if you selected multiple cells, and pressed "Italic", all selected cells turns italic. By this analogy, selecting cells, and starting to type should make the text appear in all selected cells (this feature is in particular employed by vim-like editors). But actually, this affects just single cell. # Steps to reproduce 1. Open `localc` 2. Select two cells 3. Type "hello" 4. Press Enter # Expected "Hello" appears in all selected cells. # Actual "Hello" only appears in one cell.
Hello Konstantin, This is not the way Calc is designed to work. If you input some content to a selection, it will only be added to the first cell in the selection. However, you can drag&drop the bottom right corner to replicate the content in the different cells. Closing as RESOLVED NOTABUG
> This is not the way Calc is designed to work. @Xisco Faulí but wouldn't it be more rational if it did? Right now selecting multiple cells and typing a text does same thing as selecting a single one, which is a wasted opportunity to do something useful instead.
Btw, > However, you can drag&drop the bottom right corner to replicate the content in the different cells This is twice the number of actions compared to just selecting cells, and typing the text. Because you need to do the drag'n'drop for every cell where you wanted the text.
@Konstantin When finishing typing just (step 4) alt+enter and the selected cells will be filled with text or numbers. Its not a bug Best regards
(In reply to Xavier Van Wijmeersch from comment #4) > @Konstantin > > When finishing typing just (step 4) alt+enter and the selected cells will be > filled with text or numbers. > Its not a bug > > Best regards Okay, it's not a bug, let's call it a feature request. But it wouldn't hurt to have it, would it? I mean, it would improve the user experience more than some obscure shortcut which is not easy to find.
@Regina, @Eike, any opinion on this enhancement request ?
A similar feature is available in Calc. Select the cells, then enter the content not in a cell, but in the input line. Finish with Alt+Enter.
(In reply to Regina Henschel from comment #7) > A similar feature is available in Calc. Select the cells, then enter the > content not in a cell, but in the input line. Finish with Alt+Enter. It's a very hard to find feature. E.g. query to google "libreoffice calc enter text to multiple columns"¹ gives nothing relevant. On the other hand, what I suggest here is an intuitive design decision, and would not require searching at all.
FTR, I could find if I had entered "cells" instead of "columns", doh. Still, the point stands.
(In reply to Regina Henschel from comment #7) > A similar feature is available in Calc. Select the cells, then enter the > content not in a cell, but in the input line. Finish with Alt+Enter. Fwiw, it also works if content is entered in a cell, not just in the Input Line. Important is Alt+Enter. It even works across multiple selected sheets.
So, is there any opposition to keeping this opened as a feature request?
(In reply to Konstantin Kharlamov from comment #11) > So, is there any opposition to keeping this opened as a feature request? Why, it's already implemented with Alt+Enter
(In reply to Xisco Faulí from comment #12) > (In reply to Konstantin Kharlamov from comment #11) > > So, is there any opposition to keeping this opened as a feature request? > > Why, it's already implemented with Alt+Enter Because it's not an intuitive design decision. There's no visual hint, nor even a text entry in context menu. It's just some arbitrary hotkey which is not even easy to find (I haven't found back when I worked with Calc). I am not suggesting to remove the Alt+Enter feature, but adding a more intuitive way as an alternative surely won't hurt.
What alternative? Plain Enter can't be used as selecting a cell range and then entering values closing with Enter moves the cell cursor within the selection, moving to the next column within the selection when reaching the end row of the selection. Which is far more used than entering the same value into a selected cell range.
(In reply to Eike Rathke from comment #14) > What alternative? Plain Enter can't be used as selecting a cell range and > then entering values closing with Enter moves the cell cursor within the > selection, moving to the next column within the selection when reaching the > end row of the selection. Which is far more used than entering the same > value into a selected cell range. Ah, okay, I think I see. So, to sum up: such feature would conflict with another workflow, where one selects cells, starts typing in a cell, and then moves to the next cell within the selected ones.