Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenMon, 30 Apr 2018 23:31:55 +0200try to open an xls file in libreoffice calc opens a "text import" subroutinehttps://ask.libreoffice.org/en/question/153674/try-to-open-an-xls-file-in-libreoffice-calc-opens-a-text-import-subroutine/My file associations properly show LibreOffice as the app to open an XLS file.
But when I try to open an XLS file, LibreOffice Calc appears but instead of opening the worksheet, it displays a "Text Import" window, wanting me to specify how the text needs to be manipulated to create a CSV file. I just want to open the XLS file, not create a CSV.RitaHMon, 30 Apr 2018 23:31:55 +0200https://ask.libreoffice.org/en/question/153674/on open xls file asume some text as numberhttps://ask.libreoffice.org/en/question/14023/on-open-xls-file-asume-some-text-as-number/on open xls file asume some text as number on like 001, on version 3.4.X -> 3.6.5.2
Fedora 16 -> Fedora 18
Install RPM form libreoffice.org
some ideas to prevent that ?
original
001,026,0003, afrfrer
on libre office
1,26,3, afrfrerneorootThu, 07 Mar 2013 21:49:49 +0100https://ask.libreoffice.org/en/question/14023/treatment of mathematical operations on texthttps://ask.libreoffice.org/en/question/13026/treatment-of-mathematical-operations-on-text/**3.6.5.2 build 5b93205**
I have just installed LibreOffice and am trying to migrate my Staroffice .xls spreadsheets.
The .xls spreadsheets are openable with LibreOffice, but there is a problem with the treatment of non-numerical data when mathematical operations are performed.
LibreOffice returns the error #VALUE! when it finds non-numerical data in a cell that is being operated on mathematically (this is correct according to the HELP Manual). StarOffice treats this situation differently, it just ignores the non-numerical data, so the mathematical operation can complete sucessfully.
**EXAMPLE:** In the formula **=SUM(OFFSET(H683,-1,0),C683,-D683,E683)**
If one cell referenced by the formula has something other than a numerical value in it, then
- **LibreOffice** returns #VALUE!
- **StarOffice** ignores the non-numerical cell, and returns the
outcome of the calculation. This is
very useful in large complex
spreadsheets. Is there a way round
this in LibreOffice? I have tried to
find one without success.
Thanks.
petef.Sun, 24 Feb 2013 11:59:04 +0100https://ask.libreoffice.org/en/question/13026/xls opening as text documenthttps://ask.libreoffice.org/en/question/5621/xls-opening-as-text-document/I have an xls file that i've been using consistently with libreoffice. I just used it two days ago. Now I go to open it and it keeps opening it as a text document rather than a spreadsheet. Is anyone else having this problem? Or know of a solution? The Ice of PortlandTue, 04 Sep 2012 17:43:42 +0200https://ask.libreoffice.org/en/question/5621/