Issue 107435 - CONVERT function needed calc.xcu and now might benefit from an extension to maintain conversion factors in the new configuration
Summary: CONVERT function needed calc.xcu and now might benefit from an extension to m...
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: configuration (show other issues)
Version: DEV300m66
Hardware: All All
: P3 Trivial with 1 vote (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-12-04 09:04 UTC by oc
Modified: 2013-02-07 22:38 UTC (History)
3 users (show)

See Also:
Issue Type: FEATURE
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments

Note You need to log in before you can comment on or make changes to this issue.
Description oc 2009-12-04 09:04:21 UTC
The spreadsheet function CONVERT (not CONVERT_ADD) gets its conversion factors
out of the file calc.xcu. With cws_sb111 this file does not exists. So we need
an entry in the new config file or another method for this function. Also the
help has to be changed.
Comment 1 Stephan Bergmann 2009-12-04 09:36:35 UTC
The content of what used to be installed as
$OOO_BASE_DIR/share/registry/data/org/openoffice/Office/Calc.xcu is now part of
a larger file $OOO_BASE_DIR/share/registry/main.xcd, but the configuration set
/org.openoffice.Office.Calc/UnitConversion, and all its original content, is of
course still there (I assume that that is the relevant configuration data).

I see that the "in-line" documentation of CONVERT in the Calc Function Wizard
dialog states: "Converts a value according to a conversion table in the
configuration (calc.xcu) [sic, with a lowercase 'c']."  I find no mention of
Calc.xcu in the on-line help documentation of the CONVERT function, and no
mention at all that the conversion table can be extended by a user by manually
editing some Calc.xcu.

@oc:  Can you clarify the following, please:
(1)  My understanding is that this issue is not about a broken CONVERT function
(it still correctly obtains it data from the configuration), but only about the
Function Wizard mentioning a calc.xcu that does not exist.  Right?
(2)  Is there any documentation that a user can extend the conversion table?
Comment 2 Stephan Bergmann 2009-12-10 13:24:25 UTC
@oc: ping?
Comment 3 ooo 2009-12-11 13:13:07 UTC
@sb: Oliver is on vacation, I'll try to answer what I can, he showed me
a CWS build once before he left.

The CONVERT function is not broken, apparently the conversions were read
from the initial configuration, but somehow adding new conversions
wasn't possible, they weren't known to the application then. I just
retried using OOo_3.2.0_091210_unxlngi6_install.tar.gz from
sb111-instsets, but had NO problem adding a new conversion to
share/registry/main.xcd, it was known to the application after having
restarted it. We'd have to wait for Oliver to see if he did something
different.

The description in the Function Wizard certainly will have to be
changed. I don't think it was documented how exactly new conversions can
be added, the typical end user probably didn't know, but this feature
may have been used by enterprises to administrate daily exchange rates
of other currencies, for example. The online help has only "The
conversion factors are given in a list in the configuration."

For "ease of use" I'd prefer if the UnitConversion  node would be in
a separate file, but I guess given the rare use case this is not
justified.

Btw, the configuration files now consist of one long line of XML
elements, can't we at least have line breaks? Yes, I know xmlpp works
and XML editors probably would too.. anyway, would be easier to edit
using an ordinary editor.

Btw2, I like how schema and data are now in one file, but the <info>
elements with the descriptions are lost. Any plans to re-add them, and
if it was in separate schema files to not have them clutter up the
configuration itself? A configuration back-end now doesn't have the
chance to display them. Or did I miss something?
Comment 4 Stephan Bergmann 2009-12-11 13:45:10 UTC
@er, re btw1/2:  .xcd files are generated from .xcs/.xcu files through
solenv/bin/packregistry.xslt, which removes "non-content" whitespace and
"documentation" elements that are ignored by the current configmgr
implementation (like <info>), following the rationale that those files are
mainly for programmatic consumption by configmgr (where speed is important, so
simply leave out everything irrelevant), and that manual modification is of
secondary importance only (and the dropped "documentation" elements are still
available in the original OOo source .xcs files, for reference).
Comment 5 Stephan Bergmann 2010-02-09 08:51:17 UTC
@oc: please clarify how to proceed
Comment 6 oc 2010-02-16 08:32:56 UTC
Hi Eike, as discussed the best way would be to allow the changes via an extension
Comment 7 ooo 2010-02-16 11:32:15 UTC
Funny guy, discussed with whom? Yes, an extension might be nice to have, but no,
I'm not the owner of this, especially not for OOo3.3, retargeting and
reassigning to requirements.

@sb: re btw2: without the <info> elements a generic configuration tool is not
able to display the descriptions of the actual configuration. It would have to
be updated for every release now.
Comment 8 ooo 2010-02-16 11:50:00 UTC
Created issue 109323 for function wizard's description and help text.
Comment 9 Stephan Bergmann 2010-02-16 12:30:38 UTC
@er, re btw2:  I am not sure a generic configuration tool is desired.  The
configuration files should be considered implementation details of configmgr. 
The stable interface is the configmgr UNO API and the mechanism by which
extensions can bring along .xcs/.xcu files.