Issue 103318 - Support for alternative namespace semantics
Summary: Support for alternative namespace semantics
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 3.1
Hardware: All All
: P3 Trivial with 1 vote (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: needmoreinfo
Depends on:
Reported: 2009-07-03 16:09 UTC by philhibbs
Modified: 2017-05-20 09:55 UTC (History)
5 users (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description philhibbs 2009-07-03 16:09:43 UTC
ODF spreadsheet formulae have, according to the standard, "a namespace prefix
specifying the syntax and semantics used within the formula". Microsoft have
chosen to indicate their syntax and semantics with the msoxl: namespace, in
which for example text cells are (in some circumstances) treated as numbers for
the purposes of cell arithmetic.

OOo should support the possibility of alternative namespaces, initially with
msoxl: support in addition to the native OOo namespace. The option to bulk move
formulae into the msoxl: namespace in order to be able to save a document that
Excel users can open might also be of value, but the user should be warned that
Excel might evaluate formulae differently to OOo (although this will happen to
them unannounced if they open an OOo document in Google Docs, for instance).

Other ODF implementations also differ from OOo in their treatment of text values
in numeric formulae, and these differences could be resolved if namespaces could
be agreed that indicate this difference in behaviour. It may be that they choose
to adopt Microsoft's msoxl: as their default namespace anyway since they are
more in line with Excel's behaviour than with OOo's.

Functionality could be included to assist users in migrating formulae from
msoxl: or other namespaces to the native OOo namespace, performing speculative
evaluation in both in the original semantics and the native OOo namespace
semantics and identifying cells whose results differ.
Comment 1 philhibbs 2009-07-03 16:10:46 UTC
See also Issue 101471 and Issue 5658
Comment 2 cno 2009-07-09 21:20:19 UTC
thanks ..
Comment 3 Edwin Sharp 2014-01-10 13:55:55 UTC
Please attach example.
Comment 4 Edwin Sharp 2014-01-23 07:35:42 UTC
No info from author.