libreoffice-calc Questions
6
I'm trying to generate a random 8 character alphanumeric string in Excel (or Google Sheets or Libreoffice, which both have the same challenge) using a formula. I'd like to get something like this:
...
Prae asked 5/12, 2022 at 21:57
2
Solved
I have to create a table with LibeOffice Calc in another language than my native one.
If I run the spellchecking, I manually have to change the language for every word in the document. How do I ch...
Stoma asked 28/5, 2019 at 13:17
5
Solved
I have got many cells in my file whose content is of the form
'14.05
I want to mass convert these cells, which contain text, to numbers, which I can compute with.
14.05
Is there a build-in f...
Kellen asked 15/3, 2018 at 14:38
5
I have a spreadsheet with existing date values that I'd like to convert from MM/DD/YYYY to DD/MM/YYYY format. Is there any way of doing this?
The spreadsheet comes from a csv file from someone els...
Instal asked 11/2, 2020 at 17:27
3
Solved
What formula in LibreOffice Calc will count the number of distinct Week_Number occurrences? The answer should be 2.
Otorhinolaryngology asked 9/7, 2016 at 16:47
2
Solved
In libreoffice calc I have a column with thousand words. Each word I need to put into quotation marks.
Example (A1 and A2 are cells)
start word (A1): car
end word (A2): "car"
Normally, I can...
Blepharitis asked 7/11, 2018 at 14:2
6
Solved
Suppose I have This This Cells:
And then for some reason I want to reverse the order of columns automatically to become something like This:
any help will be appreciated!
Kriss asked 3/2, 2017 at 23:43
3
I've been trying to import a couple of .json files into LibreOffice Calc.
Although I can get the raw data in, it isn't sorting as I would think it might (by placing different pieces of info into e...
Bott asked 20/3, 2014 at 13:17
3
Solved
I would like to get current document folder path as a cell value.
I need it for proper relative reference creation used in a function call OFFSET(INDIRECT(<generated filepath#sheet.cell>))
I...
Gyroscope asked 2/12, 2016 at 15:22
2
I have created a table that has a value on one column that I have used to generate a background colour (Format -> Conditional Formatting -> Color Scale... -> Colour Scale). Now I would lik...
Latchstring asked 20/10, 2014 at 14:32
3
Solved
I'm trying to create an Excel file with a simple formula:
import xlsxwriter
workbook = xlsxwriter.Workbook('testxlsx.xlsx', {'strings_to_numbers': True})
ws = workbook.add_worksheet()
ws.write('A...
Ukase asked 25/8, 2015 at 13:53
3
I can replace a formula in one cell by its calculated value by selecting the cell, hitting F2 then F9 and Enter.
When I want to do this for every cells in a column, and height of that column == N,...
Prado asked 23/10, 2014 at 12:56
3
Solved
I have a LibreOffice 3 spreadsheet (on Ubuntu 11.04) with a column of hundreds of hyperlinks which simply display as 'Link'.
I need to convert these to just plain text, or at worse hyperlinks whic...
Kassi asked 17/4, 2012 at 12:14
3
Solved
Using LibreOffice 4.1.2.3 in Ubuntu 13.10 I am desperately trying to export the content of a sheet (4 columns) into a pdf (portrait), so all 4 columns fit on a page. A page nicely explains all the ...
Sherbet asked 12/11, 2013 at 21:25
3
Solved
I need to extract a 'date string' as separate columns representing date/time data.
| A | B | C
-+--------------------------+-------------------+-----------------
1| Datetime String | Date Value |...
Solfeggio asked 4/9, 2017 at 16:7
2
Solved
I don't find how to use cell ranges with functions.
I vainly searched some examples.
I wrote the following test. I get "Object variable not set" error on both "for" lines (one is without "RangeA...
Governor asked 10/10, 2015 at 21:12
2
Solved
In the spreadsheet I want to automatically highlight row once a particular cell value is entered.
I've configured H column with list values: [valid,invalid] in Data→Validity.
The idea is to apply ...
Myca asked 19/9, 2014 at 3:7
3
Solved
I'm trying to test some algorithms in LibreOffice Calc and I would like to have some global variables visible in all cell/sheets. I searched the Internet and all the posts I have seen are so crypti...
Hailee asked 22/11, 2017 at 10:21
1
Solved
I want to implement some conditional formatting in LibreOffice Calc (v5.4.4.2 but can upgrade) that will highlight cells whose values are calculated through a formula rather than entered directly.
...
Cavern asked 28/3, 2018 at 8:42
1
I have a set of CSV files, which I need to convert to a single ODS (or even excel) spreadsheet with multiple tabbed worksheets. Currently I'm using the pyexcel library for python, but it's buggy an...
Kerwon asked 31/8, 2015 at 3:18
1
Solved
I've got a LibreOffice Calc spreadsheet that I use to keep track of my accounts receivable at work. Each sheet lists invoices and their status (paid, unpaid, etc) as well as info about each invoice...
Electrotype asked 11/10, 2017 at 0:36
1
Solved
I need to calculate the difference between two Date Time fields in LibreOffice Calc, with the answer in hours, positive or negative. When there is a positive result =J2-I2 works, and returns answer...
Nikaniki asked 1/9, 2017 at 15:17
1
Solved
I have a table with several columns.
I want only the lines where target value is different from alg value. In this case where target is 1 and alg is 0. So, line 2, 4 and 5 should stay and line 3...
Musing asked 20/7, 2017 at 10:41
1
I have some values in one column (A) like this:
1. 5201890000018
2. 5201890000018
3. 5201890000018
4. 5010175810538
5. 5010175810538
6. 5010175810538
7. 5010175810538
8. 50008667
9. 50008...
Wagon asked 5/12, 2013 at 15:28
2
Solved
Let's say I have a Libreoffice.org Calc (maybe this goes for MS Excel too) object defined as the range $Sheet1.$A$1:$A$4.
I also have declared a constant with value 1. For this mockup purpose, let...
Marche asked 7/2, 2012 at 15:35
1 Next >
© 2022 - 2025 — McMap. All rights reserved.