https://bugs.freedesktop.org/show_bug.cgi?id=53244
--- Comment #9 from [email protected] 2012-08-29 22:18:01 UTC --- I looked up the formula used to built the items for the drop downs: INDIRECT("'"&ALS(A28="-";"";PROPER(TEXT(A28;"mmmm")))&"'!$A$2:$A$30") As you can see, the formula is used to get the range dynamically. I used the ! for referencing the other sheet. My question, should Calc be able to see this formula as referencing another sheet and save the ! as a . (dot)? Or does using 'INDIRECT' make it impossible for calc do detect the ! (exclamation mark)? -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. _______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
