working as a csv file, help needed

G

Guest

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
 
E

Earl Kiosterud

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top