Cambio de EXCEL a CALC de LibreOffice

[Harold San Lee]

Saludos foreros,

Feliz año nuevo, deseandoles el mejor año de todos.

Tengo un pedido de un cliente que quieren Cambiar de Excel a LibreOffice CALC
y tengo un modulo en harbour que genera Una hoja Electronica. Pero no he podido homologar
los siguientes comandos de Excel A Calc.

Con esta Comando se resalta una celda

            oAS:Cells( 3, 2 ):Font:Bold := .T.

Con este Comando Ajusto el tamaño de las Columnas

         FOR nCol := 1 TO 12
             oAS:Columns( nCol ):AutoFit()
         NEXT

Con esta Comando estoy centrando una serie de columnas

            oAS:Range( "A1:M1" ):HorizontalAlignment := 7

Con estas instrucciones estoy colocando cuadriculas a mi hoja electronica

            oAS:Range( "A3:M12" ):Borders(4):LineStyle:= 1

Mi Pregunta es: ¿Es posible de hacer esto? y si se puede ¿como lo hago?

Si existe un link donde me expliquen como homologar estos comandos con sus correspondientes ejemplos se los agradezco.
 
de antemano muy agradecido.

Harold San.  

[Riztan Gutierrez]

Hola.  Si estas generando la hoja de cálculo, evalúa la posibilidad de usar hbxlsxwriter para generar ficheros .xlsx directamente sin dependencia incluso desde gnu/linux.

Saludos

_________________________

Hi. If you are generating the spreadsheet, evaluate the possibility of using hbxlsxwriter to generate .xlsx files directly without dependency even from gnu / linux.

--
--
You received this message because you are subscribed to the Google
Groups "Harbour Users" group.
Unsubscribe: harbour-user...@googlegroups.com
Web: http://groups.google.com/group/harbour-users

---
You received this message because you are subscribed to the Google Groups "Harbour Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to harbour-user...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/harbour-users/CAGtSzfEZVLfm3UMbOWBoh11pCPmHZ99PSOxD%2BUa_ThWdfgoE_A%40mail.gmail.com.

--

---

 Riztan Gutiérrez                                                 

• Linux User: # 494267
• Ubuntu User: # 28329

---

[Srdjan]

How I can build library?

When try to build I get "hbmk2[hbxlsxwriter]: Error: Missing dependency: xlsxwriter"

Unsubscribe: harbou...@googlegroups.com

Web: http://groups.google.com/group/harbour-users

---
You received this message because you are subscribed to the Google Groups "Harbour Users" group.

To unsubscribe from this group and stop receiving emails from it, send an email to harbou...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/harbour-users/CAGtSzfEZVLfm3UMbOWBoh11pCPmHZ99PSOxD%2BUa_ThWdfgoE_A%40mail.gmail.com.

[Riztan Gutierrez]

Hi. At this time I do not remember how to build the library in Windows. I will review and comment. (I use mingw)

Information:

https://libxlsxwriter.github.io/index.html

https://github.com/jmcnamara/libxlsxwriter

binaries: (32bits windows, 64bits gnu/linux)

https://mega.nz/#F!xkd1nQ6R!LESXK8dCICnzKGAR5vCYjQ

You can also run the examples with tpuy: https://sourceforge.net/projects/hbtools/files/

Unsubscribe: harbour-user...@googlegroups.com

Web: http://groups.google.com/group/harbour-users

---
You received this message because you are subscribed to the Google Groups "Harbour Users" group.

To unsubscribe from this group and stop receiving emails from it, send an email to harbour-user...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/harbour-users/8277d8b0-d5d6-4385-9e0d-72041e6ce4e4%40googlegroups.com.

[Srdjan]

I build exe both Linux and Windows.

Where I must put lib and include (from binaries) on Linux and Windows if I want make hbxlsxwriter?

or Have you "hbxlsxwriter.a" file for Linux (64bit) and Win (32bit)?

To view this discussion on the web visit https://groups.google.com/d/msgid/harbour-users/8277d8b0-d5d6-4385-9e0d-72041e6ce4e4%40googlegroups.com.

[Riztan Gutierrez]

I have generated and added the libhbxlsxwriter binaries, available on the same mega.nz link :https://mega.nz/#F!xkd1nQ6R!LESXK8dCICnzKGAR5vCYjQ

_____________________________________

He generado y agregado los binarios libhbxlsxwriter, disponibles en el mismo enlace de mega.nz

[Harold San Lee]

Muchas gracias riztan lo tendré en cuenta.

Harold San. 

To view this discussion on the web visit https://groups.google.com/d/msgid/harbour-users/CAJm1d5YhFT9%3Do6EsqQb4%3DMWyRzQRSaT9C-a-zqAn_9bTgMgu1Q%40mail.gmail.com.