Page 1 of 1

Shift drop downs when rows added

PostPosted: Sat Jan 09, 2016 12:52 pm
by SameerK
Hi,
I have a xls template which has drop downs added from developer tool of excel. I need to read the template & populate the data.
Now, when we add a new row in between from excel sheet the drop downs are shifted down, but when i tried from other java API's drop downs did not shift down.
Is it possible to shift drop downs when rows created using xlsx4j API?
Note- Drop downs are created from developer tool and not attached to any cell. When we add a new row from excel sheet drop downs are shifted. Similar behavior is expected when we add a new row from API

Thanks in advance!

Re: Shift drop downs when rows added

PostPosted: Mon Jan 11, 2016 4:45 pm
by jason
Is this Data > Data Validation, or something else (eg Form Control or ActiveX Control)?

Might be easiest if you attach your sample xlsx