Live Office and database changes
I have created a Live Office connection to extract my Webi Report into the Xcelsius Spreadsheet. This is how the data looks in the spreadsheet.
Dept Name No. of Projects
I have mapped the spreadsheet data to a pie chart component.
Now, let's say a new Dept Name is added/removed in the database, then that would happen to my Spreadsheet data? Could anyone please help understand the process?
Arijit Das replied
You have to assume a maximum no of rows possible and bind the rows into excel accordingly in LO connection. Otherwise, always max 3 departments can be shown in above case.
By default the binding happens automatically considering the current number of rows in the block. You have to change that. Ensure you change the footer binding too so that it does not overlap with rows binding.