0
votes
1answer
58 views

How to get plain text, colon separated file into spreadsheet with data separated into columns

I received a digest of registrations for events. The fields are separated by colons and in plain text. Can I copy and paste this info into libreoffice spead and get it displayed in columns?
0
votes
0answers
45 views

Search and replace with different formatting style

In LibreOffice or OpenOffice Calc spreadsheet, is it possible to search-replace while changing formatting of the replacement text to subscript or superscript at the same time? I have a spreadsheet ...
4
votes
1answer
226 views

Is it possible to access and edit Google documents directly from Libreoffice?

I'd like to work with a Google spreadsheet directly inside Libreoffice, without having to export and import it, in order to automatically reflect the changes on the online file. Basically, I'm looking ...
3
votes
2answers
6k views

Is it possible to copy & paste a pivot table in a spreadsheet?

I have a spreadsheet where I use some pivot tables to summarize and highlight some relevant data. Since I have to use multiple pivot tables, all with nearly the same data input but with slight ...
1
vote
3answers
992 views

What Excel formats are (most) compatible with LibreOffice and Google Docs? [closed]

I use Excel (and occasionally Numbers), but I want to be able to share with users of Google Docs and LibreOffice (and I may want to switch in the future). What's the most compatible format to save my ...
3
votes
3answers
1k views

How do you find the maximum value in a column, skipping to every nth value?

Using LibreOffice's Calc program (nearly the same functionality as Microsoft Excel) I have a set of numbers in column T, which represent numbers for the week (with labels in S). Each week's worth of ...
5
votes
5answers
816 views

Does any spreadsheet allow you to create your own functions?

I've always been frustrated when using spreadsheets by the inability to define my own functions when there is no existing function to (cleanly) do what I want. Does any spreadsheet offer this ...
2
votes
2answers
6k views

How can I print Excel spreadsheet files automatically?

My company has computer-generated reports that come out as Excel spreadsheets which are emailed to the Billing Department. They would like these reports to be automatically printed as they are ...
3
votes
2answers
347 views

How do I access the search functionality in Open Office?

I am very new to oo and plodding slowly; never used a spreadsheet, etc.etc. I downloaded a document of botanical names for flowers/herbs, etc. The page was set in 3 columns and was 138 pages long (!) ...
4
votes
1answer
774 views

Custom CSV (.csv) filter for OpenOffice.org or LibreOffice?

Is it possible to create a some kind of 'custom CSV filter' for OpenOffice.org or LibreOffice spreadsheet program. What I need is to have the program to use predefined CSV settings for loading and ...