0
votes
0answers
32 views

How to format pennies as dollars in LIbreOffice currency formatting?

I have data in a LibreOffice Calc spreadsheet with penny values, such as 001234 to represent $12.34 (twelve dollars and thirty-four cents). How can I define a format that will display these values as ...
-1
votes
1answer
86 views

Change background fill of cells in LibreOffice worksheet containing specific text

How can I change the background fill of all the cells of a LibreOffice spreadsheet worksheet that contain a specified text? In Excel that could be done by configuring the settings in the find and ...
1
vote
0answers
58 views

Default font and cell padding when opening files in LibreOffice/OpenOffice Calc

I've seen solutions for setting a default font when creating new files. What about a default font (and cellpadding) when opening an existing CSV file? LibreOffice seems to always default to Liberation ...
0
votes
0answers
48 views

Disable prompt when opening a CSV file in LibreOffice/OpenOffice Calc

Every time I open a CSV file, LibreOffice presents me with a prompt asking to confirm Character Set, Language, and Separator options (tab, comma, semicolon etc). This prompt is not present in ...
0
votes
1answer
92 views

Libre Calc error on a float in decimal notation. Err. 519 (#value error)

There is a problem with my libreoffice. I doesn't calculate cells with decimal points, possibly seeing them as text. I have checked my locale settings (you can see them in the picture above) that ...
1
vote
2answers
453 views

Move rows with the keyboard in Calc

How might one move a row to a different location with the keyboard? I have found this guide for the mouse but due to disability I have trouble using the mouse for this. Note that I am not looking to ...
3
votes
1answer
193 views

Is there a way to set the default quotation mark in LibreOffice Calc from smart quotes (“ ”) to dumb quotes (the straight kind)?

I use LibreOffice Calc to make lists of programs with different parameters to run on an hpc cluster. For each batch of commands I must do a find and replace on the smart quotes, as they cause errors ...
0
votes
1answer
348 views

How can I use extremely large numbers in my spreadsheet programs?

If I try to calculate large exponents in LibreOffice Calc or OpenOffice.org Calc, the results come out to be erroneous. See these two examples where I calculate 13^18, Using LibreOffice Calc Using ...
2
votes
1answer
3k views

Open Office Calc: Convert a date to timestamp

I have a column with dates in M/D/Y like this: 8/8/2007 8/9/2007 8/10/2007 8/13/2007 8/14/2007 8/15/2007 8/16/2007 I would like to convert them to a unix timestamp (in a new column). Would anyone ...
1
vote
1answer
3k views

How do I create a line graph which ignores zero values?

I want to create a graph showing trends over time, calculated from a formula of various data. However, some data is missing, resulting in zeroes in the calculated data which the chart uses. When ...
6
votes
2answers
7k views

How do I export the charts in a spreadsheet as PNGs?

I made a spreadsheet and generated some graphs in Calc. I would like to grab each chart as a PNG (JPG will be fine too) and save them as an individual file so I can post the charts on my blog. I ...