The column Type by exporting event report shows the variable name
Please be more specific. What does it show in both places?
In the web ui, when the report event is displayed, the colum "Type" contains for example : Device is moving, Command result, Device has stopped, etc Now when i click to export, the generated xlsx file contains in the column "Type" respectively: deviceMoving, commandResult, deviceStopped.
What i mean is that in the exported file xlsx should be also displayed: Device is moving, Command result, Device has stopped.
That's a limitation of excel export. It doesn't have access to localisation files.
Anton, Thanks for the explanation.... do you would consider this limitation as a feature request for a next release or would it be not?
You can submit a feature request on GitHub for it.
I could not do it in good way.
I've tried to use VLOOKUP function, but did not make it work with values directly, like $[VLOOKUP("$event.type", strings!A2:B17, 2, FALSE)] but managed to work it with other column. The first problem that jxls do not copy hidden state of column when processing. Just made it 1 pixel width.The second one, that it is not possible to hide sheets.
Here is my experiments https://drive.google.com/file/d/0Bxu1vjhFvq74ZUJtTzBoWW5Sbk0/view?usp=sharing
Even if I made "strings" sheet hidden, it become unhidden.
Hello Anton,
I generate the event report and works fine, i can see all events and specially the type event string looks perfect. But when I export the report, the column "Type" in the file xlsx contains a different text (I think it displays the variable name and not the string in the variable). Bug?
Thanks in advance