11-30-2022 10:32 AM - last edited on 05-24-2023 12:11 PM by JackLacava
We have made the latest upgrade to 7.2.1. When I use the Excel Add and use the keep and delete buttons it suppresses all data in that field opposed to only keeping or removing the items that I selected.
Anyone else have this issue. The other members of the team don't have this issue and we have the same settings in place.
Solved! Go to Solution.
01-19-2023 05:08 PM
Hi Andy - try flipping it with Comma[0] as the data style with primary style blank. The bug we are encountering has OS inserting an extra space in the Root.List( ) when we select the Keep Only button. Nothing happens with Remove Only
12-02-2022 05:28 AM
Hi Andy,
the last version of Onestream is actually 7.2.2, so I would try to download the Excel add-in for that version. Make sure you "purge" things properly (uninstall, reboot, remove leftover OneStreamExcelAddIn folder - typically C:\Program Files (x86)\OneStream Software\OneStreamExcelAddIn - then reboot again, install).
If you still see an issue, you need to contact support.
01-18-2023 04:05 PM
Hey Andy - did you get this issue resolved? My client is having the same exact issue. IT uninstalled the add-in, re-installed (correct version both times) and still having this issue. We opened up a ticket with OneStream Support but if you have a solution it will certainly speed things along. Many thanks
01-18-2023 04:11 PM
We haven't found a solution as of yet. I'm about to deploy a new laptop and I'm hoping this fixes it, but to no avail since my initial inquiry.
01-18-2023 05:13 PM
Thanks! OneStream Support is working on it now and they're discussing it with the Marketplace apps team tomorrow - will let you know if we find a solution.
05-10-2023 03:39 PM
I have run into this same issue and am applying the workaround. Anyone heard if this has been fixed by OS in a later version yet? If so, what version did it get corrected in? Thanks!
01-19-2023 12:56 PM
Andy - OneStream has come back to us - this is a bug in the add-in but the workaround is that in your Add-In Preferences the Primary Style and Data Style cannot both be Comma [0]
Give it a try
01-19-2023 04:39 PM
Thanks Liz. I gave it a try. I had Comma[0] in my primary style, but my data style was blank. So not sure which setting you are finding to get it to work. I changed it around a few times using Comma in both and I'm still not able to get it to function. What are your settings?
What is weird is my + doesn't keep anything and my minus doesn't do anything.
01-19-2023 05:08 PM
Hi Andy - try flipping it with Comma[0] as the data style with primary style blank. The bug we are encountering has OS inserting an extra space in the Root.List( ) when we select the Keep Only button. Nothing happens with Remove Only
01-20-2023 09:58 AM
I gave that a try. Didn't seem to solve the issue. I think an associate of mine is having the same issue. I will see if this correction solves his problem.
01-20-2023 03:44 PM
After restarting my Excel this solution did work. Thanks for the help. I had really been struggling without that feature.
07-12-2023 11:22 AM
This bug is still present in version 7.4.1.14731. I filed a support ticket and they are aware of this and submitted a bug PF5-2119. I did try the work around listed here and it did work for me.