Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenMon, 03 May 2021 09:16:40 +0200How to shift the cell coordinate by constant number?https://ask.libreoffice.org/en/question/307452/how-to-shift-the-cell-coordinate-by-constant-number/ I want to pick 3000 data points from a large dataset. The data is placed in the cell, which coordinate constantly increase by number of 9. For instance the first data point of interest is in a cell A1, the second in A9, the third in A19. So how to make a formular to shift picking cell by 9 (something like that A1+9=A10, A10+9=A19 ....)? ZigmantasMon, 03 May 2021 09:16:40 +0200https://ask.libreoffice.org/en/question/307452/Calc enter (line shift) shifts left cell instead of downhttps://ask.libreoffice.org/en/question/284463/calc-enter-line-shift-shifts-left-cell-instead-of-down/ When hitting Enter in LibreOffice.org ver. 7.0.4.2
Then the result fills into the cell as normal, but instead of shifting cell position down to the cell below, it shifts to the cell position on the left.
This is a pain in the arse when you are used to that every iteration of LibreOffice you have had installed does shift the cell to the cell below.
Please fix, or place Settings in the software so you can choose which direction is the most beneficial to the user.Ben31938Sun, 27 Dec 2020 05:18:54 +0100https://ask.libreoffice.org/en/question/284463/How to shif dwon all the rows below a line, including images when i use the "insert row" in a libreOffice calchttps://ask.libreoffice.org/en/question/278447/how-to-shif-dwon-all-the-rows-below-a-line-including-images-when-i-use-the-insert-row-in-a-libreoffice-calc/ Hi,
How to shif dwon all the rows below including images when i use the "insert row" in a libreOffice calc?
In fact i am a new LibreOffice user, and i am used to use this fonctionnality in Microsoft Excel. In fact, it can happen sometimes to need to insert an image in the middle of a some other image.
but when i use the "insert row" the lines with text shift down but not the images.
Can you help please ?
Thanks.SOUESun, 22 Nov 2020 19:57:55 +0100https://ask.libreoffice.org/en/question/278447/Mac special characters?https://ask.libreoffice.org/en/question/102016/mac-special-characters/Hello, I am trying to type/enter mac modifier (keys ⌘⌥⇧ etc.) in calc.
My usual go to method of **⌥ ⌘ T** doesn't produce the mac "special characters" menu.
Tried **insert > special characters** but couldn't find any mac modifier keys in the special characters list.
Cheers.appreciatethehelpSat, 24 Jun 2017 13:24:56 +0200https://ask.libreoffice.org/en/question/102016/Bitwise shifts not implemented in LO Basic?https://ask.libreoffice.org/en/question/79903/bitwise-shifts-not-implemented-in-lo-basic/ This is the second question I've got here; in short, trying to transfer a code segment from C++ to LibreOffice Basic, and some functions and features seem to be not implemented.
For this particular question: while there are bitwise shift functions for Calc (BITLSHIFT, BITRSHIFT), there's no such function or operand in LO Basic.
Obviously, what I mean are the C/C++ operators << and >> as in:
a = b << c; //left shift
d = e >> f; //right shift
Could someone please let me know if I've overlooked something, or if it's indeed missing? Also, since I'm rather new here, is there any place I can file a "bug" report so that it's considered for future implementation?
Thanks!
skagonWed, 19 Oct 2016 15:16:08 +0200https://ask.libreoffice.org/en/question/79903/Calc paste special 'shift'https://ask.libreoffice.org/en/question/6839/calc-paste-special-shift/Could someone please explain why the 'Shift Down' option in the 'Paste Special' menu of Calc is greyed out when I try to cut and insert a row of cells. It is not greyed out when I try the same option with 'Copy'.
This complicates any attempt to move cell contents around in a spreadsheet. I am coming from the Excel world and the functionality I am trying to duplicate is the 'Insert Cut Cells' option. DWilkschSun, 14 Oct 2012 08:48:06 +0200https://ask.libreoffice.org/en/question/6839/CALC 4.0, cannot shift highlighted chart data rangehttps://ask.libreoffice.org/en/question/12798/calc-40-cannot-shift-highlighted-chart-data-range/when selecting a chart, CALC 4.0 highlights the chart's data columns but one cannot drag the selected range to another set of columns... :(
in excel one can even drag-separate the selected column ranges with the mouse.
please implement! :(
thanks
mmarcdunordFri, 22 Feb 2013 04:44:27 +0100https://ask.libreoffice.org/en/question/12798/