Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenTue, 10 Sep 2019 23:02:51 +0200Calc backup files all zero KBshttps://ask.libreoffice.org/en/question/208160/calc-backup-files-all-zero-kbs/Why are my calc backup files all zero KBs?
There are also dozens of backup files for a particular time. There is only supposed to be one every 10 minutes. Very odd.
It happens with all version of calc that I have run.GriffinitTue, 10 Sep 2019 23:02:51 +0200https://ask.libreoffice.org/en/question/208160/Calc:Conditional formatting-How to stop empty cell being treated as zero?https://ask.libreoffice.org/en/question/200887/calcconditional-formatting-how-to-stop-empty-cell-being-treated-as-zero/ Version: 5.1.1.3
Context:
I am using the numerical value of a cell in one column to change the background colour in the adjacent one using the conditional formatting tool.
I have 3 formulae which are working fine except when the source cell is empty. The "treat empty cells as zero" option is NOT turned on but the result of this formula returns the result as if it were zero. I have tried conditions using both a formula and a cell value to return either "" or a white background in the first and last positions in the condition ladder but no joy.
The formula is "IF((AND(P17>=0,P17<6)))" which works perfectly well for the value range in the source cells.
Any help would be very gratefully received:-)
CantagrilFri, 12 Jul 2019 13:17:39 +0200https://ask.libreoffice.org/en/question/200887/Can we return an empty cell instead of Zero by keeping the formula ?https://ask.libreoffice.org/en/question/182197/can-we-return-an-empty-cell-instead-of-zero-by-keeping-the-formula/Hello,
I would like to copy (on calc) and paste (in my mailbox) a list of mails that has been generated by a Paste Special with the option "Link" checked.
The problem is that when the referring cell is empty, the "linked" cell returns a zero.
The result: the copied email list contains mails and zeros.
(Note: On Calc, "Paste Text Only" allows omitting zeros when pasting.)
Thank you all for your help !
BiGThu, 07 Feb 2019 11:27:09 +0100https://ask.libreoffice.org/en/question/182197/How do I get Base report to display null instead of zero?https://ask.libreoffice.org/en/question/177854/how-do-i-get-base-report-to-display-null-instead-of-zero/ I am not finding a setting in page format to suppress printing zero values. Does one exist?RichardZRMon, 31 Dec 2018 18:56:54 +0100https://ask.libreoffice.org/en/question/177854/Align Zeros on Primary and Secondary Y Axes?https://ask.libreoffice.org/en/question/160841/align-zeros-on-primary-and-secondary-y-axes/I have created this chart in Calc with two curves that align to different Y axes. Although they are wildly differing scales, I would like the zeros to lign up, to show visually that the red line (secondary Y axis) plunges into the negative whereas the blue line (primary Y axis) is always positve.
![image description](/upfiles/15317583409517144.png)David.CheshireMon, 16 Jul 2018 18:35:34 +0200https://ask.libreoffice.org/en/question/160841/How I suppress zero values in spreadsheethttps://ask.libreoffice.org/en/question/160475/how-i-suppress-zero-values-in-spreadsheet/ I have a spreadsheet which looks good on t.he screen but prInts all zero values. I would like zero values not to be printed at all. I'm sure it's simple but just can't see how to do it.Glyn-eThu, 12 Jul 2018 16:12:16 +0200https://ask.libreoffice.org/en/question/160475/How to zeroe the last 3 digits of a number (not rounding)https://ask.libreoffice.org/en/question/148968/how-to-zeroe-the-last-3-digits-of-a-number-not-rounding/In LibreOffice Calc, how do I zeroe the last 3 digits of a number
e.g.
123,456,789
gives
123,456,000
Note that numbers are integers. There is no decimal part.Libre comme un oiseauMon, 12 Mar 2018 09:22:44 +0100https://ask.libreoffice.org/en/question/148968/How to show zero values in redhttps://ask.libreoffice.org/en/question/145767/how-to-show-zero-values-in-red/ I have a spreadsheet of various currency values. I want zero values to be formatted in red. Negative values are currently in red, but I can't figure out how to extend that to zero. I looked into conditional formatting and creating styles, and I'm just not understanding how I can accomplish this.nitmdThu, 08 Feb 2018 21:49:53 +0100https://ask.libreoffice.org/en/question/145767/How to use "assume zero" on data series without messing up dates?https://ask.libreoffice.org/en/question/138385/how-to-use-assume-zero-on-data-series-without-messing-up-dates/Hello everyone,
I'm trying to use 'assume zero' on data series in a chart with dates on the x-axis.
Whenever i try to use it the x-axis get's messed up and shows dates starting with 1999 instead of the entered values.
Is there a trick, so it only shows the entered dates?maxbSat, 18 Nov 2017 16:33:24 +0100https://ask.libreoffice.org/en/question/138385/Solved: Calc: Concatenate does not carry over leading zerohttps://ask.libreoffice.org/en/question/68703/solved-calc-concatenate-does-not-carry-over-leading-zero/ I am combining data from three fields into one. The first column is "Hour", the Second "Minute", and the third "AM/PM". Data in the first two columns is numeric, and for the third column it is either blank, A, or P (text). In the minutes column, 00 is represented as 0, and 05 is 5, and so on. I revised the format for this column so it would have leading zeros, so became 00. When I use concatenate (along with a : between them) the leading zeros disappear, so for example 8:00 is displayed as 8:0. I've read I can format the minutes as text, however won't they need to be recognized as numbers for when I convert the time to 24 hour format? The end result of these cells is that I will have them not as 8:00 PM but rather 20:00.Crash16Sat, 23 Apr 2016 03:31:49 +0200https://ask.libreoffice.org/en/question/68703/How do I get base to display 0 value instead of NULL?https://ask.libreoffice.org/en/question/22583/how-do-i-get-base-to-display-0-value-instead-of-null/I have tried many different ways using SQL in the queries and using formulas in the report builder and have had no success getting it to insert 0 in place of NULL values.
For example I tried: IF(ISBLANK([OrderAdjustments]);0;[OrderAdjustments]) in the reports
In the Base Guide in chapter 6 it says to use IF([numericfield];[numericfield];0) which I tried also without success.
I tried a CASE WHEN ELSE END statement in my SQL queries without success.
How do I get the database to replace Null values with zero?
Libre LyraeFri, 13 Sep 2013 17:22:30 +0200https://ask.libreoffice.org/en/question/22583/My simple formulas no longer give blank cellshttps://ask.libreoffice.org/en/question/28295/my-simple-formulas-no-longer-give-blank-cells/ I have used simple formulas like =IF(B10>0,+B10-B9,"") for years and have always returned a blank cell. Worked fine in Libreoffice until a recent update and now it will not return a blank cell, instead it returns zeros. I see where I can turn off " show zero values" but then I can't have other cells where I want to display zero as a value. Is there a way to return to showing a blank cell instead of zeros while retaining the ability to display zeros where I choose?
Added comment:Using windows 8.1 and Libre Version: 4.1.4.2
Build ID: 0a0440ccc0227ad9829de5f46be37cfb6edcf72RCMSun, 12 Jan 2014 23:42:37 +0100https://ask.libreoffice.org/en/question/28295/