Regardless of the method you used to move a column, the formulas contained there in will be affected. The addressing method holds whether you copy and paste the formula or whether you drag-and-drop it, or whether you use some other method. Regardless of how you move it, if there is relative or absolute addressing conflicts, the formula will be negatively affected.
Sent from my IPhone > On Aug 7, 2014, at 11:43 PM, Nicholas Parsons <[email protected]> > wrote: > > Hi Barry and Phil, > > Thanks both for your help. > > Barry, your tip of first VO-spacing on the column reference tab took me > further than I had gotten before, but still no success. The results were a > bit flaky. I'm not sure I exactly understood your instructions. After > VO-spacing on the column reference tab for the column I wanted to move, I > pressed mouse down with VO-command-shift-space. Sometimes doing this caused > the menu to pop up with the sort and filter options etcetera. Other times it > didn't. But it never said anything about moving, and moving to another column > and pressing mouse up didn't have any effect. Pressing VO-comma would still > announce, 'Marked column X for drag', or whatever, but when I'd try and drop > it would often say the marked item is no longer in view, even though I had > only tried to move it one column over, and other times it would say 'column X > inserted', but would actually not have moved the column at all. > > Phil, the formulas are my own but the column I want to move is in a data > table and the formulas and functions I have in the summary tables are quite > complicated, and I don't really want to look through every one to find if any > use relative references and would break. In any event, I'd like to learn how > to move columns (as opposed to copying and pasting) to enhance my Numbers > toolbox and ensure that for this time and for the future I am able to move > columns without upsetting formulas. Having said that, I appreciate your > pragmatic suggestions and might ultimately have to resort to that or to > asking for sighted assistance. > > many thanks again and if you have any other help, thoughts or suggestions I'd > love to hear them. > > >> On 7 Aug 2014, at 11:15 pm, Phil Halton <[email protected]> wrote: >> >> A simpler method would be to simply copy the column, then insert a new >> column where you want the data, and then do a paste. Move to the top of the >> column, then do a shift command down arrow to select the entire column. Then >> do an option right arrow at the column after which you want the data to >> appear. Of course, don't forget to copy the selected fcolumns first, then >> paste into the newly created column. This may still mess up your formulas >> depending on whether you used relative or absolute addressing. >> >> That gets fairly tricky. I don't know if you're writing your own formulas, >> or if these are someone else's. But, the addressing system they use will >> determine if the formulas can be moved from one position to another without >> screwing them up. >> Sent from my IPhone >> >> >>> On Aug 7, 2014, at 12:10 AM, Nicholas Parsons >>> <[email protected]> wrote: >>> >>> Hi all, >>> >>> I'm trying to work out how to move columns in Numbers without upsetting >>> formulas etc. Sighted people can just click on the column reference tab and >>> drag the column left or right to the new location. >>> >>> I've tried getting into the column reference tab with VO-shift-backslash >>> and then selecting column reference tab, and then using the VO commands to >>> drag and drop. However, this never works. It seems more than just the usual >>> flakiness, it just never seems to have any effect, even though VoiceOver >>> announces that the column has been inserted. >>> >>> Any ideas? >>> >>> -- >>> You received this message because you are subscribed to the Google Groups >>> "MacVisionaries" group. >>> To unsubscribe from this group and stop receiving emails from it, send an >>> email to [email protected]. >>> To post to this group, send email to [email protected]. >>> Visit this group at http://groups.google.com/group/macvisionaries. >>> For more options, visit https://groups.google.com/d/optout. >> >> -- >> You received this message because you are subscribed to the Google Groups >> "MacVisionaries" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> To post to this group, send email to [email protected]. >> Visit this group at http://groups.google.com/group/macvisionaries. >> For more options, visit https://groups.google.com/d/optout. > > -- > You received this message because you are subscribed to the Google Groups > "MacVisionaries" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/macvisionaries. > For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "MacVisionaries" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/macvisionaries. For more options, visit https://groups.google.com/d/optout.
