I would like to display only rows 4-8 and columns 4-8 of my excel sheet, using the office excel marco. How do i specify this detail of specific rows and coloums, while using the excel macro.
It takes only the last row and last column. And assumes first row/column to be 0. Is there a way to specify the first row and column also?
COuld someone please help me figure out, how to do this?
when the developer did not include the options, you can't. Two ways I can think of to work with that :
I hope, that helps. Maybe someone else has more.
the Excel macro always shows the tab that was previously open while saving the document. That's why Josh's solution would work. I just don't understand why you would need some VB macros. If you linked the desired cell with cells in the "export tab" you would only need to apply changes to the original tab, open the export tab, save the document and close the Excel file... That way the updated export tab would be shown in Confluence...
This is just about viewing the Excel file not writing values back like what you could do in earlier versions with the "Edit in office", right?
@Christian - The VB macros would be for writing back (and overwriting the "sourceformular" in the field :
* Example : Celll "A1" = "sourcetab!C42". Once change the value of A1, that is broken.
Your workaround of "editing the source-cell" will certainly work as well, but does require additional steps by the user.
Do you use templates with Confluence? Take part in a remote 1-hr workshop. You'll receive USD $100 for your time! We're looking for people to participate in a remote 1-hr workshop...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs