Question on formatting tect in an Excel cell

[iluvizzy]

I am writing the Help for my product and it is entered & formatted into Excel, then imported into my product. The problem is, I am manually formatting the text in each cell. I have to manually insert bullet points, spaces, indents, do the alt+enter to insert a line, etc. Then when I think I have everything correctly formatted, I import into my product and see how it displays. If anything is amiss, I must go back to the Excel file and fix it. This happens almost every time!! Question: is there a way you can fomat text in cells so the formatting settings are hard coded? (instead of this painstaking trial-and-error method!) Thanks!

 

[sachin.acharya]

Depends on how your product imports the data from Excel but you can try Text Boxes instead of cells

 

[iluvizzy]

Re: Question on formatting text in an Excel cell

What do you mean by "text boxes" in Excel? Mark them as text? The problem is, I can format the text all I want, but when I import the spreadsheet into QlikView, the formatting is lost.

 

[sachin.acharya]

If you are using Excel 2007, go to the Insert tab and you have Text Box option there. If 2003, it should be on the Drawing toolbar on the bottom left corner of your Excel screen (if you don't see that go to View >> Toolbars and select Drawing)

This will float a Textbox that is independant of the cells. But again like I said, this work only if your other program (QlikView?) has the ability to import "objects" from Excel.

I would consider the formatting option directly in QlikView rather than Excel because the issue is not how Excel formats it but how QlikView imports it.