Summary: | support for var.p and var.s needed | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Justin <justinjovic> |
Component: | Spreadsheet | Assignee: | Winfried Donkers <winfrieddonkers> |
Status: | RESOLVED FIXED | QA Contact: | Joel Madero <jmadero.dev> |
Severity: | enhancement | ||
Priority: | low | CC: | jmadero.dev, justinjovic, winfrieddonkers |
Version: | 4.0.0.3 release | ||
Hardware: | Other | ||
OS: | All | ||
See Also: |
https://bugs.freedesktop.org/show_bug.cgi?id=70000 https://bugs.freedesktop.org/show_bug.cgi?id=70797 https://bugs.freedesktop.org/show_bug.cgi?id=70798 |
||
Whiteboard: | ProposedEasyHack target:4.2.0 | ||
i915 platform: | i915 features: | ||
Bug Depends on: | |||
Bug Blocks: | 70798 | ||
Attachments: | testcase file created with Excel 2013 |
Description
Justin
2013-02-17 12:49:44 UTC
I can confirm that this is a valid enhancement request, currently it's just not supported so adding it is an additional feature. Version 4.1.0.0.alpha0+ (Build ID: 9a46e5614f5a0e0bdce3c497f81ca529da8fb5c) Date: Mon Mar 18 18:59:09 2013 +0100 Platform: Bodhi Linux 2.2 x64 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + As I've been able to confirm the enhancement request I am marking as: New (confirmed) Enhancement Low - might prevent specific users from being able to use Spreadsheet (not many most likely), probabyl quite easy to fix though Keywords - Whiteboard Status - ProposedEasyHack + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + LibreOffice is powered by a team of volunteers, every bug is confirmed (triaged) by human beings who mostly give their time for free. We invite you to join our triaging by checking out this link: https://wiki.documentfoundation.org/QA/BugTriage There are also other ways to get involved including with marketing, UX, documentation, and of course developing - http://www.libreoffice.org/get-help/mailing-lists/. Lastly, good bug reports help tremendously in making the process go smoother, please always provide reproducible steps (even if it seems easy) and attach any and all relevant material @Justin: Could you upload an xlsx file with the var.p and var.s functions used as an attachment to this bug? And possibly with more functions as listed in http://office.microsoft.com/en-us/excel-help/what-s-new-changes-made-to-excel-functions-HA010355760.aspx (except covariance.p/covariance.s, these have been fixed with bug 70000) ? I know how to fix it, but I haven't got Excel, so I can't test the fix... Created attachment 88375 [details]
testcase file created with Excel 2013
Winfried Donkers committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=781363934af5c0ff3401161c385c6c93c9352c2c fdo#61002 add Excel 2010 functions VAR.P and VAR.S The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. |
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.