Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
beltram16
 
Posts: n/a
Default working as a csv file, help needed

i am currently using a spreadsheet that is in xl format, i downloaded it as a
csv, and as instructed saved as an xl file, i have since spent a very long
time completing the spreadsheet and its good! but to send the spreadsheet
back to the program i am using it has to be as a csv, so ok i done all of
this and it goes but i have a major problem, when i open the document in its
new form in the program, one of the coloumns which is vital does not display
as it should, there are 6 rows of text in total but after and before each
line of text i get a comma, it looks awful but in truth i can live with this,
then after row 4 of text there is nothing , there should be a text line that
is itself a link (according to my html) but nothing, i include below my (MY)
html text that is in my xl spreadsheet, help please

<P align=center<STRONG<FONT size=4,Exhibition 2,</FONT</STRONG</P<P
align=center<FONT face=Arial<STRONG<FONT size=4,Future
Heroes,</FONT</STRONG</P<P align=center<STRONG<FONT size=4,LOST .
LANGUAGE,</FONT</STRONG</P<P
align=center<STRONG<FONTSIZE=4</FONT</STRONG</FONT</P<P
align=center,3 x 12,</P<P align=center,LOSTLP002,</FONT</STRONG</P<P
align=center<FONT face=Arial<STRONG<FONT size=4,Mint,</P<P
align=center,"Quality Trance, progressive Breakbeat
Stuff",</STRONG</FONT</P<P</P<P align=center<A
href=,"""",http://www.discogs.com/release/346065,"""",http://www.discogs.com/release/346065,</A </P

regards
beltram16

  #2   Report Post  
Earl Kiosterud
 
Posts: n/a
Default

Beltram,

A csv file contains only the text you see in the cells. It contains no
underlying cell stuff, like formulas (you get only the current results of
the formula when the file was saved), Conditional formatting (you don't even
get formatting with a csv file, hence no colors, not bold, etc.), and no
hyperlink information (again, just what you see in the cell- not the
hyperlink target). You can't pass all that magic back to the application
with a csv file. Just text.
--
Earl Kiosterud
www.smokeylake.com

"beltram16" wrote in message
...
i am currently using a spreadsheet that is in xl format, i downloaded it as
a
csv, and as instructed saved as an xl file, i have since spent a very long
time completing the spreadsheet and its good! but to send the spreadsheet
back to the program i am using it has to be as a csv, so ok i done all of
this and it goes but i have a major problem, when i open the document in
its
new form in the program, one of the coloumns which is vital does not
display
as it should, there are 6 rows of text in total but after and before each
line of text i get a comma, it looks awful but in truth i can live with
this,
then after row 4 of text there is nothing , there should be a text line
that
is itself a link (according to my html) but nothing, i include below my
(MY)
html text that is in my xl spreadsheet, help please

<P align=center<STRONG<FONT size=4,Exhibition 2,</FONT</STRONG</P<P
align=center<FONT face=Arial<STRONG<FONT size=4,Future
Heroes,</FONT</STRONG</P<P align=center<STRONG<FONT size=4,LOST .
LANGUAGE,</FONT</STRONG</P<P
align=center<STRONG<FONTSIZE=4</FONT</STRONG</FONT</P<P
align=center,3 x 12,</P<P align=center,LOSTLP002,</FONT</STRONG</P<P
align=center<FONT face=Arial<STRONG<FONT size=4,Mint,</P<P
align=center,"Quality Trance, progressive Breakbeat
Stuff",</STRONG</FONT</P<P</P<P align=center<A
href=,"""",http://www.discogs.com/release/346065,"""",http://www.discogs.com/release/346065,</A
</P

regards
beltram16



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help needed referencing an embedded file teepee Excel Discussion (Misc queries) 0 April 24th 05 12:03 PM
problem working with time data imported from text file afaqm Excel Worksheet Functions 1 February 24th 05 08:02 AM
Locating a file in excel with a partial file name. Audra Excel Discussion (Misc queries) 0 February 19th 05 02:03 PM
Locating a file in excel with a partial file name. Audra Excel Discussion (Misc queries) 0 February 19th 05 02:01 PM
Read Text File into Excel Using VBA Willie T Excel Discussion (Misc queries) 13 January 8th 05 12:37 AM


All times are GMT +1. The time now is 09:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"