topic-37949

Posts: 1467

Joined: Mon Oct 10, 2005 11:26 AM

Alignement in Excel (solved)
Posted: Sun Oct 27, 2019 03:23 PM

Hello,

I want to make an Excel-document from my FWH-application.

I need to align the cells in my Excel document.

To achieve tha, I try this :

Code (fw): Select all Collapse

/* Explanation cPos :
   cPos = 0 -> Standaad alignement
   cPos = 1 -> Left alignement
   cPos = 2 -> Centered
   cPos = 3 -> Right alignement
   cPos = 4 -> Left + right alignement
*/
oSheet:Range("A1"):HorizontalAlignment := cPos

Unfortunately, nothing is changing.

What do I do wrong?
Does anyone have another suggestion?

Thanks a lot in advance for any help.

Regards,

Michel D.
Genk (Belgium)

_____________________________________________________________________________________________

I use : FiveWin for (x)Harbour v. 25.12 - Harbour 3.2.0 (May 2025) - xHarbour Builder (January 2020) - Bcc773

cnavarro

Posts: 6755

Joined: Wed Feb 15, 2012 08:25 PM

Re: Alignement in Excel
Posted: Sun Oct 27, 2019 03:28 PM

Not valid this?

viewtopic.php?f=3t=32228p=188814hilit=HorizontalAlignment#p188814

&&&

Cristobal Navarro

Hay dos tipos de personas: las que te hacen perder el tiempo y las que te hacen perder la noción del tiempo

El secreto de la felicidad no está en hacer lo que te gusta, sino en que te guste lo que haces

driessen

Posts: 1467

Joined: Mon Oct 10, 2005 11:26 AM

Re: Alignement in Excel (solved)
Posted: Sun Oct 27, 2019 04:22 PM

Thanks a lot for your help. It works just fine.

Sorry I couldn't remember my previous topic about this subject.

Regards,

Michel D.
Genk (Belgium)

_____________________________________________________________________________________________

I use : FiveWin for (x)Harbour v. 25.12 - Harbour 3.2.0 (May 2025) - xHarbour Builder (January 2020) - Bcc773

FiveTech Support Forums

Continue the discussion