Date: prev next · Thread: first prev next last
2021 Archives by date, by thread · List index

Hi Ian,

Ian West schrieb am 04.01.2021 um 02:42:
When I open an Excel file in Libre Calc I seem to lose some functionality.

The Excel file has several columns in a table. When you add data and get to the last column in the the table,  a new line is added, and the cursor returns to the beginning of that new line. All the formulas are copied down as well.

If you enter values into the cells of a row and you go with Tab-key instead of Enter-key to the next column, then when you use Enter-key for the last cell of the row, the cursor is set to the first cell of the next row.

Formulas are not copied automatically. But when you set the cell cursor on to a cell which has the formula, then you can use a double-click on the little black rectangle bottom, right on the cell cursor frame, to copy the formula down to the last filled row in a column left or right from it. So first enter all data, and when finished copy the formulas.

When opened in Libreoffice this no longer happens. How can I fix this?

LibreOffice is not a clone of MS Office. You should not expect that things always work the same way. Some parts work even better in LibreOffice than in Excel (for example: Automatic detection of needed range for results of matrix operations).

My MS  Office 2007 has spat the dummy, and frankly I don't want to spend big dollars on replacing it. LibreOffice seems to be a good alternative, however, I need to fix this problem.Maybe I'm just getting too old!
LibreOffice is a very powerful Office application. You can surely do all things in it you need, only sometimes in a different way.

Kind regards

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
Privacy Policy:


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.