Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenWed, 14 Aug 2019 16:45:39 +0200Why does the row height change when opening an excel document?https://ask.libreoffice.org/en/question/204667/why-does-the-row-height-change-when-opening-an-excel-document/I opened an existing excel spreadsheet using LibreCalc 6.2 and I noticed that LibreCalc didn't respect the existing row heights of the excel, but it did respect the column widths. How can I ensure a seamless transition from excel to calc regarding this issue?dubd83Wed, 14 Aug 2019 16:45:39 +0200https://ask.libreoffice.org/en/question/204667/What is going on when I copy directly from MS Excel and paste to base?https://ask.libreoffice.org/en/question/164751/what-is-going-on-when-i-copy-directly-from-ms-excel-and-paste-to-base/If I copy data from MS Excel (Mac version 16.16) and don't have the columns sized large enough, I can see errors in what appears in the resulting base table after pasting that data. A simple example is [this simple spreadsheet](/upfiles/1536082838441085.png). Copying its cells and pasting into a base file results in [this base table](/upfiles/15360824828645656.png). My Libre Office version is Mac 6.0.6.2.
I can avoid this problem by having the MS Excel columns sized large enough or by opening the MS Excel file with Calc and using Calc for the copy.
When I do the paste into a Calc spreadsheet, it appears as if an image of the copied cells is being pasted.
If I do the paste as a special paste with formatted text (RTF) in base I avoid the problem.
If I do the paste as unformatted text into a Calc spreadsheet, then the Calc cells are populated as expected.wehmann12Wed, 05 Sep 2018 01:17:11 +0200https://ask.libreoffice.org/en/question/164751/Excel, How to enter a cell, then / as char/text, then different cellhttps://ask.libreoffice.org/en/question/146534/excel-how-to-enter-a-cell-then-as-chartext-then-different-cell/ Minus the quotes, I am trying to get my destination cell to display: "1/1" where the first 1 is a cell, and the second 1 is another cell.
Here was what I tried, which doesn't work: ='Medical Equipment'!$C$38, "/", 'Medical Equipment'!$D$38
Is this possible? Trying to show how many were checked (C38), out of how many were required (D38).TurboGoKartFri, 16 Feb 2018 16:57:30 +0100https://ask.libreoffice.org/en/question/146534/Can someone with access to Excel 2016 test as described in the attachment, please?https://ask.libreoffice.org/en/question/91825/can-someone-with-access-to-excel-2016-test-as-described-in-the-attachment-please/(No further bumps, hopefully. The issue was handled due to a thankworthy intervention of a contributor to another forum that actually deserves this name. He was also the original reporter of the mentioned bug.)
See https://forum.openoffice.org/en/forum/viewtopic.php?f=9&t=88407 .
See also https://bugs.documentfoundation.org/show_bug.cgi?id=99625#c22.
(2. Bump. There are also new comments to be regarded here.)
To everybody having access to Excel 2016 and in specific to @rautamiekka.
I would like to ask again for testing an example. To simplify things a bit I now do it based on an example, one Alan Murray (MS software trainer and founder of the "Computergaga") posted on YouTube as of 2016-11-02.
**See [this](/upfiles/14919120057884768.ods) demonstrating file.**
In case of problems like those @rautamiekka already experienced, I would suggest to re-enter the critical formulae via the keyboard. Please note that only **Excel 2016** can be used for this. Older versions won't do, a**nd a cloud implementation may also differ**.
@karolus is right with his comment as far as **the facts** are concerned. He did not know the comments on the bug [tdf#99625](https://bugs.documentfoundation.org/show_bug.cgi?id=99625) by developers I linked in later.
(1. Bump. Also regard my answering comment to the comment by @rautamiekka, please.)
There is a saying that Excel 2016 has implemented two new functions, namely CONCAT and TEXTJOIN capable of accumualting an arbitrary number of text pieces where these pieces may be listed one by one (as also possible using CONCATENATE), but also can be given as the contents of referenced cell ranges.
The second variant can be used to solve some tasks formerly depending on complicated usage of helper columns or even on user programming, now in a handy way. To get the full power out of these functions we need, of course, to be able to pass calculated arrays instead of simple ranges via the respective parameters. To do so, a formula will need to be entered explicitly for array-evaluation.
A simple example:
`{=CONCAT(IF(A1:A10<5;B1:B10;"")}` returning the concatenation of those elements of `B1:B10` that correspond with values < 5 in `A1:A10`, and leaving out the other elements.
Handling an enhancement request ([tdf#97831](https://bugs.documentfoundation.org/show_bug.cgi?id=97831)) these functions were also implemented in LibO Calc as of V5.2.0.
As I was told, "There are no specifications, as these functions were introduced to be compatible with Excel's new functions, ...". I still do not understand how this can justify an *implementation without first stating **which behaviour of the Excel functions was actually explored*** and now is to reproduce. In fact we have the mess that obviously nobody knows which behaviour actually **was** observed and that there are contradicting opinions about how it should be in the cases where array-evaluation is needed. Since 2016-05-02 when a respective bug was filed nobody was able to clear the issue. Currently the concerned developers obviously have no access to Excel 2016 for testing.
**Might, please, someone having access to Excel 2016 transfer the content of [this attached example](/upfiles/1491004982785907.ods) to a spreadsheet made by that software, and test if the behaviour in Excel (2016) actually is the same as in Calc (>=V5.2.0)** or in what way it differs.
See also: [tdf#99625](https://bugs.documentfoundation.org/show_bug.cgi?id=99625), [tdf#101124](https://bugs.documentfoundation.org/show_bug.cgi?id=101134) (meanwhile marked as duplicate).LuppSat, 01 Apr 2017 02:09:33 +0200https://ask.libreoffice.org/en/question/91825/