Feb 6, 2013 · Tools - Options - LibreOffice Calc - View - (uncheck) Zero Values. This is only of limited use, as it turns all zeros into the empty string. So if the source cell really contains “0”, …

Mar 18, 2015 · I want to calculate age like Years, Months and Days between Date_Of_Birth and Todays Date. Its work fine in EXCEL =DATEDIF() function, But Libreoffice Calc i could not …

Feb 15, 2013 · libreoffice calc had / has a problem with ‘shared formulas’ randomly blocking autocalculate since years, i think 4.1.6.2 was the last ‘save’ version (it was without ‘shared …

Jun 28, 2013 · Boa tarde. Estou tentando usar a função SE do Calc, mas estou com dificuldade de colocá-la no seguinte argumento: Quando A2 for COMBUSTÍVEL ou ABASTECIMENTO, …

Jul 8, 2014 · Your text after “It does …” is unreadable for me. Try to write a grave accent before and after a formula to hide special characters like < to be interpreted as html tag, or write the …

Jan 30, 2013 · I frequently have to plot frequency of occurrence of values using varying window sizes and it is frustrating apparently not to be able to do it in Calc without having to pre …

Feb 11, 2014 · I’d like to create a dropdown menu in calc to reference a selection of cells. For example, a drop down menu might contain a list of foods at A1 and selecting one would result …

Oct 6, 2020 · Hopefully I can explain this logically, bear with me 🙂 Currently, I have a sales sheet where I enter the details of our sales. DATE | PRODUCT SOLD | QTY SOLD | CUSTOMER …

Feb 10, 2016 · Hi guys, Can someone tell me what the default settings for “Iterations” are in Calc? To what amount should I set “Steps” and “Minimum change”? I would also like to know what …

Aug 3, 2017 · Good afternoon, I would like to ask you for the advice with the following problem in Calc: column A contains a date in the format DD.MM.YYYY in column B I would like to display …