Excel export: descriptions split up in multiple cells

[Thomas]

Our descriptions are sometimes quite long and for readability I
insert blank lines. When I export the list to Excel, it creates
multiple rows for every line break. This creates problems when sorting
or just when one wants to quickly format the excel sheet.

- Is V1 going to correct this behaviour?
- Does anybody know of a work around to the problem?

Thanks,

Thomas

[Lea Rush]

I asked about this at one point, and the short answer was, "it's not a bug,
it's a feature!" :>

Seriously though, if a workaround has been discovered, I'd love to hear it.

Lea

_________________________________

Lea Rush
Software and Documentation Specialist
Astoria-Pacific International
PO Box 830 Clackamas OR 97015
PH: 800-657-3010
FAX: 503-655-7367

[Maggie Bullington]

This is purely the result of how Excel deals with html. Descriptions in V1 are html rich text, and when you open html in excel that has paragraph tags or line breaks it breaks it across rows. There is a good description in another thread:

http://community.versionone.com/Discussions/Lists/VersionOneuser/DispForm.aspx?ID=370

-Maggie

[Thomas]

Ahh, I used to give such answers to my customers, too.

The problem is: the export is not satisfactory and as a user, I have
an interest in getting clean exports that allow for simply formatting.
I am sure there is a technical solution to this.

I am not a Dev, but what about this: http://aspalliance.com/518 ?

Cheers,

Thomas

Maggie Bullington schrieb:

[Emmanuel Szabados]

Could we have export in csv? Excel understand that and it's much simpler....

[Maggie Bullington]

Both interesting ideas (csv and the aspalliance article). I’ll submit this in to the product team J

-Maggie

[Kevin S.]

I agree with Thomas. I think we know it's an excel problem, but
anything V1 can do to help will help it's users.

It definitely would help if this could be improved based on the
suggestions above.


On Nov 14, 10:43 am, Maggie Bullington
<maggie.bulling...@versionone.com> wrote:
> Both interesting ideas (csv and the aspalliance article). I'll submit this in to the product team :)

> -Maggie
>
> From: versiono...@googlegroups.com [mailto:versiono...@googlegroups.com] On Behalf Of Emmanuel Szabados
> Sent: Friday, November 14, 2008 9:51 AM
> To: versiono...@googlegroups.com
> Subject: Re: Excel export: descriptions split up in multiple cells
>
> Could we have export in csv? Excel understand that and it's much simpler....
>

> On Fri, Nov 14, 2008 at 8:44 AM, Thomas <gu...@mailinator.com<mailto:gu...@mailinator.com>> wrote:
>
> Ahh, I used to give such answers to my customers, too.
>
> The problem is: the export is not satisfactory and as a user, I have
> an interest in getting clean exports that allow for simply formatting.
> I am sure there is a technical solution to this.
>
> I am not a Dev, but what about this:http://aspalliance.com/518?
>
> Cheers,
>
> Thomas
>
> Maggie Bullington schrieb:
>
> > This is purely the result of how Excel deals with html. Descriptions in V1 are html rich text, and when you open html in excel that has paragraph tags or line breaks it breaks it across rows. There is a good description in another thread:
>

> >http://community.versionone.com/Discussions/Lists/VersionOneuser/Disp...

[Thomas]

Just found this:

http://htmlcenter.com/blog/export-to-excel-with-vbscript/

Looks there is another pitfall to avoid

Cheers,

Thomas

On 14 Nov., 17:17, "Kevin S." <ksch...@gmail.com> wrote:
> I agree with Thomas.  I think we know it's anexcelproblem, but

> anything V1 can do to help will help it's users.
>
> It definitely would help if this could be improved based on the
> suggestions above.
>
> On Nov 14, 10:43 am, Maggie Bullington
>
> <maggie.bulling...@versionone.com> wrote:
> > Both interesting ideas (csv and the aspalliance article). I'll submit this in to the product team :)
> > -Maggie
>
> > From: versiono...@googlegroups.com [mailto:versiono...@googlegroups.com] On Behalf Of Emmanuel Szabados
> > Sent: Friday, November 14, 2008 9:51 AM
> > To: versiono...@googlegroups.com

> > Subject: Re:Excelexport: descriptions split up in multiple cells
>
> > Could we have export in csv?Excelunderstand that and it's much simpler....

>
> > On Fri, Nov 14, 2008 at 8:44 AM, Thomas <gu...@mailinator.com<mailto:gu...@mailinator.com>> wrote:
>
> > Ahh, I used to give such answers to my customers, too.
>
> > The problem is: the export is not satisfactory and as a user, I have
> > an interest in getting clean exports that allow for simply formatting.
> > I am sure there is a technical solution to this.
>
> > I am not a Dev, but what about this:http://aspalliance.com/518?
>
> > Cheers,
>
> > Thomas
>
> > Maggie Bullington schrieb:
>

> > > This is purely the result of howExceldeals with html. Descriptions in V1 are html rich text, and when you open html inexcelthat has paragraph tags or line breaks it breaks it across rows. There is a good description in another thread:

> > > > insert blank lines. When I export the list toExcel, it creates