https://bugs.freedesktop.org/show_bug.cgi?id=44720
Bug #: 44720
Summary: EasyHack: compatibility options for older spreadsheets
...
Classification: Unclassified
Product: LibreOffice
Version: unspecified
Platform: Other
OS/Version: All
Status: UNCONFIRMED
Severity: major
Priority: medium
Component: Spreadsheet
AssignedTo: [email protected]
ReportedBy: [email protected]
bug #37860# has some complaints about changes to behaviour of some corner cases
in calculation to make us more interoperable.
It would be good to add some per-document settings that are tweak-able to allow
these things to be altered. I snip Kohei's description:
[snip]
The goal: introduce a configuration option to toggle this behavior in an
user-friendly way. One idea is to use the Formula options page to add such
option. But consult with the UX people on the
[email protected] to get their opinion on how such
configuration option should be introduced.
...
Also, there are other conflicting formula behaviors between OOo and Excel, so
it's probably best to make such option extensible to make it easier to add more
configuration options in the future.
...
Code pointer:
Formula interpreter:
* sc is the module where all the Calc code is kept, including the formula
interpreter code (look for class ScInterpreter).
* ScInpterpreter::GetCellValueOrZero() is the method that gets called to
retrieve the value of another cell. This method is relevant for this easy
hack.
Configuration options:
* This configuration option should be stored with the document, so look for
ScDocOptions class to add a new document configuration option (also in sc). It
has one child class ScDocCfg, which handles loading and storing of the options
from and to the user configuration directory. Add the new option to the
aFormulaItem member.
* Now, every user configuration option needs to be defined in the officecfg
module. Look for officecfg/registry/schema/org/openoffice/Office/Calc.xcs.
The new option should be under the "Formula" group.
UI:
* First, you need ask on
[email protected] about how best to add this new
configuration option in the UI - no subscription is required.
* Tab pages for Calc related options pages are all located in
sc/source/ui/optdlg.
I hope this is enough pointer to get started.
--
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
