Hi All,
Am using Analysis for Office 2.4 and Excel 2013.We have a strange issue for below scenario.
1. Inserting New line juts after the dimensions.
2. Fill it with a very simple excel formula ex: referencing the member of dimension in column A1.
3. Using 'drag' option to copy the formula to all cells of a newly created column.
I am expecting the other cells of a column should refer to the correcting value of Dimension member like from A2, A3, A4 etc.. But it actually copying A1 value to all cells of newly created formula.
I do not have this issue if I create a excel formula using 'Measures' in Analysis Office.
It exists only with 'Members' data both key and text.
Please advice, is it a known issue with Analysis Office or am I missing anything here?