Shift drop downs when rows added
Posted: Sat Jan 09, 2016 12:52 pm
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!
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!