Description: I am not sure what is mathematically distorting with the spreadsheet, as 63% of a population size turns out to be a proportion that is too small. I was trying to work out a margin of error. Further reading 1. https://en.wikipedia.org/wiki/Margin_of_error 2. Original information sourced from www.timesofmalta.com on a custom control. Steps to Reproduce: 1. Open the attachment and read the sheet 'persentagg'. Sheet cells H2:H4 are proportions that do not reflect the basic mathematical operators. Actual Results: The actual results are difficult to compare for the literate reader. Expected Results: I doubt whether they are correct, and, whether mathematical proof can be made available through some plug-in as this would help me. Reproducible: Always User Profile Reset: No Additional Info: By the way is a Maltese-language version [ISO-639-2] of Libre Office planned to be available or is a plug-in already available? Is a web-based version of LibreOffice planned to be written? User-Agent: Mozilla/5.0 (Windows NT 6.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/49.0.2623.112 Safari/537.36
Created attachment 133020 [details] stat.xlsx
> Is a web-based version of LibreOffice planned to be written? https://www.collaboraoffice.com/code/ https://gerrit.libreoffice.org/gitweb?p=online.git;
Not database related, changing module to Calc. Potentially, this could be a filter problem.
(In reply to John Smith from comment #0) > Description: > I am not sure what is mathematically distorting with the spreadsheet, as 63% > of a population size turns out to be a proportion that is too small. > > I was trying to work out a margin of error. > > Further reading > 1. https://en.wikipedia.org/wiki/Margin_of_error > 2. Original information sourced from www.timesofmalta.com on a custom > control. > ..... > Actual Results: > The actual results are difficult to compare for the literate reader. > > Expected Results: > I doubt whether they are correct, and, whether mathematical proof can be > made available through some plug-in as this would help me. > I don't know what it's the meaning for formulas on H dividing percents by the population, but results are correct. If the issue is with the format, then formating H cells on a prefered way, should help. I can't see any bug here.
John: are you cool with closing this as NOTABUG?
Dear Bug Submitter, This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INSUFFICIENTDATA due to lack of needed information. For more information about our NEEDINFO policy please read the wiki located here: https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/NEEDINFO If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed. Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-NeedInfo-Ping-20171204
Does the attachment help to highlight the issue?
(In reply to John Smith from comment #7) > Does the attachment help to highlight the issue? I was kind of hoping we could close this as "not a bug" per: (In reply to m.a.riosv from comment #4) > I don't know what it's the meaning for formulas on H dividing percents by > the population, but results are correct. > If the issue is with the format, then formating H cells on a prefered way, > should help. > I can't see any bug here. If you disagree, please answer Miguel's question in detail.
What is supposed to be in column H? If you want simply the number people based on the total population and percentage, simply multiply the two numbers. Additionally, the Other field is calculated incorrectly, it should be 100% minus the other two percentages (the three entries in the same column should add up to 100%). Note that if this is related to political party preferences (guessing based on the names PL and PN), then it doesn't seem to be correct to use the whole population for reference, only those who are eligible to vote (or even those who have a definite choice, otherwise there is an uncertain category as well). Regarding your other questions, currently there's no Maltese language version of LibreOffice, most likely because of lack of Maltese contributors (it is always planned, but it's up to the language-specaking community to step up). There is a web-/cloud-based LibreOffice called LibreOffice Online. Closing as WORKSFORME, please reset status to UNCONFIRMED if you still think there is a bug somewhere in LibreOffice.