- edited description
OpenXML Filter: XLSX: expose numbers, dates and booleans as metadata
This is a follow-up to issue .#1062
We are extracting inline (issue #982) and shared strings as metadata. And it would be reasonable to have numbers, dates and booleans extracted as well.
Below is a sample document for references:
And here are some peculiarities of it:
- Number
2. Boolean
3. Date
4. Date-time
5. Number function
6. String function
For more details please refer to the attached document.
Comments (10)
-
reporter -
reporter Related pull request #578 was opened.
-
reporter - changed milestone to 1.43.0
-
reporter - changed status to resolved
A solution merged in the scope of pull request #578.
-
In rainbow 1.46.0 (latest) as well as 1.43.0 converting to xliff doesn’t keep the numbers. And i couldn’t find а configuration option for it, is the option to expose numbers, dates etc not included in rainbow?
-
reporter @Marko Doda you are talking about exposing numbers, dates and booleans as metadata, aren’t you? All available worksheet configurations are documented in the Okapi Wiki.
-
@Denis Konovalyenko
The issue that we are having with Marko, is basically that the numbers are not even showing up in the xliff.
I am not sure if this is the right issue to comment about it, but basically we are having simple xlsx file that has cell with value
1234
. In the output of the xliff, this segment is no where to be found. I am not sure if this is an issue because the1234
cell is not found in thesharedStrings.xml
or something else is going on.The actual XLSX file:
The sharedStrings.xml:
The worksheet xml that contains the value
1234
:Does it makes sense?
And the
1234
is not found in the exported XLIFF, tried it with different files. -
reporter @Stefan Brankovik thank you for letting me know more about your expectations on this!
Now I see that you are looking for the extraction of numbers. I am afraid, this issue was for extracting numbers, dates and booleans as metadata only - please find out some usage details in the scope of the
net.sf.okapi.filters.openxml.OpenXmlXlsxTest#booleansAndNumbersExtractedAsMetadata
test case.Do you think you would be able to share your use case? Would you like to extract numbers for translation or use them as a context (the latter is possible with translate=”no” in XLIFF)?
Also, I would appreciate it if you could submit a new issue to cover your topic.
-
@Denis Konovalyenko
I have used my personal account by mistake.
I opened new issue regarding this. Thanks a lot
-
reporter @Stefan Brankovikj thank you very much for opening the issue!
@Jim Hargrave @ysavourel it looks like SUBMITTED issues are not shown for all in the list… Moreover, I am observing a “403” reply with “This issue is submitted and being reviewed.” message if I try to navigate to it. Do you happen to know any project setting we can adjust to allow new issues to be listed for all?
- Log in to comment