asked on August 23, 2022
Using flexmonster pivot table, we create a chart with a few dimensions and measures. We then group by the dimensions (for example: date, customer, etc).
The "customer" dimension has a double-space in the value (ex: XX XXXXXX XXX XXXX).
When grouped on the dimensions, the cascading rows beneath the header row of the dimension have a singles-space. This results in rows of data with different spacing for no clear reason.
The issue becomes apparent when the user exports the data and attempts to create a pivot table in excel. This results in duplicate dimensions and inconsistent data.
Do you know what the issue could be?
Edit: Even as I wrote this ticket, the double-spacing was removed from the example text.
XX XXXXXX XXX XXXX
⋅ August 24, 2022
Hi, Josh,
Thank you for reporting an issue.
We reproduced this chart's behavior on our side. While having double spaces inside a dataset and on the chart legend, the labels on charts are shown with single spaces (see the JSFiddle). Our team will research this pivot chart's behavior and provide our feedback, ETA Sep 20th.
Feel free to contact us if any other questions arise.
Best Regards,
Maksym
⋅ September 19, 2022
Hello Maksym,
I appreciate the effort on your part, but is there an update for this issue?
⋅ September 20, 2022
Hello, Josh,
We are glad to inform you that the issue with rendering multiple white spaces in chart labels was fixed.
This is provided in the 2.9.34 version of Flexmonster: https://www.flexmonster.com/release-notes/version-2-9-34/
You are welcome to update the component. Here is our updating guide for assistance: https://www.flexmonster.com/doc/updating-to-the-latest-version/
Please tell us if the fix works.
Best regards,
Maksym
⋅ September 27, 2022
Hello, Josh,
Hope you are doing well.
Our team is wondering if you had time to check the provided fix of rendering multiple spaces in chart labels.
Looking forward to hearing your feedback.
Best regards,
Maksym
⋅ September 27, 2022
Hello,
Thank you, but I don't believe I will get to see the results of the fix any time soon.
We're not slated to upgrade our version of Flexmonster soon or frequently so it may be a long while before I see the fix.
⋅ September 28, 2022
Hello,
Thank you for the reply.
Feel free to contact us if any other questions arise.
Best Regards,
Maksym
⋅ October 10, 2022
Hello,
If the fix relies on a version upgrade, what is the workaround if no upgrade is done?
"This issue has been reported by [XYZ], so they will not have the latest version by [date]. Could you please let me know the workaround or how can we help the customer?"
⋅ October 12, 2022
Hi, Josh!
Thank you for the reply.
Kindly note that the fix for showing multiple white spaces in chart labels is available only since Flexmonster v.2.9.34. For example, in previous releases, the string "John Jonhson" (with two spaces) will be displayed as "John Jonhson" (with a single space) on the chart label. After version 2.9.24, multiple spaces will be rendered.
If you want to use an older version, we suggest preprocessing the data to remove multiple spaces before loading it into the component. This can be done both on your server and the client side (see the example with double spacing removed from the data).
Looking forward to hearing from you.
Best Regards,
Maksym
