openoffice-calc Questions
4
I have a requirement to convert OpenOffice Excel data into XML . I have Apache OpenOffice 4.1.1 in my machine (not MS- Office).
Sample Data.
(First Row is of Tags )
CustData FirstName MiddleName...
Jobye asked 28/9, 2015 at 6:44
9
Solved
Basically, I want LibreOffice Calc to do what I tell it, not what it wants.
For example:
when I input 1.1.12, I want to have 1.1.12 in that cell, not 01.01.2012 or whatever.
when I input 001, ...
Frighten asked 12/12, 2012 at 7:59
3
Solved
I want to display random courses (MBA, MSc) in OpenOffice Calc. I tried:
=RANDBETWEEN('MBA', 'MSc')
and
=RAND('MBA', 'MSc')`
but they don't work as desired.
Turnage asked 9/12, 2013 at 8:31
6
Solved
I have a column in open office like this:
abc-23
abc-32
abc-1
Now, I need to get only the sum of the numbers 23, 32 and 1 using a formula and regular expressions in calc.
How do I do that?
I t...
Alodium asked 9/11, 2012 at 6:56
4
I have column A with these cells:
A1: Apple
A2: Banana
A3: Cherry
I want a formula that will string them together in one cell like this:
"Apple, Banana, Cherry"
Delve asked 1/12, 2016 at 11:29
5
Solved
I need to add .jpg at the end of all he cells in one or more columns
9788895249971 into > 9788895249971.jpg
9788867230129 into > 9788867230129.jpg
9788867230273 into > 9788867230273.jpg
9...
Mobile asked 20/5, 2013 at 5:4
3
Solved
In Excel, Office 2007, I have the option to highlight duplicate values on the menu. Keep simple! Select the column, select "Conditional Formatting" - "Highlight Cells Rules" - "Duplicate Values" an...
I asked 6/3, 2016 at 2:24
3
Solved
I have an spreadsheet-based automated report that needs to be created daily, with some charts, aggregating functions (e.g. SUM and AVERAGE) and formatted cells (Dates, percentage, etc.).
I have tr...
Overijssel asked 1/3, 2010 at 14:35
3
How can I change the #N/A to the blank cell if nothing in that cell?
Eg. =VLOOKUP(B19:B36;$TABLE.A1:C46;2;0)
I think I might need something like an ISERROR check but I don't 100% know what I'm d...
Kannry asked 20/3, 2014 at 7:52
2
I have 6 fields in a row in open office, the 1st is a word, the 2nd, 3rd, and 4th are a number with a leading zero, the 5th and 6th are regular numbers. How do I join them all together with a comma...
Vogel asked 31/5, 2012 at 15:30
3
In OpenOffice.org Calc, I would like to apply a formula to a column that references a cell from the same row but in a different column. I.e., =C1*48 in cell D1, but I want all cells in column D to ...
Britanybritches asked 21/3, 2011 at 0:41
2
Solved
I want to copy from the Ubuntu Linux clipboard into R Studio. My workflow consists of moving back and forth between R Studio and LibreOffice Calc. I've found the following code for writing to a Lin...
Weir asked 21/8, 2017 at 14:21
3
Solved
All,
Can python read the value of a cell in a spreadsheet?
From a mapping/GIS/analysis standpoint: the simplest example would be a script that ran a buffer (proximity) tool on a given shapefile (...
Pratfall asked 28/1, 2013 at 19:16
3
Solved
I have a list of text urls in, how i can convert all of them into clickable links?
Daffi asked 1/7, 2010 at 12:7
5
Solved
In OOCalc I want to use the CONCATENATE function to add quotes to each string in column A.
So in cell B1 I want to do:
=CONCATENATE("\"",A1,"\"")
OOCalc does not like this, or without the esca...
Chalybite asked 27/1, 2010 at 9:59
1
Solved
I'm having issues with a Open Office. I'm trying to export some files as CSV text and it appears that underscores and perhaps some other characters are being replaced. For instance, I created this ...
Rapier asked 12/8, 2016 at 17:41
2
Solved
I have a cell with some text content.
For example: "Red, shirt, size,"
I need to count how many times the comma is used in this cell.
The result should be "3"
Any ideas?
Dogeared asked 24/9, 2015 at 8:25
3
Solved
I am using OPEN-OFFICE to work and save CSV. I am using the comma delimiter and ' " ' also. However, when saving the CSV, all numbers are not encapasulated. How can I force Open-Office to treat num...
Faithless asked 5/6, 2012 at 21:57
4
Solved
So I have written a class that makes it extremely easy to interface with either Excel or Gnumeric using Python, and would like to extend the class to include Open Office as well. I could do this in...
Leggett asked 24/3, 2011 at 0:46
2
Solved
I have two column in open office calc.
I want to merge then like following
name last name fullname
john carter
name last name fullname
john carter john carter
How to do this?
Homogenesis asked 27/12, 2013 at 7:52
3
Solved
I have two CSV files with a common column and I want to "Join" the tables together on the common column.
For example: Join 'A' with 'B' equals 'Result'. If a one table has a key value that does n...
Pinochle asked 11/11, 2010 at 23:21
1
In an UNO extension for OpenOffice/LibreOffice Calc (Spreadsheet), written in Java, how can you determine the calling cell inside the implementation of a UDF (spreadsheet function)?
Remarks
In E...
Aeroscope asked 14/7, 2013 at 8:4
1
Solved
I have a column in openoffice calc with a set of codes. For example:
B1
B1
Br
Bh
Ht
C3
C3
So what I would like to do is delete all the duplicates so I am left with just:
Br
Bh
Ht
Any help muc...
Mallorie asked 19/3, 2014 at 16:5
1
I'd like to filter out rows with a specific color on a specific column.
I tried to search nearly everywhere but couldn't find my answer.
Hope for some good advice, thanks.
Casals asked 9/10, 2013 at 10:21
1
Can you please advise on how can I use COUNTIF with multiple conditions?
My proposal (left) shows the formula for one criterion (distinct regions).
However, I am interested in counting distinct...
Tommie asked 20/6, 2013 at 14:11
1 Next >
© 2022 - 2025 — McMap. All rights reserved.