I convert spreadsheets from Excel 2003 to a formatted text (space delimited)
..prn file for use in another program. I last used this function in October 07
without any problems. I tried to do this yesterday and the save did not
maintain the columnar spacing, instead it ran everything together, which made
the data unusable.

I tried doing a program repair from the original CD without any success.
What would cause this?

Thanks, jeff

I bet that the columns were not the same width as when you tested in October.

I like to use a non-proportional font (Courier New) and then I can see how
things may look--although checking the .prn file using your favorite Text editor
(NotePad???) is still required.



Jeff Clark wrote:

I convert spreadsheets from Excel 2003 to a formatted text (space delimited)
.prn file for use in another program. I last used this function in October 07
without any problems. I tried to do this yesterday and the save did not
maintain the columnar spacing, instead it ran everything together, which made
the data unusable.

I tried doing a program repair from the original CD without any success.
What would cause this?

Thanks, jeff

--

Dave Peterson

You are exactly right in the column width change. I use a new template each
time that comes to me with even/odd widths, depending on the data in each
column. After looking at many of the templates that I used last year, they
all have exactly .11 deducted from each columns width. This would make them
unusable at this time.

I just downloaded a fresh template and saved it as a workbook (3 tabs in
workbook and this is a normal type save option) and again find the columns
..11 narrower across the sheet.

Something has changed in the program to cause this deduction when saving the
master and has changed all of my old templates.

I am at a loss on this.



"Dave Peterson" wrote:

I bet that the columns were not the same width as when you tested in October.

I like to use a non-proportional font (Courier New) and then I can see how
things may look--although checking the .prn file using your favorite Text editor
(NotePad???) is still required.



Jeff Clark wrote:

I convert spreadsheets from Excel 2003 to a formatted text (space delimited)
.prn file for use in another program. I last used this function in October 07
without any problems. I tried to do this yesterday and the save did not
maintain the columnar spacing, instead it ran everything together, which made
the data unusable.

I tried doing a program repair from the original CD without any success.
What would cause this?

Thanks, jeff

--

Dave Peterson

If the .columnwidth is off by .11, then I _think_ this could be caused by a
different printer driver. Maybe the current printer allows for more detail--or
maybe the opposite.

You may want to try changing to the old printer to see if that changes anything.

Jeff Clark wrote:

You are exactly right in the column width change. I use a new template each
time that comes to me with even/odd widths, depending on the data in each
column. After looking at many of the templates that I used last year, they
all have exactly .11 deducted from each columns width. This would make them
unusable at this time.

I just downloaded a fresh template and saved it as a workbook (3 tabs in
workbook and this is a normal type save option) and again find the columns
.11 narrower across the sheet.

Something has changed in the program to cause this deduction when saving the
master and has changed all of my old templates.

I am at a loss on this.

"Dave Peterson" wrote:

I bet that the columns were not the same width as when you tested in October.

I like to use a non-proportional font (Courier New) and then I can see how
things may look--although checking the .prn file using your favorite Text editor
(NotePad???) is still required.



Jeff Clark wrote:

I convert spreadsheets from Excel 2003 to a formatted text (space delimited)
.prn file for use in another program. I last used this function in October 07
without any problems. I tried to do this yesterday and the save did not
maintain the columnar spacing, instead it ran everything together, which made
the data unusable.

I tried doing a program repair from the original CD without any success.
What would cause this?

Thanks, jeff

--

Dave Peterson


--

Dave Peterson

I haven't changed printers. This problem occurs on screen in the Excel
template and then when I save it to the formatted text (space delimited) prn
file the columns/data all runs together. When I open the template, the
columns are in the even/odd format and then when I save the template it
changes the columns by .11 on each column.

I recently downloaded the .net framework (beta version) and SQL programs to
run a different application. Could either of these programs cause this
problem?

"Dave Peterson" wrote:

If the .columnwidth is off by .11, then I _think_ this could be caused by a
different printer driver. Maybe the current printer allows for more detail--or
maybe the opposite.

You may want to try changing to the old printer to see if that changes anything.

Jeff Clark wrote:

You are exactly right in the column width change. I use a new template each
time that comes to me with even/odd widths, depending on the data in each
column. After looking at many of the templates that I used last year, they
all have exactly .11 deducted from each columns width. This would make them
unusable at this time.

I just downloaded a fresh template and saved it as a workbook (3 tabs in
workbook and this is a normal type save option) and again find the columns
.11 narrower across the sheet.

Something has changed in the program to cause this deduction when saving the
master and has changed all of my old templates.

I am at a loss on this.

"Dave Peterson" wrote:

I bet that the columns were not the same width as when you tested in October.

I like to use a non-proportional font (Courier New) and then I can see how
things may look--although checking the .prn file using your favorite Text editor
(NotePad???) is still required.



Jeff Clark wrote:

I convert spreadsheets from Excel 2003 to a formatted text (space delimited)
.prn file for use in another program. I last used this function in October 07
without any problems. I tried to do this yesterday and the save did not
maintain the columnar spacing, instead it ran everything together, which made
the data unusable.

I tried doing a program repair from the original CD without any success.
What would cause this?

Thanks, jeff

--

Dave Peterson


--

Dave Peterson

I just did some research between my desktop and my laptop. The laptop
downloads and retains the template in its proper form, the desktop does not.

I went to tools/options/transition and found a difference in the setups. The
desktop has "transition formula evaluation" checked the laptop does not.

I unchecked the box and closed the program and tried the download again, but
it came in the same way and the box was checked again.

Both units have office basic 2003 SP3 installed. Could this be the source of
the problem?

"Jeff Clark" wrote:

I haven't changed printers. This problem occurs on screen in the Excel
template and then when I save it to the formatted text (space delimited) prn
file the columns/data all runs together. When I open the template, the
columns are in the even/odd format and then when I save the template it
changes the columns by .11 on each column.

I recently downloaded the .net framework (beta version) and SQL programs to
run a different application. Could either of these programs cause this
problem?

"Dave Peterson" wrote:

If the .columnwidth is off by .11, then I _think_ this could be caused by a
different printer driver. Maybe the current printer allows for more detail--or
maybe the opposite.

You may want to try changing to the old printer to see if that changes anything.

Jeff Clark wrote:

You are exactly right in the column width change. I use a new template each
time that comes to me with even/odd widths, depending on the data in each
column. After looking at many of the templates that I used last year, they
all have exactly .11 deducted from each columns width. This would make them
unusable at this time.

I just downloaded a fresh template and saved it as a workbook (3 tabs in
workbook and this is a normal type save option) and again find the columns
.11 narrower across the sheet.

Something has changed in the program to cause this deduction when saving the
master and has changed all of my old templates.

I am at a loss on this.

"Dave Peterson" wrote:

I bet that the columns were not the same width as when you tested in October.

I like to use a non-proportional font (Courier New) and then I can see how
things may look--although checking the .prn file using your favorite Text editor
(NotePad???) is still required.



Jeff Clark wrote:

I convert spreadsheets from Excel 2003 to a formatted text (space delimited)
.prn file for use in another program. I last used this function in October 07
without any problems. I tried to do this yesterday and the save did not
maintain the columnar spacing, instead it ran everything together, which made
the data unusable.

I tried doing a program repair from the original CD without any success.
What would cause this?

Thanks, jeff

--

Dave Peterson


--

Dave Peterson