Launchpad has imported 5 comments from the remote bug at https://bugs.documentfoundation.org/show_bug.cgi?id=138388.
If you reply to an imported comment from within Launchpad, your comment will be sent to the remote bug automatically. Read more about Launchpad's inter-bugtracker facilities at https://help.launchpad.net/InterBugTracking. ------------------------------------------------------------------------ On 2020-11-21T08:49:33+00:00 Stevemfanning-wh wrote: Description: Unable to find any combination of arguments that give a meaningful result for either function. Constantly return #VALUE! Code inspection of GetOddfprice and GetOddfyield functions in file source/analysis/analysishelper.cxx seems to indicate that both unconditionally throw a runtime exception. AOO Bugzilla #92177 also refers. Steps to Reproduce: See Description Actual Results: See Description Expected Results: See Description Reproducible: Always User Profile Reset: No Additional Info: Version: 7.0.2.2 (x64) Build ID: 8349ace3c3162073abd90d81fd06dcfb6b36b994 CPU threads: 6; OS: Windows 10.0 Build 19041; UI render: Skia/Vulkan; VCL: win Locale: en-GB (en_GB); UI: en-US Calc: threaded Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1997587/comments/0 ------------------------------------------------------------------------ On 2020-11-21T09:29:01+00:00 julien2412 wrote: Seems like that since: https://cgit.freedesktop.org/libreoffice/core/commit/?id=2f0d97cd957cdb3113d98cbc441a923a43367547 author Daniel Rentz <[email protected]> 2001-09-26 12:22:24 +0000 committer Daniel Rentz <[email protected]> 2001-09-26 12:22:24 +0000 commit 2f0d97cd957cdb3113d98cbc441a923a43367547 (patch) tree d13dfd89a8e98f081692a92c7fb56bb33dfc0ae2 parent f5b732c43a9ed9ace11412d85dacd96d849fcde1 (diff) #87380# return error for ODDF(PRICE|YIELD) due to faulty algorithms Eike: should we remove these functions or should we still wait for someone try to implement them? (I found these links from MS: https://support.microsoft.com/en-us/office/oddfprice-function-d7d664a8-34df-4233-8d2b-922bcf6a69e1 http://www.mit.edu/~mbarker/formula1/f1help/05-n-s18.htm ) Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1997587/comments/1 ------------------------------------------------------------------------ On 2020-11-23T18:37:13+00:00 Eike Rathke wrote: Removing the functions wouldn't help anything except changing the error from #VALUE! to #NAME? ... Keeping them has the benefit that when a document is saved as old .xls binary format then the macro class is preserved due to the implementation as Add-In and it would (continue to) work in Excel. Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1997587/comments/2 ------------------------------------------------------------------------ On 2020-11-23T18:44:05+00:00 julien2412 wrote: (In reply to Eike Rathke from comment #2) > Removing the functions wouldn't help anything except changing the error from > #VALUE! to #NAME? ... Just decruftify a bit the code > > Keeping them has the benefit that when a document is saved as old .xls > binary format then the macro class is preserved due to the implementation as > Add-In and it would (continue to) work in Excel. Didn't know about this part. Ok I understand better now why this thing is still there unimplemented after so many years. Thank you for the feedback! :-) Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1997587/comments/3 ------------------------------------------------------------------------ On 2021-02-10T09:39:30+00:00 Olivier Hallot wrote: Both functions are in ODFF standard. https://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os- part2.html#__RefHeading__1018292_715980110 Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1997587/comments/4 ** Changed in: df-libreoffice Status: Unknown => Confirmed ** Changed in: df-libreoffice Importance: Unknown => Medium -- You received this bug notification because you are a member of Desktop Packages, which is subscribed to libreoffice in Ubuntu. https://bugs.launchpad.net/bugs/1997587 Title: Calc ODDFYIELD function gives #VALUE error Status in LibreOffice: Confirmed Status in libreoffice package in Ubuntu: New Bug description: Using ODDFYIELD function gives #VALUE error see attached ods file ProblemType: Bug DistroRelease: Ubuntu 22.10 Package: libreoffice-core 1:7.4.2~rc3-0ubuntu1 ProcVersionSignature: Ubuntu 5.19.0-23.24-generic 5.19.7 Uname: Linux 5.19.0-23-generic x86_64 ApportVersion: 2.23.1-0ubuntu3 Architecture: amd64 CasperMD5CheckResult: pass CurrentDesktop: ubuntu:GNOME Date: Wed Nov 23 18:37:51 2022 ExecutablePath: /usr/lib/libreoffice/program/soffice.bin InstallationDate: Installed on 2022-10-21 (33 days ago) InstallationMedia: Ubuntu 22.10 "Kinetic Kudu" - Release amd64 (20221020) SourcePackage: libreoffice UpgradeStatus: No upgrade log present (probably fresh install) To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1997587/+subscriptions -- Mailing list: https://launchpad.net/~desktop-packages Post to : [email protected] Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp
