Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenSun, 22 Dec 2013 09:32:06 +0100DSUM just doesn't work even using the example in LO helphttps://ask.libreoffice.org/en/question/27410/dsum-just-doesnt-work-even-using-the-example-in-lo-help/I just can't seem to get DSUM to work. Even when I type in the example in LO Help (ie Distance to school for grade 2) exactly. It just returns 0 instead of the value 1950 indicated in the Help, yet when I load the spreadsheet into Excel it seems to calculate it properly. I am running OSX 10.6 and have tried with both LibreOffice 4.1.4.2 and 4.2 RC1 without success. In case it matters, I have tried it with Java SE 6 (ver 1.6.0_65-b14-462) both turned on and off and restarting LO each time with not success. I would really like to start using LO, so would really appreciate if anyone could shed some light on this issue. Basically, I have a number of working spreadsheets in Excel using this database function and they don't work in LO. The other thing to mention is that there are several sheets in the spreadsheet and the DSUM formulas are on the third and fourth sheet but note that all references within the DSUM parameter list are to references on the same sheet as the DSUM formula.
Thanks so much.ChrisCSun, 22 Dec 2013 09:32:06 +0100https://ask.libreoffice.org/en/question/27410/Search criteria for DSUM functionhttps://ask.libreoffice.org/en/question/21262/search-criteria-for-dsum-function/I am trying to use Libre Office Calc to carry out an inventory management simulation.
There is a column headed "Day" containing the number of days from the start of the simulation. There is a column headed "Order quantity" containing the quantity ordered on that day. There is a column headed "Arrival day" containing the number of the day on which that order is expected to arrive.
There is a column headed "Received". Each cell in that column will contain a DSUM function giving the total quantity expected to be received from the supplier on that day. That quantity is the total of the numbers in the "Order quantity" column for which "Arrival day" is equal to the value of "Day" in the row containing the DSUM function concerned. I can't find any method of specifying this search criterion.
If it is not possible to do this using DSUM then is there any other way of doing it in Calc?RangitotoFri, 09 Aug 2013 00:46:44 +0200https://ask.libreoffice.org/en/question/21262/