adjusting table or chart sizes
adjusting table or chart sizes
(OP)
If I create an excel spread sheet and paste it (embedded) into a .dft file, then double click to enter the spread sheet, add a collumn and close it, the .dft file doesn't readjust to show the new collumn. I have to paste in a new one and delete the old.
Is there a way to get SE to understnad there is a new collumn to display? I'm using V18.
Is there a way to get SE to understnad there is a new collumn to display? I'm using V18.





RE: adjusting table or chart sizes
you should use Insert --> Object from within SE and uncheck
link to file, then it's gets embedded and will update.
If you, however, adjust the width/height then SE will stick
with that size and any new columns added that are 'out of bounds'
will not show up, you have to manually adjust the size. This
will also happen in case the link option is not cleared.
dy
RE: adjusting table or chart sizes
just found out the following;
when during insert the link option is not cleared only deleted
columns will show but new columns won't show up. Resizing will
only 'stretch' the imported .xls.
dy
RE: adjusting table or chart sizes
RE: adjusting table or chart sizes
so it seems to be a 'glitch' in SE. The only difference
between Cut/Paste/Insert with link and embedded is that the width
and height of the latter can be increased to show new
columns.
dy
RE: adjusting table or chart sizes
However, word files have their own problems with seeming to get 'corrupt'.
(V18)
RE: adjusting table or chart sizes
What I do is put a character in a cell that is way outside the required table area, then you will be able to re-crop to whatever you want if you add rows/columns.
Unfortunately this has to be done when the spreadsheet is first created.
bc
RE: adjusting table or chart sizes
RE: adjusting table or chart sizes
grabbing the 'handles' is the way to go to widen or narrowing
the spreadsheet inside the .dft
dy