https://bugs.documentfoundation.org/show_bug.cgi?id=161599

--- Comment #10 from Eike Rathke <[email protected]> ---
Reading sample.xlsx I do not get a #NAME? error with any version (tried
25.2.0.0.alpha0+, 7.4.7.2.0+ and 24.2.6.1.0+) neither with the Archive.zip's
sample.xlsx nor the sample.xlsx of xevalai.oxt. They both have
COM.XEVALAI.XEVAL.OXT.INCREMENTBYONE(1) stored. Replacing that with
INCREMENTBYONE(1) in xl/worksheets/sheet1.xml though yields #NAME? error.
Saving (a working INCREMENTBYONE(1)) to .xlsx however it uses the full
programmatic name. I can't even install the extension successfully in 7.3.7 or
any earlier I tried (might be on my self-built side), so can't say if it really
stored INCREMENTBYONE(1) instead of the full programmatic name.

What we maybe could do is if a (English) CompatibilityName was defined (which
may even be locale-dependent, thanks to Excel's weirdos) in the .xcu, i.e.
INCREMENTBYONE, to store that and also read it.

However, that could not be read by older LibreOffice versions that could read
the full programatic name, so isn't ideal either. YMMV..

In any case we probably could recognize such CompatibilityName when reading
from .xlsx as well (that mechanism originally was for .xls BIFF).


(CompatibilityName in addin.xcu would be to add

 <prop oor:name="CompatibilityName"><value
xml:lang="en">INCREMENTBYONE</value></prop>

for example after the oor:name="Category" property).

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to