Excel > XML Workflos
Posted: Tue Apr 03, 2012 3:56 pm
I am evaluating Oxygen as a replacement to Excel for our XML editing needs. Up to now, we have used a very “flat” XML structure. This works well with Excel, but is limiting from a programming point of view. However, if I can’t demonstrate a work flow that the current content producers are happy with, we will not be able to move to Oxygen and the benefits I feel it provides.
The issue I'm having is that when I have a group of repeating elements and I select a column (that might be attributes, #text, ot what have you) and paste a column of values from Excel into it, it only overwrites the value in the bottommost cell, then creates a more repeating elements with just that value filled in (the number being the number I pasted in -1). At that point, I can drag the pasted values up to where they were supposed to go and delete the excess tags, but this is not ideal.
I'm not sure if this should be a feature request, bug report, or if this is a setting I have managed to miss. If someone could give me more information on what's going on, I'd appreciate it.
Thanks in advance!
Amy
The issue I'm having is that when I have a group of repeating elements and I select a column (that might be attributes, #text, ot what have you) and paste a column of values from Excel into it, it only overwrites the value in the bottommost cell, then creates a more repeating elements with just that value filled in (the number being the number I pasted in -1). At that point, I can drag the pasted values up to where they were supposed to go and delete the excess tags, but this is not ideal.
I'm not sure if this should be a feature request, bug report, or if this is a setting I have managed to miss. If someone could give me more information on what's going on, I'd appreciate it.
Thanks in advance!
Amy