Skip to main content
Newcomer
Nov 30, 2022 3:32 PM UTC
Solved

Excel Add In Buttons

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.

lizweirAnswer
Member
Jan 19, 2023 10:08 PM UTC

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

11 replies

Employee - Sage
Dec 2, 2022 10:28 AM UTC

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.

Member
Jan 18, 2023 9:05 PM UTC

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

Newcomer
Jan 18, 2023 9:11 PM UTC

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. 

Member
Jan 18, 2023 10:13 PM UTC

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.

Member
Jan 19, 2023 5:56 PM UTC

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

Newcomer
Jan 19, 2023 9:39 PM UTC

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.

lizweirAnswer
Member
Jan 19, 2023 10:08 PM UTC

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

Newcomer
Jan 20, 2023 2:58 PM UTC

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.  

StuZilla81
Member
Jul 12, 2023 3:22 PM UTC

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.

“Anyone who can only think of one way to spell a word obviously lacks imagination.” – Mark Twain