OpenXML Filter: XLSX: expose numbers, dates and booleans as metadata

[Denis Konovalyenko]

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:

1. Number

‌

2. Boolean

‌

3. Date

‌

4. Date-time

‌

5. Number function

‌

6. String function

‌

For more details please refer to the attached document.

[Denis Konovalyenko]

Related pull request #578 was opened.

[Denis Konovalyenko]

A solution merged in the scope of pull request #578.

[Marko Doda]

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?

[Denis Konovalyenko]

@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.

[Stefan Brankovikj]

@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 the 1234 cell is not found in the sharedStrings.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.

[Denis Konovalyenko]

@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.

‌

[Stefan Brankovikj]

@Denis Konovalyenko

I have used my personal account by mistake.

I opened new issue regarding this. Thanks a lot

[Denis Konovalyenko]

@Stefan Brankovikj thank you very much for opening the issue!

@Jim Hargrave @YvesS 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?