You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by jguilhermemv <jg...@gmail.com> on 2011/08/02 16:12:19 UTC
Apache POI 3.8 (SXSSFWorkbook) - Unreadable Content
I need to generate an excel report with almost 60.000 lines and 30 columns.
But, while using SXSSF approach of Big Grid Demo (I got it from the SVN
trunk), I've found some issues.
When I try creating a xlsx file with 1000 lines, it's ok. But when I try to
create a file with 10.000 lines, when I try opening it, the Excel software
show up an error ("Excel found an unreadable content"). The software asks to
fix it, but when I do it, the software tells that it had changed a line (but
the sheet is shown completely empty). The interesting part is that when I
try opening it with Open Office, it open, but not completely.
Regarding the file, it makes use of some CellStyles and Merged Regions.
So, what can I do to solve this problem? Which approach should I follow?
--
View this message in context: http://apache-poi.1045710.n5.nabble.com/Apache-POI-3-8-SXSSFWorkbook-Unreadable-Content-tp4658852p4658852.html
Sent from the POI - Dev mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
Re: Apache POI 3.8 (SXSSFWorkbook) - Unreadable Content
Posted by Alex Geller <ag...@4js.com>.
On more thought on this. In XML only the following unicode characters are
allowed (see http://www.w3.org/TR/xml/#NT-Char):
Char ::= #x9 | #xA | #xD | [#x20-#xD7FF] | [#xE000-#xFFFD] |
[#x10000-#x10FFFF]
Java strings apparently can contain any character but the 64 reserved "non
characters" (see
http://www.unicode.org/versions/Unicode5.2.0/ch16.pdf#G19635).
This means that there are quite a number of characters (2049 alone between
D7FF and E000) that can cause similar problems. Note that encoding these as
character references is also illegal (See
http://www.w3.org/TR/xml/#dt-unparsed) so there is no solution for this, or
is there?
All of this is irrelevant for the "non breaking space" character. That
character is legal in both Java and XML. I am actually wondering why it is
even encoded as a character reference.
Regards,
Alex
--
View this message in context: http://apache-poi.1045710.n5.nabble.com/Apache-POI-3-8-SXSSFWorkbook-Unreadable-Content-tp4658852p4665726.html
Sent from the POI - Dev mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
Re: Apache POI 3.8 (SXSSFWorkbook) - Unreadable Content
Posted by jguilhermemv <jg...@gmail.com>.
Alex,
Thank you for taking part of this discussion. Sure that it will help a lot.
Best regards.
Jose Guilherme
2011/8/3 Alex Geller [via Apache POI] <
ml-node+4662850-998737665-237524@n5.nabble.com>
> The bug is in line 1505 of
> src/ooxml/java/org/apache/poi/xssf/streaming/SXSSFSheet.java where the non
> breaking space in quoted in HTML manner (" ") instead of using a unicode
> escape (" ").
> @Yegor: will you take care of it?
> Sorry for the trouble.
> Regards,
> Alex
>
> ------------------------------
> If you reply to this email, your message will be added to the discussion
> below:
>
> http://apache-poi.1045710.n5.nabble.com/Apache-POI-3-8-SXSSFWorkbook-Unreadable-Content-tp4658852p4662850.html
> To unsubscribe from Apache POI 3.8 (SXSSFWorkbook) - Unreadable Content, click
> here<http://apache-poi.1045710.n5.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=4658852&code=amd1aWxoZXJtZW12QGdtYWlsLmNvbXw0NjU4ODUyfDg3MzU2ODc4NA==>.
>
>
--
View this message in context: http://apache-poi.1045710.n5.nabble.com/Apache-POI-3-8-SXSSFWorkbook-Unreadable-Content-tp4658852p4662992.html
Sent from the POI - Dev mailing list archive at Nabble.com.
Fwd: FW: Conselho de Advogado - Importante ler (LG)
Posted by jguilhermemv <jg...@gmail.com>.
Atenciosamente,
José Guilherme Macedo Vieira
Desenvolvedor Java EE
-----------------------------------
Telefone: 081-87127316
Skype: williaminbrazil
GTalk: jguilhermemv@gmail.com
---------- Mensagem encaminhada ----------
De: Augusto Galvao Barbosa <aa...@hotmail.com>
Data: 7 de setembro de 2011 18:04
Assunto: FW: Conselho de Advogado - Importante ler (LG)
Para: adriana <ad...@hotmail.com>, Aelson luis <
aelsonluis@hotmail.com>, agalvao@bol.com.br, Anderson SB <wa...@hotmail.com>,
Andreia Moreira <de...@hotmail.com>, araujo <de...@hotmail.com>,
arimagalvao@hotmail.com, arimargalvao@hotmail.com, Augusto Galvao Barbosa <
aagbarbosa4@hotmail.com>, augusto_medeiross@hotmail.com,
bobothy.m@hotmail.com, charlene_sheila@hotmail.com, Cleiton Cavalcanti <
cleitoncavalcanti_69@hotmail.com>, compras jc <co...@jc.com.br>,
cpljosiani@hotmail.com, dandacomercio@yahoo.com.br, daniel funase <
daniel_valenca@hotmail.com>, DIEGO VICENTE RIBEIRO RIBEIRO <
diegoevo25@hotmail.com>, ebp.solucoesemti@hotmail.com, edsonss@ig.com.br,
Eduardo Silva <fl...@yahoo.com.br>, Eduardo Silva <
flavialuiza3000@yahoo.com>, Eduardo Silva <ed...@hotmail.com>, Everson
Gomes <ev...@hotmail.com>, Everton Barbosa <ev...@hotmail.com>,
fabioalbuquerque@fade.org.br, filho de gleudes <jg...@gmail.com>,
filipe mauricio <fi...@hotmail.com>, filipemauricio@hotmail.com,
franquiashavaianas@alpargatas.com.br, Geovanni Nunes <va...@hotmail.com>,
hmlcomercial@ig.com.br, "iraci@recife.pe.gov.br" <ir...@recife.pe.gov.br>,
Ismaylton Pereira <is...@hotmail.com>, Ivan Lira <
totemoabunai@hotmail.com>, Jocy Melo <jo...@hotmail.com>,
jocypaulojose@hotmail.com, josinomelo@hotmail.com, Mag Mel <
mag.mel@hotmail.com>, Magaly Bezerra <ma...@hotmail.com>, mario silva <
rolinsilva@hotmail.com>, Maurycio Melo <ma...@hotmail.com>, Maysa de
Melo Bezerra <sa...@hotmail.com>, MÔNICA MELO <
monicaneoplanos1@hotmail.com>, monicamelo_estrela@hotmail.com, "
morgana@recife.pe.gov.br" <mo...@recife.pe.gov.br>, nya_galvao@hotmail.com,
omegames <do...@omegamed.com.br>, osmam silva <os...@hotmail.com>,
osmanp@hotmail.com, pc pc <pa...@hotmail.com>,
richard_cavalcanti@hotmail.com, Roberta Rijo <ro...@hotmail.com>,
roberto pires pires <ro...@hotmail.com>, Rodolfo Pagano <
pagano2666@hotmail.com>, rodrigo guedes <ro...@hotmail.com>,
rolim.silva@hotmail.com, romoaldo <al...@omegamed.com.br>, Simone Victor <
monevictor@hotmail.com>, Simone Bezerra <si...@hotmail.com>,
simonifunase <si...@gmail.com>, sizenadofilho@bol.com.br, TIO
ZEZINHO <jo...@hotmail.com>
eu fui......
------------------------------
From: dalvabarodrigues@hotmail.com
To: aagbarbosa4@hotmail.com; adilzamamc@hotmail.com;
drycalcoforado@gmail.com; adriana.pinange@hotmail.com;
alananoblat@hotmail.com; albert.to@yahoo.com.br; alves_juliana1@hotmail.com;
andersonluiz.bento@yahoo.com.br; anageny_ciet@yahoo.com.br;
anatereza_v@hotmail.com; andersonluiz.bento@yahoo.com;
andreaxaves@yahoo.com.br; andrealuizas@ig.com.br;
andreia_silvara@hotmail.com; deiasilvara@hotmail.com; bettchica@hotmail.com;
elizabeth.etr@bol.com.br; bruna_priscila@hotmail.com;
eduardo_abreu.flp@hotmail.com; carmenjmaciel@ig.com.br;
cato_chico@yahoo.com.br; christianomec@hotmail.com;
clarasilvestre@uol.com.br; claudiabf2003@hotmail.com;
clayton_ufpe@yahoo.com.br
Subject: Conselho de Advogado - Importante ler (LG)
Date: Tue, 6 Sep 2011 22:37:10 +0000
*Conselho de **Advogado** - Importante ler*****
****
*Seguem, abaixo, importantes instruçoes que nunca (mas nunca mesmo!) temos
a precaução de realizar para evitar problemas futuros. *****
*Antes tarde do que nunca!*****
* *****
****
****
****
****
*CONSELHO DE ADVOGADO - IMPORTANTE LER*****
****
.****
É MAIS QUE IMPORTANTE, LER, COPIAR E DECORAR!!!!!!!!!!!!! ****
.****
3 bons motivos para repassar: ****
1 - Até que enfim um bom conselho de advogado;****
2 - DE GRAÇA! (Essa é para espantar ainda +)****
3 - O conteúdo é relevante.****
****
****
****
*LER!* ****
*CONSELHO DE ADVOGADO*
Um advogado fez circular a seguinte informação para os empregados de seu
escritório: ****
*1.* *Não assine a parte de trás de seus cartões de crédito*. Em vez disso,
escreva *'SOLICITAR RG'*. ****
*2**.* Ponha seu número de telefone de trabalho em seus cheques em vez de
seu telefone de casa. ****
****
****
Se você tiver uma Caixa Postal de Correio use esta em vez de seu endereço
residencial.****
Se você não tiver uma Caixa Postal, use seu endereço de trabalho. ****
****
Ponha seu telefone celular ao invés do residencial.*
3.* Tire Xerox do conteúdo de sua carteira. Tire cópia *de ambos os lados *de
todos os documentos, cartão de crédito, etc... ****
Você saberá o que você tinha em sua carteira e todos os números de conta e
números de telefone para chamar e cancelar. ****
Mantenha a fotocópia em um lugar seguro. ****
Também leve uma fotocópia de seu passaporte quando for viajar para o
estrangeiro. ****
Sabe-se de muitas estórias de horror de fraudes com nomes, CPF, RG, cartão
de créditos, etc... roubados. ****
Infelizmente, eu, um advogado, tenho conhecimento de primeira mão porque
minha carteira foi roubada no último mês. ****
Dentro de uma semana, os ladrões compraram um caro pacote de telefone
celular, contrataram um cartão de crédito VISA, tiveram uma linha de crédito
aprovada para comprar um computador, dirigiram com minha carteira...*
E MAIS...* ****
*
4.* Nós fomos informados que nós deveríamos cancelar nossos cartões de crédito
imediatamente. ****
Mas a chave é ter os números de telefone gratuitos e os números de cartões à
mão, assim você sabe quem chamar.
Mantenha estes onde você os possa achar com facilidade. *
5.* Abra um Boletim Policial de Ocorrência (B.O.) imediatamente na
jurisdição onde seus cartões de crédito, etc... foram roubados. Isto prova
aos credores que você tomou ações imediatas, e este é um primeiro passo para
uma investigação (se houver uma).*
Mas aqui está o que é talvez mais importante que tudo:**
6.* Chame imediatamente o *SPC*(11-3244-3030) e *SERASA *(11-33737272) e
outros órgãos de crédito (se houver) para pedir que seja colocado um alerta
de fraude em seu nome e número de CPF. ****
Eu nunca tinha ouvido falar disto até que fui avisado por um banco que me
chamou para confirmar sobre uma aplicação para empréstimo que havia sido
feita pela Internet em meu nome. ****
O alerta serve para que qualquer empresa que confira seu crédito saiba que
sua informação foi roubada, e eles têm que contatar você por telefone antes
que o crédito seja aprovado.
Até que eu fosse aconselhado a fazer isto (quase duas semanas depois do
roubo), todo o dano já havia sido feito. ****
Há registros de todos os cheques usados para compras pelos ladrões, nenhum
dos quais - eu soube - depois que eu coloquei o alerta. ****
Desde então, nenhum dano adicional foi feito, e os ladrões jogaram fora
minha carteira. ****
Este fim de semana alguém a devolveu para mim. ****
Esta ação parece ter feito eles desistirem.****
* *
Se roubarem seu Celular...****
A DICA É MUITO INTERESSANTE, ATÉ PORQUE POUCA GENTE TEM O HÁBITO DE LER
MANUAIS. Agora, com esta história do 'Chip', o interesse dos ladrões por
aparelhos celulares aumentou. É só ele comprar um novo chip por um preço
médio de R$30,00 em uma operadora e o instalar no aparelho roubado. Por
isso, está generalizado o roubo de aparelhos celulares.
Segue, então, uma informação útil que os comerciantes de celulares não
divulgam. Uma espécie de vingança para quando roubarem celulares.
Para obter o número de série do seu *telefone* celular (GSM), digite
*#06#Aparecerá no visor um código de algarismos.. Este código é
único!!! Anote e
guarde-o com cuidado!!!
Se roubarem seu celular, telefone para sua operadora e informe este código.
O seu telefone poderá então ser completamente bloqueado, mesmo que o ladrão
mude o 'Chip'. Provavelmente, você não recuperará o aparelho, mas quem quer
que o tenha roubado não poderá mais utilizá-lo.
Se todos tomarem esta precaução, imagine, o roubo de celulares se tornará
inútil. Envie isto a todos e não esqueça de anotar o número de série do seu
celular!!! ****
*Passamos para frente muitas piadas pela Internet . *****
*Mas se você estiver disposto a passar esta informação, *****
*realmente poderá ajudar alguém!* ****
****
** **
****
****
****
****
****
****
****
****
****
****
****
****
****
****
****
**
**
------------------------------
E-mail verificado pelo Terra Anti-Spam.
Para classificar esta mensagem como spam ou não spam, clique
aqui<http://ecp.terra.com.br/cgi-bin/reportspam.cgi?+_d=SCY0MzUxNDgwI3Blcm0hdGVycmEmMSwxMzE1MDYzNjY3LjQ4Nzg1NC40NDM5LmJldHVuZS50cG4udGVycmEuY29tLDM0NjQwTerraMail>
.
Verifique periodicamente a pasta Spam para garantir que apenas mensagens
indesejadas sejam classificadas como Spam.
------------------------------
Esta mensagem foi verificada pelo E-mail Protegido Terra.
Atualizado em 02/09/2011
------------------------------
E-mail verificado pelo Terra Anti-Spam.
Para classificar esta mensagem como spam ou não spam, clique
aqui<http://ecp.terra.com.br/cgi-bin/reportspam.cgi?+_d=SCY0MzUxNDgwI3Blcm0hdGVycmEmMSwxMzE1MDY0MjM2LjYxNDExNS4xNjYwMi5wcmV2b3N0LnRwbi50ZXJyYS5jb20sNDUxMjg=TerraMail>
.
Verifique periodicamente a pasta Spam para garantir que apenas mensagens
indesejadas sejam classificadas como Spam.
------------------------------
Esta mensagem foi verificada pelo E-mail Protegido Terra.
Atualizado em 02/09/2011
--
View this message in context: http://apache-poi.1045710.n5.nabble.com/Apache-POI-3-8-SXSSFWorkbook-Unreadable-Content-tp4658852p4780327.html
Sent from the POI - Dev mailing list archive at Nabble.com.
Re: Apache POI 3.8 (SXSSFWorkbook) - Unreadable Content
Posted by Yegor Kozlov <ye...@dinom.ru>.
Fixed in r1154323, junit added.
Yegor
On Thu, Aug 4, 2011 at 4:54 PM, Yegor Kozlov <ye...@dinom.ru> wrote:
> I'm going to fix the issue by writing   instead. Unicode
> chars beyond D7FF are not relevant to this bug and unlikely to cause
> problems.
>
> Yegor
>
> On Thu, Aug 4, 2011 at 3:41 PM, jguilhermemv <jg...@gmail.com> wrote:
>> Yegor,
>>
>> Could you tell us which approach are you going to use to fix this?
>>
>>
>> 2011/8/4 Yegor Kozlov-4 [via Apache POI] <
>> ml-node+4665842-1534849639-237524@n5.nabble.com>
>>
>>> On Wed, Aug 3, 2011 at 8:27 PM, Alex Geller <[hidden email]<http://user/SendEmail.jtp?type=node&node=4665842&i=0>>
>>> wrote:
>>> > The bug is in line 1505 of
>>> > src/ooxml/java/org/apache/poi/xssf/streaming/SXSSFSheet.java where the
>>> non
>>> > breaking space in quoted in HTML manner (" ") instead of using a
>>> > unicode escape (" ").
>>> > @Yegor: will you take care of it?
>>>
>>> Sure, I will take care of it. The fix is trivial.
>>>
>>>
>>> Yegor
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: [hidden email]<http://user/SendEmail.jtp?type=node&node=4665842&i=1>
>>> For additional commands, e-mail: [hidden email]<http://user/SendEmail.jtp?type=node&node=4665842&i=2>
>>>
>>>
>>>
>>> ------------------------------
>>> If you reply to this email, your message will be added to the discussion
>>> below:
>>>
>>> http://apache-poi.1045710.n5.nabble.com/Apache-POI-3-8-SXSSFWorkbook-Unreadable-Content-tp4658852p4665842.html
>>> To unsubscribe from Apache POI 3.8 (SXSSFWorkbook) - Unreadable Content, click
>>> here<http://apache-poi.1045710.n5.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=4658852&code=amd1aWxoZXJtZW12QGdtYWlsLmNvbXw0NjU4ODUyfDg3MzU2ODc4NA==>.
>>>
>>>
>>
>>
>> --
>> View this message in context: http://apache-poi.1045710.n5.nabble.com/Apache-POI-3-8-SXSSFWorkbook-Unreadable-Content-tp4658852p4666001.html
>> Sent from the POI - Dev mailing list archive at Nabble.com.
>
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
Re: Apache POI 3.8 (SXSSFWorkbook) - Unreadable Content
Posted by Yegor Kozlov <ye...@dinom.ru>.
I'm going to fix the issue by writing   instead. Unicode
chars beyond D7FF are not relevant to this bug and unlikely to cause
problems.
Yegor
On Thu, Aug 4, 2011 at 3:41 PM, jguilhermemv <jg...@gmail.com> wrote:
> Yegor,
>
> Could you tell us which approach are you going to use to fix this?
>
>
> 2011/8/4 Yegor Kozlov-4 [via Apache POI] <
> ml-node+4665842-1534849639-237524@n5.nabble.com>
>
>> On Wed, Aug 3, 2011 at 8:27 PM, Alex Geller <[hidden email]<http://user/SendEmail.jtp?type=node&node=4665842&i=0>>
>> wrote:
>> > The bug is in line 1505 of
>> > src/ooxml/java/org/apache/poi/xssf/streaming/SXSSFSheet.java where the
>> non
>> > breaking space in quoted in HTML manner (" ") instead of using a
>> > unicode escape (" ").
>> > @Yegor: will you take care of it?
>>
>> Sure, I will take care of it. The fix is trivial.
>>
>>
>> Yegor
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: [hidden email]<http://user/SendEmail.jtp?type=node&node=4665842&i=1>
>> For additional commands, e-mail: [hidden email]<http://user/SendEmail.jtp?type=node&node=4665842&i=2>
>>
>>
>>
>> ------------------------------
>> If you reply to this email, your message will be added to the discussion
>> below:
>>
>> http://apache-poi.1045710.n5.nabble.com/Apache-POI-3-8-SXSSFWorkbook-Unreadable-Content-tp4658852p4665842.html
>> To unsubscribe from Apache POI 3.8 (SXSSFWorkbook) - Unreadable Content, click
>> here<http://apache-poi.1045710.n5.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=4658852&code=amd1aWxoZXJtZW12QGdtYWlsLmNvbXw0NjU4ODUyfDg3MzU2ODc4NA==>.
>>
>>
>
>
> --
> View this message in context: http://apache-poi.1045710.n5.nabble.com/Apache-POI-3-8-SXSSFWorkbook-Unreadable-Content-tp4658852p4666001.html
> Sent from the POI - Dev mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
Re: Apache POI 3.8 (SXSSFWorkbook) - Unreadable Content
Posted by jguilhermemv <jg...@gmail.com>.
Yegor,
Could you tell us which approach are you going to use to fix this?
2011/8/4 Yegor Kozlov-4 [via Apache POI] <
ml-node+4665842-1534849639-237524@n5.nabble.com>
> On Wed, Aug 3, 2011 at 8:27 PM, Alex Geller <[hidden email]<http://user/SendEmail.jtp?type=node&node=4665842&i=0>>
> wrote:
> > The bug is in line 1505 of
> > src/ooxml/java/org/apache/poi/xssf/streaming/SXSSFSheet.java where the
> non
> > breaking space in quoted in HTML manner (" ") instead of using a
> > unicode escape (" ").
> > @Yegor: will you take care of it?
>
> Sure, I will take care of it. The fix is trivial.
>
>
> Yegor
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [hidden email]<http://user/SendEmail.jtp?type=node&node=4665842&i=1>
> For additional commands, e-mail: [hidden email]<http://user/SendEmail.jtp?type=node&node=4665842&i=2>
>
>
>
> ------------------------------
> If you reply to this email, your message will be added to the discussion
> below:
>
> http://apache-poi.1045710.n5.nabble.com/Apache-POI-3-8-SXSSFWorkbook-Unreadable-Content-tp4658852p4665842.html
> To unsubscribe from Apache POI 3.8 (SXSSFWorkbook) - Unreadable Content, click
> here<http://apache-poi.1045710.n5.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=4658852&code=amd1aWxoZXJtZW12QGdtYWlsLmNvbXw0NjU4ODUyfDg3MzU2ODc4NA==>.
>
>
--
View this message in context: http://apache-poi.1045710.n5.nabble.com/Apache-POI-3-8-SXSSFWorkbook-Unreadable-Content-tp4658852p4666001.html
Sent from the POI - Dev mailing list archive at Nabble.com.
Fwd: FW: Conselho de Advogado - Importante ler (LG)
Posted by jguilhermemv <jg...@gmail.com>.
Atenciosamente,
José Guilherme Macedo Vieira
Desenvolvedor Java EE
-----------------------------------
Telefone: 081-87127316
Skype: williaminbrazil
GTalk: jguilhermemv@gmail.com
---------- Mensagem encaminhada ----------
De: Augusto Galvao Barbosa <aa...@hotmail.com>
Data: 7 de setembro de 2011 18:04
Assunto: FW: Conselho de Advogado - Importante ler (LG)
Para: adriana <ad...@hotmail.com>, Aelson luis <
aelsonluis@hotmail.com>, agalvao@bol.com.br, Anderson SB <wa...@hotmail.com>,
Andreia Moreira <de...@hotmail.com>, araujo <de...@hotmail.com>,
arimagalvao@hotmail.com, arimargalvao@hotmail.com, Augusto Galvao Barbosa <
aagbarbosa4@hotmail.com>, augusto_medeiross@hotmail.com,
bobothy.m@hotmail.com, charlene_sheila@hotmail.com, Cleiton Cavalcanti <
cleitoncavalcanti_69@hotmail.com>, compras jc <co...@jc.com.br>,
cpljosiani@hotmail.com, dandacomercio@yahoo.com.br, daniel funase <
daniel_valenca@hotmail.com>, DIEGO VICENTE RIBEIRO RIBEIRO <
diegoevo25@hotmail.com>, ebp.solucoesemti@hotmail.com, edsonss@ig.com.br,
Eduardo Silva <fl...@yahoo.com.br>, Eduardo Silva <
flavialuiza3000@yahoo.com>, Eduardo Silva <ed...@hotmail.com>, Everson
Gomes <ev...@hotmail.com>, Everton Barbosa <ev...@hotmail.com>,
fabioalbuquerque@fade.org.br, filho de gleudes <jg...@gmail.com>,
filipe mauricio <fi...@hotmail.com>, filipemauricio@hotmail.com,
franquiashavaianas@alpargatas.com.br, Geovanni Nunes <va...@hotmail.com>,
hmlcomercial@ig.com.br, "iraci@recife.pe.gov.br" <ir...@recife.pe.gov.br>,
Ismaylton Pereira <is...@hotmail.com>, Ivan Lira <
totemoabunai@hotmail.com>, Jocy Melo <jo...@hotmail.com>,
jocypaulojose@hotmail.com, josinomelo@hotmail.com, Mag Mel <
mag.mel@hotmail.com>, Magaly Bezerra <ma...@hotmail.com>, mario silva <
rolinsilva@hotmail.com>, Maurycio Melo <ma...@hotmail.com>, Maysa de
Melo Bezerra <sa...@hotmail.com>, MÔNICA MELO <
monicaneoplanos1@hotmail.com>, monicamelo_estrela@hotmail.com, "
morgana@recife.pe.gov.br" <mo...@recife.pe.gov.br>, nya_galvao@hotmail.com,
omegames <do...@omegamed.com.br>, osmam silva <os...@hotmail.com>,
osmanp@hotmail.com, pc pc <pa...@hotmail.com>,
richard_cavalcanti@hotmail.com, Roberta Rijo <ro...@hotmail.com>,
roberto pires pires <ro...@hotmail.com>, Rodolfo Pagano <
pagano2666@hotmail.com>, rodrigo guedes <ro...@hotmail.com>,
rolim.silva@hotmail.com, romoaldo <al...@omegamed.com.br>, Simone Victor <
monevictor@hotmail.com>, Simone Bezerra <si...@hotmail.com>,
simonifunase <si...@gmail.com>, sizenadofilho@bol.com.br, TIO
ZEZINHO <jo...@hotmail.com>
eu fui......
------------------------------
From: dalvabarodrigues@hotmail.com
To: aagbarbosa4@hotmail.com; adilzamamc@hotmail.com;
drycalcoforado@gmail.com; adriana.pinange@hotmail.com;
alananoblat@hotmail.com; albert.to@yahoo.com.br; alves_juliana1@hotmail.com;
andersonluiz.bento@yahoo.com.br; anageny_ciet@yahoo.com.br;
anatereza_v@hotmail.com; andersonluiz.bento@yahoo.com;
andreaxaves@yahoo.com.br; andrealuizas@ig.com.br;
andreia_silvara@hotmail.com; deiasilvara@hotmail.com; bettchica@hotmail.com;
elizabeth.etr@bol.com.br; bruna_priscila@hotmail.com;
eduardo_abreu.flp@hotmail.com; carmenjmaciel@ig.com.br;
cato_chico@yahoo.com.br; christianomec@hotmail.com;
clarasilvestre@uol.com.br; claudiabf2003@hotmail.com;
clayton_ufpe@yahoo.com.br
Subject: Conselho de Advogado - Importante ler (LG)
Date: Tue, 6 Sep 2011 22:37:10 +0000
*Conselho de **Advogado** - Importante ler*****
****
*Seguem, abaixo, importantes instruçoes que nunca (mas nunca mesmo!) temos
a precaução de realizar para evitar problemas futuros. *****
*Antes tarde do que nunca!*****
* *****
****
****
****
****
*CONSELHO DE ADVOGADO - IMPORTANTE LER*****
****
.****
É MAIS QUE IMPORTANTE, LER, COPIAR E DECORAR!!!!!!!!!!!!! ****
.****
3 bons motivos para repassar: ****
1 - Até que enfim um bom conselho de advogado;****
2 - DE GRAÇA! (Essa é para espantar ainda +)****
3 - O conteúdo é relevante.****
****
****
****
*LER!* ****
*CONSELHO DE ADVOGADO*
Um advogado fez circular a seguinte informação para os empregados de seu
escritório: ****
*1.* *Não assine a parte de trás de seus cartões de crédito*. Em vez disso,
escreva *'SOLICITAR RG'*. ****
*2**.* Ponha seu número de telefone de trabalho em seus cheques em vez de
seu telefone de casa. ****
****
****
Se você tiver uma Caixa Postal de Correio use esta em vez de seu endereço
residencial.****
Se você não tiver uma Caixa Postal, use seu endereço de trabalho. ****
****
Ponha seu telefone celular ao invés do residencial.*
3.* Tire Xerox do conteúdo de sua carteira. Tire cópia *de ambos os lados *de
todos os documentos, cartão de crédito, etc... ****
Você saberá o que você tinha em sua carteira e todos os números de conta e
números de telefone para chamar e cancelar. ****
Mantenha a fotocópia em um lugar seguro. ****
Também leve uma fotocópia de seu passaporte quando for viajar para o
estrangeiro. ****
Sabe-se de muitas estórias de horror de fraudes com nomes, CPF, RG, cartão
de créditos, etc... roubados. ****
Infelizmente, eu, um advogado, tenho conhecimento de primeira mão porque
minha carteira foi roubada no último mês. ****
Dentro de uma semana, os ladrões compraram um caro pacote de telefone
celular, contrataram um cartão de crédito VISA, tiveram uma linha de crédito
aprovada para comprar um computador, dirigiram com minha carteira...*
E MAIS...* ****
*
4.* Nós fomos informados que nós deveríamos cancelar nossos cartões de crédito
imediatamente. ****
Mas a chave é ter os números de telefone gratuitos e os números de cartões à
mão, assim você sabe quem chamar.
Mantenha estes onde você os possa achar com facilidade. *
5.* Abra um Boletim Policial de Ocorrência (B.O.) imediatamente na
jurisdição onde seus cartões de crédito, etc... foram roubados. Isto prova
aos credores que você tomou ações imediatas, e este é um primeiro passo para
uma investigação (se houver uma).*
Mas aqui está o que é talvez mais importante que tudo:**
6.* Chame imediatamente o *SPC*(11-3244-3030) e *SERASA *(11-33737272) e
outros órgãos de crédito (se houver) para pedir que seja colocado um alerta
de fraude em seu nome e número de CPF. ****
Eu nunca tinha ouvido falar disto até que fui avisado por um banco que me
chamou para confirmar sobre uma aplicação para empréstimo que havia sido
feita pela Internet em meu nome. ****
O alerta serve para que qualquer empresa que confira seu crédito saiba que
sua informação foi roubada, e eles têm que contatar você por telefone antes
que o crédito seja aprovado.
Até que eu fosse aconselhado a fazer isto (quase duas semanas depois do
roubo), todo o dano já havia sido feito. ****
Há registros de todos os cheques usados para compras pelos ladrões, nenhum
dos quais - eu soube - depois que eu coloquei o alerta. ****
Desde então, nenhum dano adicional foi feito, e os ladrões jogaram fora
minha carteira. ****
Este fim de semana alguém a devolveu para mim. ****
Esta ação parece ter feito eles desistirem.****
* *
Se roubarem seu Celular...****
A DICA É MUITO INTERESSANTE, ATÉ PORQUE POUCA GENTE TEM O HÁBITO DE LER
MANUAIS. Agora, com esta história do 'Chip', o interesse dos ladrões por
aparelhos celulares aumentou. É só ele comprar um novo chip por um preço
médio de R$30,00 em uma operadora e o instalar no aparelho roubado. Por
isso, está generalizado o roubo de aparelhos celulares.
Segue, então, uma informação útil que os comerciantes de celulares não
divulgam. Uma espécie de vingança para quando roubarem celulares.
Para obter o número de série do seu *telefone* celular (GSM), digite
*#06#Aparecerá no visor um código de algarismos.. Este código é
único!!! Anote e
guarde-o com cuidado!!!
Se roubarem seu celular, telefone para sua operadora e informe este código.
O seu telefone poderá então ser completamente bloqueado, mesmo que o ladrão
mude o 'Chip'. Provavelmente, você não recuperará o aparelho, mas quem quer
que o tenha roubado não poderá mais utilizá-lo.
Se todos tomarem esta precaução, imagine, o roubo de celulares se tornará
inútil. Envie isto a todos e não esqueça de anotar o número de série do seu
celular!!! ****
*Passamos para frente muitas piadas pela Internet . *****
*Mas se você estiver disposto a passar esta informação, *****
*realmente poderá ajudar alguém!* ****
****
** **
****
****
****
****
****
****
****
****
****
****
****
****
****
****
****
**
**
------------------------------
E-mail verificado pelo Terra Anti-Spam.
Para classificar esta mensagem como spam ou não spam, clique
aqui<http://ecp.terra.com.br/cgi-bin/reportspam.cgi?+_d=SCY0MzUxNDgwI3Blcm0hdGVycmEmMSwxMzE1MDYzNjY3LjQ4Nzg1NC40NDM5LmJldHVuZS50cG4udGVycmEuY29tLDM0NjQwTerraMail>
.
Verifique periodicamente a pasta Spam para garantir que apenas mensagens
indesejadas sejam classificadas como Spam.
------------------------------
Esta mensagem foi verificada pelo E-mail Protegido Terra.
Atualizado em 02/09/2011
------------------------------
E-mail verificado pelo Terra Anti-Spam.
Para classificar esta mensagem como spam ou não spam, clique
aqui<http://ecp.terra.com.br/cgi-bin/reportspam.cgi?+_d=SCY0MzUxNDgwI3Blcm0hdGVycmEmMSwxMzE1MDY0MjM2LjYxNDExNS4xNjYwMi5wcmV2b3N0LnRwbi50ZXJyYS5jb20sNDUxMjg=TerraMail>
.
Verifique periodicamente a pasta Spam para garantir que apenas mensagens
indesejadas sejam classificadas como Spam.
------------------------------
Esta mensagem foi verificada pelo E-mail Protegido Terra.
Atualizado em 02/09/2011
--
View this message in context: http://apache-poi.1045710.n5.nabble.com/Apache-POI-3-8-SXSSFWorkbook-Unreadable-Content-tp4658852p4780325.html
Sent from the POI - Dev mailing list archive at Nabble.com.
Re: Apache POI 3.8 (SXSSFWorkbook) - Unreadable Content
Posted by Yegor Kozlov <ye...@dinom.ru>.
On Wed, Aug 3, 2011 at 8:27 PM, Alex Geller <ag...@4js.com> wrote:
> The bug is in line 1505 of
> src/ooxml/java/org/apache/poi/xssf/streaming/SXSSFSheet.java where the non
> breaking space in quoted in HTML manner (" ") instead of using a
> unicode escape (" ").
> @Yegor: will you take care of it?
Sure, I will take care of it. The fix is trivial.
Yegor
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
Re: Apache POI 3.8 (SXSSFWorkbook) - Unreadable Content
Posted by Alex Geller <ag...@4js.com>.
Oops, apparently the text needs to be quoted on this forum. The unicode
escape should be "&#xa0;" instead of "&nbsp;".
Regards,
Alex
--
View this message in context: http://apache-poi.1045710.n5.nabble.com/Apache-POI-3-8-SXSSFWorkbook-Unreadable-Content-tp4658852p4662866.html
Sent from the POI - Dev mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
Re: Apache POI 3.8 (SXSSFWorkbook) - Unreadable Content
Posted by Alex Geller <ag...@4js.com>.
The bug is in line 1505 of
src/ooxml/java/org/apache/poi/xssf/streaming/SXSSFSheet.java where the non
breaking space in quoted in HTML manner (" ") instead of using a
unicode escape (" ").
@Yegor: will you take care of it?
Sorry for the trouble.
Regards,
Alex
--
View this message in context: http://apache-poi.1045710.n5.nabble.com/Apache-POI-3-8-SXSSFWorkbook-Unreadable-Content-tp4658852p4662850.html
Sent from the POI - Dev mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
Re: Apache POI 3.8 (SXSSFWorkbook) - Unreadable Content
Posted by Guilherme Vieira <jg...@gmail.com>.
Yegor,
Where can I find information about zipping and unzipping these files?
Best regards,
José Guilherme Macedo Vieira
2011/8/3 Yegor Kozlov <ye...@dinom.ru>
> It would be a valuable contribution if you generate two worksheets
> containing strings with \u00a0. One with SXSSF and the other with
> XSSF. You can use my code snippet. Then unzip the files, compare and
> figure out what's wrong with handling \u00a0 in SXSSF.
>
> You want to look at sharedStrings.xml and sheet1.xml.
>
> Yegor
>
> On Wed, Aug 3, 2011 at 4:22 PM, Guilherme Vieira <jg...@gmail.com>
> wrote:
> > I can help you if you can. We can work together to fix the issues and
> > develop new features.
> >
> > Cheers.
> > José Guilherme Macedo Vieira
> >
> >
> > 2011/8/3 Yegor Kozlov <ye...@dinom.ru>
> >
> >> So far the plan is to release it in late August.
> >>
> >> Yegor
> >>
> >> On Wed, Aug 3, 2011 at 3:01 PM, Guilherme Vieira <
> jguilhermemv@gmail.com>
> >> wrote:
> >> > Yegor,
> >> >
> >> > I'm glad to help you to find this issue. This is exactly the problem.
> By
> >> now
> >> > I'm trying to fix it in my own code by replacing these characters.
> Though
> >> > the beta4 is not out yet I'm still using it in my project because I
> need
> >> to
> >> > write an excel with >100.000 lines. Do you know when the beta4 is
> gonna
> >> be
> >> > out?
> >> >
> >> > Cheers,
> >> > José Guilherme Macedo Vieira
> >> >
> >> >
> >> >
> >> > 2011/8/3 Yegor Kozlov <ye...@dinom.ru>
> >> >
> >> >> The culprit is the non-break space (charcode=\u00a0). I was able to
> >> >> reproduce the trouble with the following code:
> >> >>
> >> >> Workbook wb = new SXSSFWorkbook();
> >> >> Sheet sh = wb.createSheet();
> >> >> Row row = sh.createRow(0);
> >> >> row.createCell(0).setCellValue("ALEXANDRE\u00a0MARINHO DE
> >> SOUZA");
> >> >> FileOutputStream out = new
> FileOutputStream("/temp/test.xlsx");
> >> >> wb.write(out);
> >> >> out.close();
> >> >>
> >> >> The fix is coming soon and will be included in 3.8-beta4.
> >> >>
> >> >> Cheers,
> >> >> Yegor
> >> >>
> >> >> On Wed, Aug 3, 2011 at 1:59 PM, Guilherme Vieira <
> >> jguilhermemv@gmail.com>
> >> >> wrote:
> >> >> > Dear Yegor,
> >> >> >
> >> >> > Your tip didn't work. So I guessed that there was a non-printable
> >> >> character
> >> >> > instead of white spaces. That said I tried to encode it with
> >> >> > URLEncoder.encode("the name goes here","ASCII"); and guess what?
> The
> >> >> encoded
> >> >> > name is as below:
> >> >> >
> >> >> > ALEXANDRE%3BF+MARINHO+DE+SOUZA
> >> >> >
> >> >> > It interesting because I can't remove it with replace all because
> we
> >> have
> >> >> > non-printable characters. So, I'm trying to find a regular
> expression
> >> >> that
> >> >> > matches to these expressions (%3BF and + ,respectively). It would
> be
> >> nice
> >> >> if
> >> >> > I could find a regular expression that matches to any special
> >> >> non-printable
> >> >> > characters. So, how do I proceed?
> >> >> >
> >> >> > And thanks in advance for your answer as well for your GREAT work
> in
> >> >> Apache
> >> >> > POI with the Big Grid Demo approach. It is just wonderful. Can't
> wait
> >> for
> >> >> > the final release (3.8-beta4).
> >> >> >
> >> >> > Best regards,
> >> >> > José Guilherme Macedo Vieira
> >> >> >
> >> >> >
> >> >> > 2011/8/3 Yegor Kozlov <ye...@dinom.ru>
> >> >> >
> >> >> >> Tweak your report generator and try the following tricks before
> >> >> >> passing strings to SXSSFCell:
> >> >> >>
> >> >> >> (a) string.replaceAll("\\s+", ""); // replace multiple white
> spaces
> >> >> >> with a single space
> >> >> >> (b) string.replace(' ', '_'); // replace white spaces with
> >> underscore
> >> >> >>
> >> >> >> Does any of (a) and (b) help?
> >> >> >>
> >> >> >> My hunch is that the problem is in something else, not in double
> >> white
> >> >> >> spaces. At least, I can't reproduce the problem with the following
> >> >> >> code snippet:
> >> >> >>
> >> >> >> Workbook wb = new SXSSFWorkbook();
> >> >> >> Sheet sh = wb.createSheet();
> >> >> >> for(int i = 0; i < 10000; i++) {
> >> >> >> Row row = sh.createRow(i);
> >> >> >> row.createCell(0).setCellValue("ALEXANDRE__MARINHO DE
> >> >> SOUZA");
> >> >> >> row.createCell(1).setCellValue("ALEXANDRE MARINHO DE
> >> SOUZA");
> >> >> >> row.createCell(2).setCellValue("ALEXANDRE MARINHO DE
> >> >> SOUZA");
> >> >> >> row.createCell(3).setCellValue("ALEXANDRE MARINHO DE
> >> >> SOUZA");
> >> >> >> }
> >> >> >>
> >> >> >> FileOutputStream out = new
> >> FileOutputStream("/temp/test.xlsx");
> >> >> >> wb.write(out);
> >> >> >> out.close();
> >> >> >>
> >> >> >> The generated file is readable and all spaces are there.
> >> >> >>
> >> >> >> Yegor
> >> >> >>
> >> >> >> On Tue, Aug 2, 2011 at 11:49 PM, Guilherme Vieira
> >> >> >> <jg...@gmail.com> wrote:
> >> >> >> > So, I've searched column by column in the problematic line in
> order
> >> to
> >> >> >> > identify the problem. The problem is quite weird. It's a string
> >> column
> >> >> in
> >> >> >> > the database. This column stores people names.
> >> >> >> >
> >> >> >> > In my problem the name is: ALEXANDRE__MARINHO DE SOUZA
> >> >> >> >
> >> >> >> > Of course, without the underline character. Instead it is a
> >> whitespace
> >> >> >> > character. So, when with double whitespace character the file is
> >> >> >> corrupted.
> >> >> >> > And when I manually remove the one whitespace in the IDE, the
> file
> >> is
> >> >> >> also
> >> >> >> > corrupted. But when I change the whole name manually in the IDE,
> >> >> setting
> >> >> >> the
> >> >> >> > value to ALEXANDRE_MARINHO DE SOUZA, it works. It's strange. I
> >> don't
> >> >> know
> >> >> >> > why SXSSF is not accepting two whitespaces.
> >> >> >> >
> >> >> >> > Anyone have a clue?
> >> >> >> >
> >> >> >> >
> >> >> >> >
> >> >> >> > 2011/8/2 jguilhermemv <jg...@gmail.com>
> >> >> >> >
> >> >> >> >> I tried without merged region and it didn't work. So, I noticed
> >> that
> >> >> >> there
> >> >> >> >> is a line in the file which present the error. It's the line
> >> (2451)
> >> >> and
> >> >> >> >> until the line 2450 everything works great. But for some reason
> >> when
> >> >> it
> >> >> >> >> reach the line 2450 it just doesn't work. I checked if the was
> any
> >> >> null
> >> >> >> >> values, but there wasn't. The writing routine is right,
> otherwise
> >> it
> >> >> >> >> wouldn't write until the line 2450.
> >> >> >> >>
> >> >> >> >> What can I do now?
> >> >> >> >>
> >> >> >> >> Best regards.
> >> >> >> >> José Guilherme Macedo Vieira
> >> >> >> >>
> >> >> >> >>
> >> >> >> >> 2011/8/2 Nick Burch-11 [via Apache POI] <
> >> >> >> >> ml-node+4658878-753894702-237524@n5.nabble.com>
> >> >> >> >>
> >> >> >> >> > On Tue, 2 Aug 2011, jguilhermemv wrote:
> >> >> >> >> > > Regarding the file, it makes use of some CellStyles and
> Merged
> >> >> >> Regions.
> >> >> >> >> >
> >> >> >> >> > Try without them, and see if that fixes it. You need to
> narrow
> >> your
> >> >> >> >> > problem down before you can figure out what to correct. Try
> to
> >> >> >> identify
> >> >> >> >> > the simplest file that fails, and the most complex one that
> >> works,
> >> >> the
> >> >> >> >> gap
> >> >> >> >> > there is your issue
> >> >> >> >> >
> >> >> >> >> > Nick
> >> >> >> >> >
> >> >> >> >> >
> >> >> ---------------------------------------------------------------------
> >> >> >> >> > To unsubscribe, e-mail: [hidden email]<
> >> >> >> >> http://user/SendEmail.jtp?type=node&node=4658878&i=0>
> >> >> >> >> > For additional commands, e-mail: [hidden email]<
> >> >> >> >> http://user/SendEmail.jtp?type=node&node=4658878&i=1>
> >> >> >> >> >
> >> >> >> >> >
> >> >> >> >> >
> >> >> >> >> > ------------------------------
> >> >> >> >> > If you reply to this email, your message will be added to
> the
> >> >> >> discussion
> >> >> >> >> > below:
> >> >> >> >> >
> >> >> >> >> >
> >> >> >> >>
> >> >> >>
> >> >>
> >>
> http://apache-poi.1045710.n5.nabble.com/Apache-POI-3-8-SXSSFWorkbook-Unreadable-Content-tp4658852p4658878.html
> >> >> >> >> > To unsubscribe from Apache POI 3.8 (SXSSFWorkbook) -
> Unreadable
> >> >> >> Content,
> >> >> >> >> click
> >> >> >> >> > here<
> >> >> >> >>
> >> >> >>
> >> >>
> >>
> http://apache-poi.1045710.n5.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=4658852&code=amd1aWxoZXJtZW12QGdtYWlsLmNvbXw0NjU4ODUyfDg3MzU2ODc4NA==
> >> >> >> >> >.
> >> >> >> >> >
> >> >> >> >> >
> >> >> >> >>
> >> >> >> >>
> >> >> >> >> --
> >> >> >> >> View this message in context:
> >> >> >> >>
> >> >> >>
> >> >>
> >>
> http://apache-poi.1045710.n5.nabble.com/Apache-POI-3-8-SXSSFWorkbook-Unreadable-Content-tp4658852p4659737.html
> >> >> >> >> Sent from the POI - Dev mailing list archive at Nabble.com.
> >> >> >> >>
> >> >> >> >
> >> >> >>
> >> >> >>
> ---------------------------------------------------------------------
> >> >> >> To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
> >> >> >> For additional commands, e-mail: dev-help@poi.apache.org
> >> >> >>
> >> >> >>
> >> >> >
> >> >>
> >> >> ---------------------------------------------------------------------
> >> >> To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
> >> >> For additional commands, e-mail: dev-help@poi.apache.org
> >> >>
> >> >>
> >> >
> >>
> >> ---------------------------------------------------------------------
> >> To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
> >> For additional commands, e-mail: dev-help@poi.apache.org
> >>
> >>
> >
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
> For additional commands, e-mail: dev-help@poi.apache.org
>
>
Re: Apache POI 3.8 (SXSSFWorkbook) - Unreadable Content
Posted by Yegor Kozlov <ye...@dinom.ru>.
It would be a valuable contribution if you generate two worksheets
containing strings with \u00a0. One with SXSSF and the other with
XSSF. You can use my code snippet. Then unzip the files, compare and
figure out what's wrong with handling \u00a0 in SXSSF.
You want to look at sharedStrings.xml and sheet1.xml.
Yegor
On Wed, Aug 3, 2011 at 4:22 PM, Guilherme Vieira <jg...@gmail.com> wrote:
> I can help you if you can. We can work together to fix the issues and
> develop new features.
>
> Cheers.
> José Guilherme Macedo Vieira
>
>
> 2011/8/3 Yegor Kozlov <ye...@dinom.ru>
>
>> So far the plan is to release it in late August.
>>
>> Yegor
>>
>> On Wed, Aug 3, 2011 at 3:01 PM, Guilherme Vieira <jg...@gmail.com>
>> wrote:
>> > Yegor,
>> >
>> > I'm glad to help you to find this issue. This is exactly the problem. By
>> now
>> > I'm trying to fix it in my own code by replacing these characters. Though
>> > the beta4 is not out yet I'm still using it in my project because I need
>> to
>> > write an excel with >100.000 lines. Do you know when the beta4 is gonna
>> be
>> > out?
>> >
>> > Cheers,
>> > José Guilherme Macedo Vieira
>> >
>> >
>> >
>> > 2011/8/3 Yegor Kozlov <ye...@dinom.ru>
>> >
>> >> The culprit is the non-break space (charcode=\u00a0). I was able to
>> >> reproduce the trouble with the following code:
>> >>
>> >> Workbook wb = new SXSSFWorkbook();
>> >> Sheet sh = wb.createSheet();
>> >> Row row = sh.createRow(0);
>> >> row.createCell(0).setCellValue("ALEXANDRE\u00a0MARINHO DE
>> SOUZA");
>> >> FileOutputStream out = new FileOutputStream("/temp/test.xlsx");
>> >> wb.write(out);
>> >> out.close();
>> >>
>> >> The fix is coming soon and will be included in 3.8-beta4.
>> >>
>> >> Cheers,
>> >> Yegor
>> >>
>> >> On Wed, Aug 3, 2011 at 1:59 PM, Guilherme Vieira <
>> jguilhermemv@gmail.com>
>> >> wrote:
>> >> > Dear Yegor,
>> >> >
>> >> > Your tip didn't work. So I guessed that there was a non-printable
>> >> character
>> >> > instead of white spaces. That said I tried to encode it with
>> >> > URLEncoder.encode("the name goes here","ASCII"); and guess what? The
>> >> encoded
>> >> > name is as below:
>> >> >
>> >> > ALEXANDRE%3BF+MARINHO+DE+SOUZA
>> >> >
>> >> > It interesting because I can't remove it with replace all because we
>> have
>> >> > non-printable characters. So, I'm trying to find a regular expression
>> >> that
>> >> > matches to these expressions (%3BF and + ,respectively). It would be
>> nice
>> >> if
>> >> > I could find a regular expression that matches to any special
>> >> non-printable
>> >> > characters. So, how do I proceed?
>> >> >
>> >> > And thanks in advance for your answer as well for your GREAT work in
>> >> Apache
>> >> > POI with the Big Grid Demo approach. It is just wonderful. Can't wait
>> for
>> >> > the final release (3.8-beta4).
>> >> >
>> >> > Best regards,
>> >> > José Guilherme Macedo Vieira
>> >> >
>> >> >
>> >> > 2011/8/3 Yegor Kozlov <ye...@dinom.ru>
>> >> >
>> >> >> Tweak your report generator and try the following tricks before
>> >> >> passing strings to SXSSFCell:
>> >> >>
>> >> >> (a) string.replaceAll("\\s+", ""); // replace multiple white spaces
>> >> >> with a single space
>> >> >> (b) string.replace(' ', '_'); // replace white spaces with
>> underscore
>> >> >>
>> >> >> Does any of (a) and (b) help?
>> >> >>
>> >> >> My hunch is that the problem is in something else, not in double
>> white
>> >> >> spaces. At least, I can't reproduce the problem with the following
>> >> >> code snippet:
>> >> >>
>> >> >> Workbook wb = new SXSSFWorkbook();
>> >> >> Sheet sh = wb.createSheet();
>> >> >> for(int i = 0; i < 10000; i++) {
>> >> >> Row row = sh.createRow(i);
>> >> >> row.createCell(0).setCellValue("ALEXANDRE__MARINHO DE
>> >> SOUZA");
>> >> >> row.createCell(1).setCellValue("ALEXANDRE MARINHO DE
>> SOUZA");
>> >> >> row.createCell(2).setCellValue("ALEXANDRE MARINHO DE
>> >> SOUZA");
>> >> >> row.createCell(3).setCellValue("ALEXANDRE MARINHO DE
>> >> SOUZA");
>> >> >> }
>> >> >>
>> >> >> FileOutputStream out = new
>> FileOutputStream("/temp/test.xlsx");
>> >> >> wb.write(out);
>> >> >> out.close();
>> >> >>
>> >> >> The generated file is readable and all spaces are there.
>> >> >>
>> >> >> Yegor
>> >> >>
>> >> >> On Tue, Aug 2, 2011 at 11:49 PM, Guilherme Vieira
>> >> >> <jg...@gmail.com> wrote:
>> >> >> > So, I've searched column by column in the problematic line in order
>> to
>> >> >> > identify the problem. The problem is quite weird. It's a string
>> column
>> >> in
>> >> >> > the database. This column stores people names.
>> >> >> >
>> >> >> > In my problem the name is: ALEXANDRE__MARINHO DE SOUZA
>> >> >> >
>> >> >> > Of course, without the underline character. Instead it is a
>> whitespace
>> >> >> > character. So, when with double whitespace character the file is
>> >> >> corrupted.
>> >> >> > And when I manually remove the one whitespace in the IDE, the file
>> is
>> >> >> also
>> >> >> > corrupted. But when I change the whole name manually in the IDE,
>> >> setting
>> >> >> the
>> >> >> > value to ALEXANDRE_MARINHO DE SOUZA, it works. It's strange. I
>> don't
>> >> know
>> >> >> > why SXSSF is not accepting two whitespaces.
>> >> >> >
>> >> >> > Anyone have a clue?
>> >> >> >
>> >> >> >
>> >> >> >
>> >> >> > 2011/8/2 jguilhermemv <jg...@gmail.com>
>> >> >> >
>> >> >> >> I tried without merged region and it didn't work. So, I noticed
>> that
>> >> >> there
>> >> >> >> is a line in the file which present the error. It's the line
>> (2451)
>> >> and
>> >> >> >> until the line 2450 everything works great. But for some reason
>> when
>> >> it
>> >> >> >> reach the line 2450 it just doesn't work. I checked if the was any
>> >> null
>> >> >> >> values, but there wasn't. The writing routine is right, otherwise
>> it
>> >> >> >> wouldn't write until the line 2450.
>> >> >> >>
>> >> >> >> What can I do now?
>> >> >> >>
>> >> >> >> Best regards.
>> >> >> >> José Guilherme Macedo Vieira
>> >> >> >>
>> >> >> >>
>> >> >> >> 2011/8/2 Nick Burch-11 [via Apache POI] <
>> >> >> >> ml-node+4658878-753894702-237524@n5.nabble.com>
>> >> >> >>
>> >> >> >> > On Tue, 2 Aug 2011, jguilhermemv wrote:
>> >> >> >> > > Regarding the file, it makes use of some CellStyles and Merged
>> >> >> Regions.
>> >> >> >> >
>> >> >> >> > Try without them, and see if that fixes it. You need to narrow
>> your
>> >> >> >> > problem down before you can figure out what to correct. Try to
>> >> >> identify
>> >> >> >> > the simplest file that fails, and the most complex one that
>> works,
>> >> the
>> >> >> >> gap
>> >> >> >> > there is your issue
>> >> >> >> >
>> >> >> >> > Nick
>> >> >> >> >
>> >> >> >> >
>> >> ---------------------------------------------------------------------
>> >> >> >> > To unsubscribe, e-mail: [hidden email]<
>> >> >> >> http://user/SendEmail.jtp?type=node&node=4658878&i=0>
>> >> >> >> > For additional commands, e-mail: [hidden email]<
>> >> >> >> http://user/SendEmail.jtp?type=node&node=4658878&i=1>
>> >> >> >> >
>> >> >> >> >
>> >> >> >> >
>> >> >> >> > ------------------------------
>> >> >> >> > If you reply to this email, your message will be added to the
>> >> >> discussion
>> >> >> >> > below:
>> >> >> >> >
>> >> >> >> >
>> >> >> >>
>> >> >>
>> >>
>> http://apache-poi.1045710.n5.nabble.com/Apache-POI-3-8-SXSSFWorkbook-Unreadable-Content-tp4658852p4658878.html
>> >> >> >> > To unsubscribe from Apache POI 3.8 (SXSSFWorkbook) - Unreadable
>> >> >> Content,
>> >> >> >> click
>> >> >> >> > here<
>> >> >> >>
>> >> >>
>> >>
>> http://apache-poi.1045710.n5.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=4658852&code=amd1aWxoZXJtZW12QGdtYWlsLmNvbXw0NjU4ODUyfDg3MzU2ODc4NA==
>> >> >> >> >.
>> >> >> >> >
>> >> >> >> >
>> >> >> >>
>> >> >> >>
>> >> >> >> --
>> >> >> >> View this message in context:
>> >> >> >>
>> >> >>
>> >>
>> http://apache-poi.1045710.n5.nabble.com/Apache-POI-3-8-SXSSFWorkbook-Unreadable-Content-tp4658852p4659737.html
>> >> >> >> Sent from the POI - Dev mailing list archive at Nabble.com.
>> >> >> >>
>> >> >> >
>> >> >>
>> >> >> ---------------------------------------------------------------------
>> >> >> To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
>> >> >> For additional commands, e-mail: dev-help@poi.apache.org
>> >> >>
>> >> >>
>> >> >
>> >>
>> >> ---------------------------------------------------------------------
>> >> To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
>> >> For additional commands, e-mail: dev-help@poi.apache.org
>> >>
>> >>
>> >
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
>> For additional commands, e-mail: dev-help@poi.apache.org
>>
>>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
Re: Apache POI 3.8 (SXSSFWorkbook) - Unreadable Content
Posted by Guilherme Vieira <jg...@gmail.com>.
I can help you if you can. We can work together to fix the issues and
develop new features.
Cheers.
José Guilherme Macedo Vieira
2011/8/3 Yegor Kozlov <ye...@dinom.ru>
> So far the plan is to release it in late August.
>
> Yegor
>
> On Wed, Aug 3, 2011 at 3:01 PM, Guilherme Vieira <jg...@gmail.com>
> wrote:
> > Yegor,
> >
> > I'm glad to help you to find this issue. This is exactly the problem. By
> now
> > I'm trying to fix it in my own code by replacing these characters. Though
> > the beta4 is not out yet I'm still using it in my project because I need
> to
> > write an excel with >100.000 lines. Do you know when the beta4 is gonna
> be
> > out?
> >
> > Cheers,
> > José Guilherme Macedo Vieira
> >
> >
> >
> > 2011/8/3 Yegor Kozlov <ye...@dinom.ru>
> >
> >> The culprit is the non-break space (charcode=\u00a0). I was able to
> >> reproduce the trouble with the following code:
> >>
> >> Workbook wb = new SXSSFWorkbook();
> >> Sheet sh = wb.createSheet();
> >> Row row = sh.createRow(0);
> >> row.createCell(0).setCellValue("ALEXANDRE\u00a0MARINHO DE
> SOUZA");
> >> FileOutputStream out = new FileOutputStream("/temp/test.xlsx");
> >> wb.write(out);
> >> out.close();
> >>
> >> The fix is coming soon and will be included in 3.8-beta4.
> >>
> >> Cheers,
> >> Yegor
> >>
> >> On Wed, Aug 3, 2011 at 1:59 PM, Guilherme Vieira <
> jguilhermemv@gmail.com>
> >> wrote:
> >> > Dear Yegor,
> >> >
> >> > Your tip didn't work. So I guessed that there was a non-printable
> >> character
> >> > instead of white spaces. That said I tried to encode it with
> >> > URLEncoder.encode("the name goes here","ASCII"); and guess what? The
> >> encoded
> >> > name is as below:
> >> >
> >> > ALEXANDRE%3BF+MARINHO+DE+SOUZA
> >> >
> >> > It interesting because I can't remove it with replace all because we
> have
> >> > non-printable characters. So, I'm trying to find a regular expression
> >> that
> >> > matches to these expressions (%3BF and + ,respectively). It would be
> nice
> >> if
> >> > I could find a regular expression that matches to any special
> >> non-printable
> >> > characters. So, how do I proceed?
> >> >
> >> > And thanks in advance for your answer as well for your GREAT work in
> >> Apache
> >> > POI with the Big Grid Demo approach. It is just wonderful. Can't wait
> for
> >> > the final release (3.8-beta4).
> >> >
> >> > Best regards,
> >> > José Guilherme Macedo Vieira
> >> >
> >> >
> >> > 2011/8/3 Yegor Kozlov <ye...@dinom.ru>
> >> >
> >> >> Tweak your report generator and try the following tricks before
> >> >> passing strings to SXSSFCell:
> >> >>
> >> >> (a) string.replaceAll("\\s+", ""); // replace multiple white spaces
> >> >> with a single space
> >> >> (b) string.replace(' ', '_'); // replace white spaces with
> underscore
> >> >>
> >> >> Does any of (a) and (b) help?
> >> >>
> >> >> My hunch is that the problem is in something else, not in double
> white
> >> >> spaces. At least, I can't reproduce the problem with the following
> >> >> code snippet:
> >> >>
> >> >> Workbook wb = new SXSSFWorkbook();
> >> >> Sheet sh = wb.createSheet();
> >> >> for(int i = 0; i < 10000; i++) {
> >> >> Row row = sh.createRow(i);
> >> >> row.createCell(0).setCellValue("ALEXANDRE__MARINHO DE
> >> SOUZA");
> >> >> row.createCell(1).setCellValue("ALEXANDRE MARINHO DE
> SOUZA");
> >> >> row.createCell(2).setCellValue("ALEXANDRE MARINHO DE
> >> SOUZA");
> >> >> row.createCell(3).setCellValue("ALEXANDRE MARINHO DE
> >> SOUZA");
> >> >> }
> >> >>
> >> >> FileOutputStream out = new
> FileOutputStream("/temp/test.xlsx");
> >> >> wb.write(out);
> >> >> out.close();
> >> >>
> >> >> The generated file is readable and all spaces are there.
> >> >>
> >> >> Yegor
> >> >>
> >> >> On Tue, Aug 2, 2011 at 11:49 PM, Guilherme Vieira
> >> >> <jg...@gmail.com> wrote:
> >> >> > So, I've searched column by column in the problematic line in order
> to
> >> >> > identify the problem. The problem is quite weird. It's a string
> column
> >> in
> >> >> > the database. This column stores people names.
> >> >> >
> >> >> > In my problem the name is: ALEXANDRE__MARINHO DE SOUZA
> >> >> >
> >> >> > Of course, without the underline character. Instead it is a
> whitespace
> >> >> > character. So, when with double whitespace character the file is
> >> >> corrupted.
> >> >> > And when I manually remove the one whitespace in the IDE, the file
> is
> >> >> also
> >> >> > corrupted. But when I change the whole name manually in the IDE,
> >> setting
> >> >> the
> >> >> > value to ALEXANDRE_MARINHO DE SOUZA, it works. It's strange. I
> don't
> >> know
> >> >> > why SXSSF is not accepting two whitespaces.
> >> >> >
> >> >> > Anyone have a clue?
> >> >> >
> >> >> >
> >> >> >
> >> >> > 2011/8/2 jguilhermemv <jg...@gmail.com>
> >> >> >
> >> >> >> I tried without merged region and it didn't work. So, I noticed
> that
> >> >> there
> >> >> >> is a line in the file which present the error. It's the line
> (2451)
> >> and
> >> >> >> until the line 2450 everything works great. But for some reason
> when
> >> it
> >> >> >> reach the line 2450 it just doesn't work. I checked if the was any
> >> null
> >> >> >> values, but there wasn't. The writing routine is right, otherwise
> it
> >> >> >> wouldn't write until the line 2450.
> >> >> >>
> >> >> >> What can I do now?
> >> >> >>
> >> >> >> Best regards.
> >> >> >> José Guilherme Macedo Vieira
> >> >> >>
> >> >> >>
> >> >> >> 2011/8/2 Nick Burch-11 [via Apache POI] <
> >> >> >> ml-node+4658878-753894702-237524@n5.nabble.com>
> >> >> >>
> >> >> >> > On Tue, 2 Aug 2011, jguilhermemv wrote:
> >> >> >> > > Regarding the file, it makes use of some CellStyles and Merged
> >> >> Regions.
> >> >> >> >
> >> >> >> > Try without them, and see if that fixes it. You need to narrow
> your
> >> >> >> > problem down before you can figure out what to correct. Try to
> >> >> identify
> >> >> >> > the simplest file that fails, and the most complex one that
> works,
> >> the
> >> >> >> gap
> >> >> >> > there is your issue
> >> >> >> >
> >> >> >> > Nick
> >> >> >> >
> >> >> >> >
> >> ---------------------------------------------------------------------
> >> >> >> > To unsubscribe, e-mail: [hidden email]<
> >> >> >> http://user/SendEmail.jtp?type=node&node=4658878&i=0>
> >> >> >> > For additional commands, e-mail: [hidden email]<
> >> >> >> http://user/SendEmail.jtp?type=node&node=4658878&i=1>
> >> >> >> >
> >> >> >> >
> >> >> >> >
> >> >> >> > ------------------------------
> >> >> >> > If you reply to this email, your message will be added to the
> >> >> discussion
> >> >> >> > below:
> >> >> >> >
> >> >> >> >
> >> >> >>
> >> >>
> >>
> http://apache-poi.1045710.n5.nabble.com/Apache-POI-3-8-SXSSFWorkbook-Unreadable-Content-tp4658852p4658878.html
> >> >> >> > To unsubscribe from Apache POI 3.8 (SXSSFWorkbook) - Unreadable
> >> >> Content,
> >> >> >> click
> >> >> >> > here<
> >> >> >>
> >> >>
> >>
> http://apache-poi.1045710.n5.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=4658852&code=amd1aWxoZXJtZW12QGdtYWlsLmNvbXw0NjU4ODUyfDg3MzU2ODc4NA==
> >> >> >> >.
> >> >> >> >
> >> >> >> >
> >> >> >>
> >> >> >>
> >> >> >> --
> >> >> >> View this message in context:
> >> >> >>
> >> >>
> >>
> http://apache-poi.1045710.n5.nabble.com/Apache-POI-3-8-SXSSFWorkbook-Unreadable-Content-tp4658852p4659737.html
> >> >> >> Sent from the POI - Dev mailing list archive at Nabble.com.
> >> >> >>
> >> >> >
> >> >>
> >> >> ---------------------------------------------------------------------
> >> >> To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
> >> >> For additional commands, e-mail: dev-help@poi.apache.org
> >> >>
> >> >>
> >> >
> >>
> >> ---------------------------------------------------------------------
> >> To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
> >> For additional commands, e-mail: dev-help@poi.apache.org
> >>
> >>
> >
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
> For additional commands, e-mail: dev-help@poi.apache.org
>
>
Re: Apache POI 3.8 (SXSSFWorkbook) - Unreadable Content
Posted by Yegor Kozlov <ye...@dinom.ru>.
So far the plan is to release it in late August.
Yegor
On Wed, Aug 3, 2011 at 3:01 PM, Guilherme Vieira <jg...@gmail.com> wrote:
> Yegor,
>
> I'm glad to help you to find this issue. This is exactly the problem. By now
> I'm trying to fix it in my own code by replacing these characters. Though
> the beta4 is not out yet I'm still using it in my project because I need to
> write an excel with >100.000 lines. Do you know when the beta4 is gonna be
> out?
>
> Cheers,
> José Guilherme Macedo Vieira
>
>
>
> 2011/8/3 Yegor Kozlov <ye...@dinom.ru>
>
>> The culprit is the non-break space (charcode=\u00a0). I was able to
>> reproduce the trouble with the following code:
>>
>> Workbook wb = new SXSSFWorkbook();
>> Sheet sh = wb.createSheet();
>> Row row = sh.createRow(0);
>> row.createCell(0).setCellValue("ALEXANDRE\u00a0MARINHO DE SOUZA");
>> FileOutputStream out = new FileOutputStream("/temp/test.xlsx");
>> wb.write(out);
>> out.close();
>>
>> The fix is coming soon and will be included in 3.8-beta4.
>>
>> Cheers,
>> Yegor
>>
>> On Wed, Aug 3, 2011 at 1:59 PM, Guilherme Vieira <jg...@gmail.com>
>> wrote:
>> > Dear Yegor,
>> >
>> > Your tip didn't work. So I guessed that there was a non-printable
>> character
>> > instead of white spaces. That said I tried to encode it with
>> > URLEncoder.encode("the name goes here","ASCII"); and guess what? The
>> encoded
>> > name is as below:
>> >
>> > ALEXANDRE%3BF+MARINHO+DE+SOUZA
>> >
>> > It interesting because I can't remove it with replace all because we have
>> > non-printable characters. So, I'm trying to find a regular expression
>> that
>> > matches to these expressions (%3BF and + ,respectively). It would be nice
>> if
>> > I could find a regular expression that matches to any special
>> non-printable
>> > characters. So, how do I proceed?
>> >
>> > And thanks in advance for your answer as well for your GREAT work in
>> Apache
>> > POI with the Big Grid Demo approach. It is just wonderful. Can't wait for
>> > the final release (3.8-beta4).
>> >
>> > Best regards,
>> > José Guilherme Macedo Vieira
>> >
>> >
>> > 2011/8/3 Yegor Kozlov <ye...@dinom.ru>
>> >
>> >> Tweak your report generator and try the following tricks before
>> >> passing strings to SXSSFCell:
>> >>
>> >> (a) string.replaceAll("\\s+", ""); // replace multiple white spaces
>> >> with a single space
>> >> (b) string.replace(' ', '_'); // replace white spaces with underscore
>> >>
>> >> Does any of (a) and (b) help?
>> >>
>> >> My hunch is that the problem is in something else, not in double white
>> >> spaces. At least, I can't reproduce the problem with the following
>> >> code snippet:
>> >>
>> >> Workbook wb = new SXSSFWorkbook();
>> >> Sheet sh = wb.createSheet();
>> >> for(int i = 0; i < 10000; i++) {
>> >> Row row = sh.createRow(i);
>> >> row.createCell(0).setCellValue("ALEXANDRE__MARINHO DE
>> SOUZA");
>> >> row.createCell(1).setCellValue("ALEXANDRE MARINHO DE SOUZA");
>> >> row.createCell(2).setCellValue("ALEXANDRE MARINHO DE
>> SOUZA");
>> >> row.createCell(3).setCellValue("ALEXANDRE MARINHO DE
>> SOUZA");
>> >> }
>> >>
>> >> FileOutputStream out = new FileOutputStream("/temp/test.xlsx");
>> >> wb.write(out);
>> >> out.close();
>> >>
>> >> The generated file is readable and all spaces are there.
>> >>
>> >> Yegor
>> >>
>> >> On Tue, Aug 2, 2011 at 11:49 PM, Guilherme Vieira
>> >> <jg...@gmail.com> wrote:
>> >> > So, I've searched column by column in the problematic line in order to
>> >> > identify the problem. The problem is quite weird. It's a string column
>> in
>> >> > the database. This column stores people names.
>> >> >
>> >> > In my problem the name is: ALEXANDRE__MARINHO DE SOUZA
>> >> >
>> >> > Of course, without the underline character. Instead it is a whitespace
>> >> > character. So, when with double whitespace character the file is
>> >> corrupted.
>> >> > And when I manually remove the one whitespace in the IDE, the file is
>> >> also
>> >> > corrupted. But when I change the whole name manually in the IDE,
>> setting
>> >> the
>> >> > value to ALEXANDRE_MARINHO DE SOUZA, it works. It's strange. I don't
>> know
>> >> > why SXSSF is not accepting two whitespaces.
>> >> >
>> >> > Anyone have a clue?
>> >> >
>> >> >
>> >> >
>> >> > 2011/8/2 jguilhermemv <jg...@gmail.com>
>> >> >
>> >> >> I tried without merged region and it didn't work. So, I noticed that
>> >> there
>> >> >> is a line in the file which present the error. It's the line (2451)
>> and
>> >> >> until the line 2450 everything works great. But for some reason when
>> it
>> >> >> reach the line 2450 it just doesn't work. I checked if the was any
>> null
>> >> >> values, but there wasn't. The writing routine is right, otherwise it
>> >> >> wouldn't write until the line 2450.
>> >> >>
>> >> >> What can I do now?
>> >> >>
>> >> >> Best regards.
>> >> >> José Guilherme Macedo Vieira
>> >> >>
>> >> >>
>> >> >> 2011/8/2 Nick Burch-11 [via Apache POI] <
>> >> >> ml-node+4658878-753894702-237524@n5.nabble.com>
>> >> >>
>> >> >> > On Tue, 2 Aug 2011, jguilhermemv wrote:
>> >> >> > > Regarding the file, it makes use of some CellStyles and Merged
>> >> Regions.
>> >> >> >
>> >> >> > Try without them, and see if that fixes it. You need to narrow your
>> >> >> > problem down before you can figure out what to correct. Try to
>> >> identify
>> >> >> > the simplest file that fails, and the most complex one that works,
>> the
>> >> >> gap
>> >> >> > there is your issue
>> >> >> >
>> >> >> > Nick
>> >> >> >
>> >> >> >
>> ---------------------------------------------------------------------
>> >> >> > To unsubscribe, e-mail: [hidden email]<
>> >> >> http://user/SendEmail.jtp?type=node&node=4658878&i=0>
>> >> >> > For additional commands, e-mail: [hidden email]<
>> >> >> http://user/SendEmail.jtp?type=node&node=4658878&i=1>
>> >> >> >
>> >> >> >
>> >> >> >
>> >> >> > ------------------------------
>> >> >> > If you reply to this email, your message will be added to the
>> >> discussion
>> >> >> > below:
>> >> >> >
>> >> >> >
>> >> >>
>> >>
>> http://apache-poi.1045710.n5.nabble.com/Apache-POI-3-8-SXSSFWorkbook-Unreadable-Content-tp4658852p4658878.html
>> >> >> > To unsubscribe from Apache POI 3.8 (SXSSFWorkbook) - Unreadable
>> >> Content,
>> >> >> click
>> >> >> > here<
>> >> >>
>> >>
>> http://apache-poi.1045710.n5.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=4658852&code=amd1aWxoZXJtZW12QGdtYWlsLmNvbXw0NjU4ODUyfDg3MzU2ODc4NA==
>> >> >> >.
>> >> >> >
>> >> >> >
>> >> >>
>> >> >>
>> >> >> --
>> >> >> View this message in context:
>> >> >>
>> >>
>> http://apache-poi.1045710.n5.nabble.com/Apache-POI-3-8-SXSSFWorkbook-Unreadable-Content-tp4658852p4659737.html
>> >> >> Sent from the POI - Dev mailing list archive at Nabble.com.
>> >> >>
>> >> >
>> >>
>> >> ---------------------------------------------------------------------
>> >> To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
>> >> For additional commands, e-mail: dev-help@poi.apache.org
>> >>
>> >>
>> >
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
>> For additional commands, e-mail: dev-help@poi.apache.org
>>
>>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
Re: Apache POI 3.8 (SXSSFWorkbook) - Unreadable Content
Posted by Guilherme Vieira <jg...@gmail.com>.
Yegor,
I'm glad to help you to find this issue. This is exactly the problem. By now
I'm trying to fix it in my own code by replacing these characters. Though
the beta4 is not out yet I'm still using it in my project because I need to
write an excel with >100.000 lines. Do you know when the beta4 is gonna be
out?
Cheers,
José Guilherme Macedo Vieira
2011/8/3 Yegor Kozlov <ye...@dinom.ru>
> The culprit is the non-break space (charcode=\u00a0). I was able to
> reproduce the trouble with the following code:
>
> Workbook wb = new SXSSFWorkbook();
> Sheet sh = wb.createSheet();
> Row row = sh.createRow(0);
> row.createCell(0).setCellValue("ALEXANDRE\u00a0MARINHO DE SOUZA");
> FileOutputStream out = new FileOutputStream("/temp/test.xlsx");
> wb.write(out);
> out.close();
>
> The fix is coming soon and will be included in 3.8-beta4.
>
> Cheers,
> Yegor
>
> On Wed, Aug 3, 2011 at 1:59 PM, Guilherme Vieira <jg...@gmail.com>
> wrote:
> > Dear Yegor,
> >
> > Your tip didn't work. So I guessed that there was a non-printable
> character
> > instead of white spaces. That said I tried to encode it with
> > URLEncoder.encode("the name goes here","ASCII"); and guess what? The
> encoded
> > name is as below:
> >
> > ALEXANDRE%3BF+MARINHO+DE+SOUZA
> >
> > It interesting because I can't remove it with replace all because we have
> > non-printable characters. So, I'm trying to find a regular expression
> that
> > matches to these expressions (%3BF and + ,respectively). It would be nice
> if
> > I could find a regular expression that matches to any special
> non-printable
> > characters. So, how do I proceed?
> >
> > And thanks in advance for your answer as well for your GREAT work in
> Apache
> > POI with the Big Grid Demo approach. It is just wonderful. Can't wait for
> > the final release (3.8-beta4).
> >
> > Best regards,
> > José Guilherme Macedo Vieira
> >
> >
> > 2011/8/3 Yegor Kozlov <ye...@dinom.ru>
> >
> >> Tweak your report generator and try the following tricks before
> >> passing strings to SXSSFCell:
> >>
> >> (a) string.replaceAll("\\s+", ""); // replace multiple white spaces
> >> with a single space
> >> (b) string.replace(' ', '_'); // replace white spaces with underscore
> >>
> >> Does any of (a) and (b) help?
> >>
> >> My hunch is that the problem is in something else, not in double white
> >> spaces. At least, I can't reproduce the problem with the following
> >> code snippet:
> >>
> >> Workbook wb = new SXSSFWorkbook();
> >> Sheet sh = wb.createSheet();
> >> for(int i = 0; i < 10000; i++) {
> >> Row row = sh.createRow(i);
> >> row.createCell(0).setCellValue("ALEXANDRE__MARINHO DE
> SOUZA");
> >> row.createCell(1).setCellValue("ALEXANDRE MARINHO DE SOUZA");
> >> row.createCell(2).setCellValue("ALEXANDRE MARINHO DE
> SOUZA");
> >> row.createCell(3).setCellValue("ALEXANDRE MARINHO DE
> SOUZA");
> >> }
> >>
> >> FileOutputStream out = new FileOutputStream("/temp/test.xlsx");
> >> wb.write(out);
> >> out.close();
> >>
> >> The generated file is readable and all spaces are there.
> >>
> >> Yegor
> >>
> >> On Tue, Aug 2, 2011 at 11:49 PM, Guilherme Vieira
> >> <jg...@gmail.com> wrote:
> >> > So, I've searched column by column in the problematic line in order to
> >> > identify the problem. The problem is quite weird. It's a string column
> in
> >> > the database. This column stores people names.
> >> >
> >> > In my problem the name is: ALEXANDRE__MARINHO DE SOUZA
> >> >
> >> > Of course, without the underline character. Instead it is a whitespace
> >> > character. So, when with double whitespace character the file is
> >> corrupted.
> >> > And when I manually remove the one whitespace in the IDE, the file is
> >> also
> >> > corrupted. But when I change the whole name manually in the IDE,
> setting
> >> the
> >> > value to ALEXANDRE_MARINHO DE SOUZA, it works. It's strange. I don't
> know
> >> > why SXSSF is not accepting two whitespaces.
> >> >
> >> > Anyone have a clue?
> >> >
> >> >
> >> >
> >> > 2011/8/2 jguilhermemv <jg...@gmail.com>
> >> >
> >> >> I tried without merged region and it didn't work. So, I noticed that
> >> there
> >> >> is a line in the file which present the error. It's the line (2451)
> and
> >> >> until the line 2450 everything works great. But for some reason when
> it
> >> >> reach the line 2450 it just doesn't work. I checked if the was any
> null
> >> >> values, but there wasn't. The writing routine is right, otherwise it
> >> >> wouldn't write until the line 2450.
> >> >>
> >> >> What can I do now?
> >> >>
> >> >> Best regards.
> >> >> José Guilherme Macedo Vieira
> >> >>
> >> >>
> >> >> 2011/8/2 Nick Burch-11 [via Apache POI] <
> >> >> ml-node+4658878-753894702-237524@n5.nabble.com>
> >> >>
> >> >> > On Tue, 2 Aug 2011, jguilhermemv wrote:
> >> >> > > Regarding the file, it makes use of some CellStyles and Merged
> >> Regions.
> >> >> >
> >> >> > Try without them, and see if that fixes it. You need to narrow your
> >> >> > problem down before you can figure out what to correct. Try to
> >> identify
> >> >> > the simplest file that fails, and the most complex one that works,
> the
> >> >> gap
> >> >> > there is your issue
> >> >> >
> >> >> > Nick
> >> >> >
> >> >> >
> ---------------------------------------------------------------------
> >> >> > To unsubscribe, e-mail: [hidden email]<
> >> >> http://user/SendEmail.jtp?type=node&node=4658878&i=0>
> >> >> > For additional commands, e-mail: [hidden email]<
> >> >> http://user/SendEmail.jtp?type=node&node=4658878&i=1>
> >> >> >
> >> >> >
> >> >> >
> >> >> > ------------------------------
> >> >> > If you reply to this email, your message will be added to the
> >> discussion
> >> >> > below:
> >> >> >
> >> >> >
> >> >>
> >>
> http://apache-poi.1045710.n5.nabble.com/Apache-POI-3-8-SXSSFWorkbook-Unreadable-Content-tp4658852p4658878.html
> >> >> > To unsubscribe from Apache POI 3.8 (SXSSFWorkbook) - Unreadable
> >> Content,
> >> >> click
> >> >> > here<
> >> >>
> >>
> http://apache-poi.1045710.n5.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=4658852&code=amd1aWxoZXJtZW12QGdtYWlsLmNvbXw0NjU4ODUyfDg3MzU2ODc4NA==
> >> >> >.
> >> >> >
> >> >> >
> >> >>
> >> >>
> >> >> --
> >> >> View this message in context:
> >> >>
> >>
> http://apache-poi.1045710.n5.nabble.com/Apache-POI-3-8-SXSSFWorkbook-Unreadable-Content-tp4658852p4659737.html
> >> >> Sent from the POI - Dev mailing list archive at Nabble.com.
> >> >>
> >> >
> >>
> >> ---------------------------------------------------------------------
> >> To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
> >> For additional commands, e-mail: dev-help@poi.apache.org
> >>
> >>
> >
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
> For additional commands, e-mail: dev-help@poi.apache.org
>
>
Re: Apache POI 3.8 (SXSSFWorkbook) - Unreadable Content
Posted by Yegor Kozlov <ye...@dinom.ru>.
The culprit is the non-break space (charcode=\u00a0). I was able to
reproduce the trouble with the following code:
Workbook wb = new SXSSFWorkbook();
Sheet sh = wb.createSheet();
Row row = sh.createRow(0);
row.createCell(0).setCellValue("ALEXANDRE\u00a0MARINHO DE SOUZA");
FileOutputStream out = new FileOutputStream("/temp/test.xlsx");
wb.write(out);
out.close();
The fix is coming soon and will be included in 3.8-beta4.
Cheers,
Yegor
On Wed, Aug 3, 2011 at 1:59 PM, Guilherme Vieira <jg...@gmail.com> wrote:
> Dear Yegor,
>
> Your tip didn't work. So I guessed that there was a non-printable character
> instead of white spaces. That said I tried to encode it with
> URLEncoder.encode("the name goes here","ASCII"); and guess what? The encoded
> name is as below:
>
> ALEXANDRE%3BF+MARINHO+DE+SOUZA
>
> It interesting because I can't remove it with replace all because we have
> non-printable characters. So, I'm trying to find a regular expression that
> matches to these expressions (%3BF and + ,respectively). It would be nice if
> I could find a regular expression that matches to any special non-printable
> characters. So, how do I proceed?
>
> And thanks in advance for your answer as well for your GREAT work in Apache
> POI with the Big Grid Demo approach. It is just wonderful. Can't wait for
> the final release (3.8-beta4).
>
> Best regards,
> José Guilherme Macedo Vieira
>
>
> 2011/8/3 Yegor Kozlov <ye...@dinom.ru>
>
>> Tweak your report generator and try the following tricks before
>> passing strings to SXSSFCell:
>>
>> (a) string.replaceAll("\\s+", ""); // replace multiple white spaces
>> with a single space
>> (b) string.replace(' ', '_'); // replace white spaces with underscore
>>
>> Does any of (a) and (b) help?
>>
>> My hunch is that the problem is in something else, not in double white
>> spaces. At least, I can't reproduce the problem with the following
>> code snippet:
>>
>> Workbook wb = new SXSSFWorkbook();
>> Sheet sh = wb.createSheet();
>> for(int i = 0; i < 10000; i++) {
>> Row row = sh.createRow(i);
>> row.createCell(0).setCellValue("ALEXANDRE__MARINHO DE SOUZA");
>> row.createCell(1).setCellValue("ALEXANDRE MARINHO DE SOUZA");
>> row.createCell(2).setCellValue("ALEXANDRE MARINHO DE SOUZA");
>> row.createCell(3).setCellValue("ALEXANDRE MARINHO DE SOUZA");
>> }
>>
>> FileOutputStream out = new FileOutputStream("/temp/test.xlsx");
>> wb.write(out);
>> out.close();
>>
>> The generated file is readable and all spaces are there.
>>
>> Yegor
>>
>> On Tue, Aug 2, 2011 at 11:49 PM, Guilherme Vieira
>> <jg...@gmail.com> wrote:
>> > So, I've searched column by column in the problematic line in order to
>> > identify the problem. The problem is quite weird. It's a string column in
>> > the database. This column stores people names.
>> >
>> > In my problem the name is: ALEXANDRE__MARINHO DE SOUZA
>> >
>> > Of course, without the underline character. Instead it is a whitespace
>> > character. So, when with double whitespace character the file is
>> corrupted.
>> > And when I manually remove the one whitespace in the IDE, the file is
>> also
>> > corrupted. But when I change the whole name manually in the IDE, setting
>> the
>> > value to ALEXANDRE_MARINHO DE SOUZA, it works. It's strange. I don't know
>> > why SXSSF is not accepting two whitespaces.
>> >
>> > Anyone have a clue?
>> >
>> >
>> >
>> > 2011/8/2 jguilhermemv <jg...@gmail.com>
>> >
>> >> I tried without merged region and it didn't work. So, I noticed that
>> there
>> >> is a line in the file which present the error. It's the line (2451) and
>> >> until the line 2450 everything works great. But for some reason when it
>> >> reach the line 2450 it just doesn't work. I checked if the was any null
>> >> values, but there wasn't. The writing routine is right, otherwise it
>> >> wouldn't write until the line 2450.
>> >>
>> >> What can I do now?
>> >>
>> >> Best regards.
>> >> José Guilherme Macedo Vieira
>> >>
>> >>
>> >> 2011/8/2 Nick Burch-11 [via Apache POI] <
>> >> ml-node+4658878-753894702-237524@n5.nabble.com>
>> >>
>> >> > On Tue, 2 Aug 2011, jguilhermemv wrote:
>> >> > > Regarding the file, it makes use of some CellStyles and Merged
>> Regions.
>> >> >
>> >> > Try without them, and see if that fixes it. You need to narrow your
>> >> > problem down before you can figure out what to correct. Try to
>> identify
>> >> > the simplest file that fails, and the most complex one that works, the
>> >> gap
>> >> > there is your issue
>> >> >
>> >> > Nick
>> >> >
>> >> > ---------------------------------------------------------------------
>> >> > To unsubscribe, e-mail: [hidden email]<
>> >> http://user/SendEmail.jtp?type=node&node=4658878&i=0>
>> >> > For additional commands, e-mail: [hidden email]<
>> >> http://user/SendEmail.jtp?type=node&node=4658878&i=1>
>> >> >
>> >> >
>> >> >
>> >> > ------------------------------
>> >> > If you reply to this email, your message will be added to the
>> discussion
>> >> > below:
>> >> >
>> >> >
>> >>
>> http://apache-poi.1045710.n5.nabble.com/Apache-POI-3-8-SXSSFWorkbook-Unreadable-Content-tp4658852p4658878.html
>> >> > To unsubscribe from Apache POI 3.8 (SXSSFWorkbook) - Unreadable
>> Content,
>> >> click
>> >> > here<
>> >>
>> http://apache-poi.1045710.n5.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=4658852&code=amd1aWxoZXJtZW12QGdtYWlsLmNvbXw0NjU4ODUyfDg3MzU2ODc4NA==
>> >> >.
>> >> >
>> >> >
>> >>
>> >>
>> >> --
>> >> View this message in context:
>> >>
>> http://apache-poi.1045710.n5.nabble.com/Apache-POI-3-8-SXSSFWorkbook-Unreadable-Content-tp4658852p4659737.html
>> >> Sent from the POI - Dev mailing list archive at Nabble.com.
>> >>
>> >
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
>> For additional commands, e-mail: dev-help@poi.apache.org
>>
>>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
Re: Apache POI 3.8 (SXSSFWorkbook) - Unreadable Content
Posted by Guilherme Vieira <jg...@gmail.com>.
Dear Yegor,
Your tip didn't work. So I guessed that there was a non-printable character
instead of white spaces. That said I tried to encode it with
URLEncoder.encode("the name goes here","ASCII"); and guess what? The encoded
name is as below:
ALEXANDRE%3BF+MARINHO+DE+SOUZA
It interesting because I can't remove it with replace all because we have
non-printable characters. So, I'm trying to find a regular expression that
matches to these expressions (%3BF and + ,respectively). It would be nice if
I could find a regular expression that matches to any special non-printable
characters. So, how do I proceed?
And thanks in advance for your answer as well for your GREAT work in Apache
POI with the Big Grid Demo approach. It is just wonderful. Can't wait for
the final release (3.8-beta4).
Best regards,
José Guilherme Macedo Vieira
2011/8/3 Yegor Kozlov <ye...@dinom.ru>
> Tweak your report generator and try the following tricks before
> passing strings to SXSSFCell:
>
> (a) string.replaceAll("\\s+", ""); // replace multiple white spaces
> with a single space
> (b) string.replace(' ', '_'); // replace white spaces with underscore
>
> Does any of (a) and (b) help?
>
> My hunch is that the problem is in something else, not in double white
> spaces. At least, I can't reproduce the problem with the following
> code snippet:
>
> Workbook wb = new SXSSFWorkbook();
> Sheet sh = wb.createSheet();
> for(int i = 0; i < 10000; i++) {
> Row row = sh.createRow(i);
> row.createCell(0).setCellValue("ALEXANDRE__MARINHO DE SOUZA");
> row.createCell(1).setCellValue("ALEXANDRE MARINHO DE SOUZA");
> row.createCell(2).setCellValue("ALEXANDRE MARINHO DE SOUZA");
> row.createCell(3).setCellValue("ALEXANDRE MARINHO DE SOUZA");
> }
>
> FileOutputStream out = new FileOutputStream("/temp/test.xlsx");
> wb.write(out);
> out.close();
>
> The generated file is readable and all spaces are there.
>
> Yegor
>
> On Tue, Aug 2, 2011 at 11:49 PM, Guilherme Vieira
> <jg...@gmail.com> wrote:
> > So, I've searched column by column in the problematic line in order to
> > identify the problem. The problem is quite weird. It's a string column in
> > the database. This column stores people names.
> >
> > In my problem the name is: ALEXANDRE__MARINHO DE SOUZA
> >
> > Of course, without the underline character. Instead it is a whitespace
> > character. So, when with double whitespace character the file is
> corrupted.
> > And when I manually remove the one whitespace in the IDE, the file is
> also
> > corrupted. But when I change the whole name manually in the IDE, setting
> the
> > value to ALEXANDRE_MARINHO DE SOUZA, it works. It's strange. I don't know
> > why SXSSF is not accepting two whitespaces.
> >
> > Anyone have a clue?
> >
> >
> >
> > 2011/8/2 jguilhermemv <jg...@gmail.com>
> >
> >> I tried without merged region and it didn't work. So, I noticed that
> there
> >> is a line in the file which present the error. It's the line (2451) and
> >> until the line 2450 everything works great. But for some reason when it
> >> reach the line 2450 it just doesn't work. I checked if the was any null
> >> values, but there wasn't. The writing routine is right, otherwise it
> >> wouldn't write until the line 2450.
> >>
> >> What can I do now?
> >>
> >> Best regards.
> >> José Guilherme Macedo Vieira
> >>
> >>
> >> 2011/8/2 Nick Burch-11 [via Apache POI] <
> >> ml-node+4658878-753894702-237524@n5.nabble.com>
> >>
> >> > On Tue, 2 Aug 2011, jguilhermemv wrote:
> >> > > Regarding the file, it makes use of some CellStyles and Merged
> Regions.
> >> >
> >> > Try without them, and see if that fixes it. You need to narrow your
> >> > problem down before you can figure out what to correct. Try to
> identify
> >> > the simplest file that fails, and the most complex one that works, the
> >> gap
> >> > there is your issue
> >> >
> >> > Nick
> >> >
> >> > ---------------------------------------------------------------------
> >> > To unsubscribe, e-mail: [hidden email]<
> >> http://user/SendEmail.jtp?type=node&node=4658878&i=0>
> >> > For additional commands, e-mail: [hidden email]<
> >> http://user/SendEmail.jtp?type=node&node=4658878&i=1>
> >> >
> >> >
> >> >
> >> > ------------------------------
> >> > If you reply to this email, your message will be added to the
> discussion
> >> > below:
> >> >
> >> >
> >>
> http://apache-poi.1045710.n5.nabble.com/Apache-POI-3-8-SXSSFWorkbook-Unreadable-Content-tp4658852p4658878.html
> >> > To unsubscribe from Apache POI 3.8 (SXSSFWorkbook) - Unreadable
> Content,
> >> click
> >> > here<
> >>
> http://apache-poi.1045710.n5.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=4658852&code=amd1aWxoZXJtZW12QGdtYWlsLmNvbXw0NjU4ODUyfDg3MzU2ODc4NA==
> >> >.
> >> >
> >> >
> >>
> >>
> >> --
> >> View this message in context:
> >>
> http://apache-poi.1045710.n5.nabble.com/Apache-POI-3-8-SXSSFWorkbook-Unreadable-Content-tp4658852p4659737.html
> >> Sent from the POI - Dev mailing list archive at Nabble.com.
> >>
> >
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
> For additional commands, e-mail: dev-help@poi.apache.org
>
>
Re: Apache POI 3.8 (SXSSFWorkbook) - Unreadable Content
Posted by Yegor Kozlov <ye...@dinom.ru>.
Tweak your report generator and try the following tricks before
passing strings to SXSSFCell:
(a) string.replaceAll("\\s+", ""); // replace multiple white spaces
with a single space
(b) string.replace(' ', '_'); // replace white spaces with underscore
Does any of (a) and (b) help?
My hunch is that the problem is in something else, not in double white
spaces. At least, I can't reproduce the problem with the following
code snippet:
Workbook wb = new SXSSFWorkbook();
Sheet sh = wb.createSheet();
for(int i = 0; i < 10000; i++) {
Row row = sh.createRow(i);
row.createCell(0).setCellValue("ALEXANDRE__MARINHO DE SOUZA");
row.createCell(1).setCellValue("ALEXANDRE MARINHO DE SOUZA");
row.createCell(2).setCellValue("ALEXANDRE MARINHO DE SOUZA");
row.createCell(3).setCellValue("ALEXANDRE MARINHO DE SOUZA");
}
FileOutputStream out = new FileOutputStream("/temp/test.xlsx");
wb.write(out);
out.close();
The generated file is readable and all spaces are there.
Yegor
On Tue, Aug 2, 2011 at 11:49 PM, Guilherme Vieira
<jg...@gmail.com> wrote:
> So, I've searched column by column in the problematic line in order to
> identify the problem. The problem is quite weird. It's a string column in
> the database. This column stores people names.
>
> In my problem the name is: ALEXANDRE__MARINHO DE SOUZA
>
> Of course, without the underline character. Instead it is a whitespace
> character. So, when with double whitespace character the file is corrupted.
> And when I manually remove the one whitespace in the IDE, the file is also
> corrupted. But when I change the whole name manually in the IDE, setting the
> value to ALEXANDRE_MARINHO DE SOUZA, it works. It's strange. I don't know
> why SXSSF is not accepting two whitespaces.
>
> Anyone have a clue?
>
>
>
> 2011/8/2 jguilhermemv <jg...@gmail.com>
>
>> I tried without merged region and it didn't work. So, I noticed that there
>> is a line in the file which present the error. It's the line (2451) and
>> until the line 2450 everything works great. But for some reason when it
>> reach the line 2450 it just doesn't work. I checked if the was any null
>> values, but there wasn't. The writing routine is right, otherwise it
>> wouldn't write until the line 2450.
>>
>> What can I do now?
>>
>> Best regards.
>> José Guilherme Macedo Vieira
>>
>>
>> 2011/8/2 Nick Burch-11 [via Apache POI] <
>> ml-node+4658878-753894702-237524@n5.nabble.com>
>>
>> > On Tue, 2 Aug 2011, jguilhermemv wrote:
>> > > Regarding the file, it makes use of some CellStyles and Merged Regions.
>> >
>> > Try without them, and see if that fixes it. You need to narrow your
>> > problem down before you can figure out what to correct. Try to identify
>> > the simplest file that fails, and the most complex one that works, the
>> gap
>> > there is your issue
>> >
>> > Nick
>> >
>> > ---------------------------------------------------------------------
>> > To unsubscribe, e-mail: [hidden email]<
>> http://user/SendEmail.jtp?type=node&node=4658878&i=0>
>> > For additional commands, e-mail: [hidden email]<
>> http://user/SendEmail.jtp?type=node&node=4658878&i=1>
>> >
>> >
>> >
>> > ------------------------------
>> > If you reply to this email, your message will be added to the discussion
>> > below:
>> >
>> >
>> http://apache-poi.1045710.n5.nabble.com/Apache-POI-3-8-SXSSFWorkbook-Unreadable-Content-tp4658852p4658878.html
>> > To unsubscribe from Apache POI 3.8 (SXSSFWorkbook) - Unreadable Content,
>> click
>> > here<
>> http://apache-poi.1045710.n5.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=4658852&code=amd1aWxoZXJtZW12QGdtYWlsLmNvbXw0NjU4ODUyfDg3MzU2ODc4NA==
>> >.
>> >
>> >
>>
>>
>> --
>> View this message in context:
>> http://apache-poi.1045710.n5.nabble.com/Apache-POI-3-8-SXSSFWorkbook-Unreadable-Content-tp4658852p4659737.html
>> Sent from the POI - Dev mailing list archive at Nabble.com.
>>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
Re: Apache POI 3.8 (SXSSFWorkbook) - Unreadable Content
Posted by Guilherme Vieira <jg...@gmail.com>.
So, I've searched column by column in the problematic line in order to
identify the problem. The problem is quite weird. It's a string column in
the database. This column stores people names.
In my problem the name is: ALEXANDRE__MARINHO DE SOUZA
Of course, without the underline character. Instead it is a whitespace
character. So, when with double whitespace character the file is corrupted.
And when I manually remove the one whitespace in the IDE, the file is also
corrupted. But when I change the whole name manually in the IDE, setting the
value to ALEXANDRE_MARINHO DE SOUZA, it works. It's strange. I don't know
why SXSSF is not accepting two whitespaces.
Anyone have a clue?
2011/8/2 jguilhermemv <jg...@gmail.com>
> I tried without merged region and it didn't work. So, I noticed that there
> is a line in the file which present the error. It's the line (2451) and
> until the line 2450 everything works great. But for some reason when it
> reach the line 2450 it just doesn't work. I checked if the was any null
> values, but there wasn't. The writing routine is right, otherwise it
> wouldn't write until the line 2450.
>
> What can I do now?
>
> Best regards.
> José Guilherme Macedo Vieira
>
>
> 2011/8/2 Nick Burch-11 [via Apache POI] <
> ml-node+4658878-753894702-237524@n5.nabble.com>
>
> > On Tue, 2 Aug 2011, jguilhermemv wrote:
> > > Regarding the file, it makes use of some CellStyles and Merged Regions.
> >
> > Try without them, and see if that fixes it. You need to narrow your
> > problem down before you can figure out what to correct. Try to identify
> > the simplest file that fails, and the most complex one that works, the
> gap
> > there is your issue
> >
> > Nick
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: [hidden email]<
> http://user/SendEmail.jtp?type=node&node=4658878&i=0>
> > For additional commands, e-mail: [hidden email]<
> http://user/SendEmail.jtp?type=node&node=4658878&i=1>
> >
> >
> >
> > ------------------------------
> > If you reply to this email, your message will be added to the discussion
> > below:
> >
> >
> http://apache-poi.1045710.n5.nabble.com/Apache-POI-3-8-SXSSFWorkbook-Unreadable-Content-tp4658852p4658878.html
> > To unsubscribe from Apache POI 3.8 (SXSSFWorkbook) - Unreadable Content,
> click
> > here<
> http://apache-poi.1045710.n5.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=4658852&code=amd1aWxoZXJtZW12QGdtYWlsLmNvbXw0NjU4ODUyfDg3MzU2ODc4NA==
> >.
> >
> >
>
>
> --
> View this message in context:
> http://apache-poi.1045710.n5.nabble.com/Apache-POI-3-8-SXSSFWorkbook-Unreadable-Content-tp4658852p4659737.html
> Sent from the POI - Dev mailing list archive at Nabble.com.
>
Re: Apache POI 3.8 (SXSSFWorkbook) - Unreadable Content
Posted by jguilhermemv <jg...@gmail.com>.
I tried without merged region and it didn't work. So, I noticed that there
is a line in the file which present the error. It's the line (2451) and
until the line 2450 everything works great. But for some reason when it
reach the line 2450 it just doesn't work. I checked if the was any null
values, but there wasn't. The writing routine is right, otherwise it
wouldn't write until the line 2450.
What can I do now?
Best regards.
José Guilherme Macedo Vieira
2011/8/2 Nick Burch-11 [via Apache POI] <
ml-node+4658878-753894702-237524@n5.nabble.com>
> On Tue, 2 Aug 2011, jguilhermemv wrote:
> > Regarding the file, it makes use of some CellStyles and Merged Regions.
>
> Try without them, and see if that fixes it. You need to narrow your
> problem down before you can figure out what to correct. Try to identify
> the simplest file that fails, and the most complex one that works, the gap
> there is your issue
>
> Nick
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [hidden email]<http://user/SendEmail.jtp?type=node&node=4658878&i=0>
> For additional commands, e-mail: [hidden email]<http://user/SendEmail.jtp?type=node&node=4658878&i=1>
>
>
>
> ------------------------------
> If you reply to this email, your message will be added to the discussion
> below:
>
> http://apache-poi.1045710.n5.nabble.com/Apache-POI-3-8-SXSSFWorkbook-Unreadable-Content-tp4658852p4658878.html
> To unsubscribe from Apache POI 3.8 (SXSSFWorkbook) - Unreadable Content, click
> here<http://apache-poi.1045710.n5.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=4658852&code=amd1aWxoZXJtZW12QGdtYWlsLmNvbXw0NjU4ODUyfDg3MzU2ODc4NA==>.
>
>
--
View this message in context: http://apache-poi.1045710.n5.nabble.com/Apache-POI-3-8-SXSSFWorkbook-Unreadable-Content-tp4658852p4659737.html
Sent from the POI - Dev mailing list archive at Nabble.com.
Fwd: FW: Conselho de Advogado - Importante ler (LG)
Posted by jguilhermemv <jg...@gmail.com>.
Atenciosamente,
José Guilherme Macedo Vieira
Desenvolvedor Java EE
-----------------------------------
Telefone: 081-87127316
Skype: williaminbrazil
GTalk: jguilhermemv@gmail.com
---------- Mensagem encaminhada ----------
De: Augusto Galvao Barbosa <aa...@hotmail.com>
Data: 7 de setembro de 2011 18:04
Assunto: FW: Conselho de Advogado - Importante ler (LG)
Para: adriana <ad...@hotmail.com>, Aelson luis <
aelsonluis@hotmail.com>, agalvao@bol.com.br, Anderson SB <wa...@hotmail.com>,
Andreia Moreira <de...@hotmail.com>, araujo <de...@hotmail.com>,
arimagalvao@hotmail.com, arimargalvao@hotmail.com, Augusto Galvao Barbosa <
aagbarbosa4@hotmail.com>, augusto_medeiross@hotmail.com,
bobothy.m@hotmail.com, charlene_sheila@hotmail.com, Cleiton Cavalcanti <
cleitoncavalcanti_69@hotmail.com>, compras jc <co...@jc.com.br>,
cpljosiani@hotmail.com, dandacomercio@yahoo.com.br, daniel funase <
daniel_valenca@hotmail.com>, DIEGO VICENTE RIBEIRO RIBEIRO <
diegoevo25@hotmail.com>, ebp.solucoesemti@hotmail.com, edsonss@ig.com.br,
Eduardo Silva <fl...@yahoo.com.br>, Eduardo Silva <
flavialuiza3000@yahoo.com>, Eduardo Silva <ed...@hotmail.com>, Everson
Gomes <ev...@hotmail.com>, Everton Barbosa <ev...@hotmail.com>,
fabioalbuquerque@fade.org.br, filho de gleudes <jg...@gmail.com>,
filipe mauricio <fi...@hotmail.com>, filipemauricio@hotmail.com,
franquiashavaianas@alpargatas.com.br, Geovanni Nunes <va...@hotmail.com>,
hmlcomercial@ig.com.br, "iraci@recife.pe.gov.br" <ir...@recife.pe.gov.br>,
Ismaylton Pereira <is...@hotmail.com>, Ivan Lira <
totemoabunai@hotmail.com>, Jocy Melo <jo...@hotmail.com>,
jocypaulojose@hotmail.com, josinomelo@hotmail.com, Mag Mel <
mag.mel@hotmail.com>, Magaly Bezerra <ma...@hotmail.com>, mario silva <
rolinsilva@hotmail.com>, Maurycio Melo <ma...@hotmail.com>, Maysa de
Melo Bezerra <sa...@hotmail.com>, MÔNICA MELO <
monicaneoplanos1@hotmail.com>, monicamelo_estrela@hotmail.com, "
morgana@recife.pe.gov.br" <mo...@recife.pe.gov.br>, nya_galvao@hotmail.com,
omegames <do...@omegamed.com.br>, osmam silva <os...@hotmail.com>,
osmanp@hotmail.com, pc pc <pa...@hotmail.com>,
richard_cavalcanti@hotmail.com, Roberta Rijo <ro...@hotmail.com>,
roberto pires pires <ro...@hotmail.com>, Rodolfo Pagano <
pagano2666@hotmail.com>, rodrigo guedes <ro...@hotmail.com>,
rolim.silva@hotmail.com, romoaldo <al...@omegamed.com.br>, Simone Victor <
monevictor@hotmail.com>, Simone Bezerra <si...@hotmail.com>,
simonifunase <si...@gmail.com>, sizenadofilho@bol.com.br, TIO
ZEZINHO <jo...@hotmail.com>
eu fui......
------------------------------
From: dalvabarodrigues@hotmail.com
To: aagbarbosa4@hotmail.com; adilzamamc@hotmail.com;
drycalcoforado@gmail.com; adriana.pinange@hotmail.com;
alananoblat@hotmail.com; albert.to@yahoo.com.br; alves_juliana1@hotmail.com;
andersonluiz.bento@yahoo.com.br; anageny_ciet@yahoo.com.br;
anatereza_v@hotmail.com; andersonluiz.bento@yahoo.com;
andreaxaves@yahoo.com.br; andrealuizas@ig.com.br;
andreia_silvara@hotmail.com; deiasilvara@hotmail.com; bettchica@hotmail.com;
elizabeth.etr@bol.com.br; bruna_priscila@hotmail.com;
eduardo_abreu.flp@hotmail.com; carmenjmaciel@ig.com.br;
cato_chico@yahoo.com.br; christianomec@hotmail.com;
clarasilvestre@uol.com.br; claudiabf2003@hotmail.com;
clayton_ufpe@yahoo.com.br
Subject: Conselho de Advogado - Importante ler (LG)
Date: Tue, 6 Sep 2011 22:37:10 +0000
*Conselho de **Advogado** - Importante ler*****
****
*Seguem, abaixo, importantes instruçoes que nunca (mas nunca mesmo!) temos
a precaução de realizar para evitar problemas futuros. *****
*Antes tarde do que nunca!*****
* *****
****
****
****
****
*CONSELHO DE ADVOGADO - IMPORTANTE LER*****
****
.****
É MAIS QUE IMPORTANTE, LER, COPIAR E DECORAR!!!!!!!!!!!!! ****
.****
3 bons motivos para repassar: ****
1 - Até que enfim um bom conselho de advogado;****
2 - DE GRAÇA! (Essa é para espantar ainda +)****
3 - O conteúdo é relevante.****
****
****
****
*LER!* ****
*CONSELHO DE ADVOGADO*
Um advogado fez circular a seguinte informação para os empregados de seu
escritório: ****
*1.* *Não assine a parte de trás de seus cartões de crédito*. Em vez disso,
escreva *'SOLICITAR RG'*. ****
*2**.* Ponha seu número de telefone de trabalho em seus cheques em vez de
seu telefone de casa. ****
****
****
Se você tiver uma Caixa Postal de Correio use esta em vez de seu endereço
residencial.****
Se você não tiver uma Caixa Postal, use seu endereço de trabalho. ****
****
Ponha seu telefone celular ao invés do residencial.*
3.* Tire Xerox do conteúdo de sua carteira. Tire cópia *de ambos os lados *de
todos os documentos, cartão de crédito, etc... ****
Você saberá o que você tinha em sua carteira e todos os números de conta e
números de telefone para chamar e cancelar. ****
Mantenha a fotocópia em um lugar seguro. ****
Também leve uma fotocópia de seu passaporte quando for viajar para o
estrangeiro. ****
Sabe-se de muitas estórias de horror de fraudes com nomes, CPF, RG, cartão
de créditos, etc... roubados. ****
Infelizmente, eu, um advogado, tenho conhecimento de primeira mão porque
minha carteira foi roubada no último mês. ****
Dentro de uma semana, os ladrões compraram um caro pacote de telefone
celular, contrataram um cartão de crédito VISA, tiveram uma linha de crédito
aprovada para comprar um computador, dirigiram com minha carteira...*
E MAIS...* ****
*
4.* Nós fomos informados que nós deveríamos cancelar nossos cartões de crédito
imediatamente. ****
Mas a chave é ter os números de telefone gratuitos e os números de cartões à
mão, assim você sabe quem chamar.
Mantenha estes onde você os possa achar com facilidade. *
5.* Abra um Boletim Policial de Ocorrência (B.O.) imediatamente na
jurisdição onde seus cartões de crédito, etc... foram roubados. Isto prova
aos credores que você tomou ações imediatas, e este é um primeiro passo para
uma investigação (se houver uma).*
Mas aqui está o que é talvez mais importante que tudo:**
6.* Chame imediatamente o *SPC*(11-3244-3030) e *SERASA *(11-33737272) e
outros órgãos de crédito (se houver) para pedir que seja colocado um alerta
de fraude em seu nome e número de CPF. ****
Eu nunca tinha ouvido falar disto até que fui avisado por um banco que me
chamou para confirmar sobre uma aplicação para empréstimo que havia sido
feita pela Internet em meu nome. ****
O alerta serve para que qualquer empresa que confira seu crédito saiba que
sua informação foi roubada, e eles têm que contatar você por telefone antes
que o crédito seja aprovado.
Até que eu fosse aconselhado a fazer isto (quase duas semanas depois do
roubo), todo o dano já havia sido feito. ****
Há registros de todos os cheques usados para compras pelos ladrões, nenhum
dos quais - eu soube - depois que eu coloquei o alerta. ****
Desde então, nenhum dano adicional foi feito, e os ladrões jogaram fora
minha carteira. ****
Este fim de semana alguém a devolveu para mim. ****
Esta ação parece ter feito eles desistirem.****
* *
Se roubarem seu Celular...****
A DICA É MUITO INTERESSANTE, ATÉ PORQUE POUCA GENTE TEM O HÁBITO DE LER
MANUAIS. Agora, com esta história do 'Chip', o interesse dos ladrões por
aparelhos celulares aumentou. É só ele comprar um novo chip por um preço
médio de R$30,00 em uma operadora e o instalar no aparelho roubado. Por
isso, está generalizado o roubo de aparelhos celulares.
Segue, então, uma informação útil que os comerciantes de celulares não
divulgam. Uma espécie de vingança para quando roubarem celulares.
Para obter o número de série do seu *telefone* celular (GSM), digite
*#06#Aparecerá no visor um código de algarismos.. Este código é
único!!! Anote e
guarde-o com cuidado!!!
Se roubarem seu celular, telefone para sua operadora e informe este código.
O seu telefone poderá então ser completamente bloqueado, mesmo que o ladrão
mude o 'Chip'. Provavelmente, você não recuperará o aparelho, mas quem quer
que o tenha roubado não poderá mais utilizá-lo.
Se todos tomarem esta precaução, imagine, o roubo de celulares se tornará
inútil. Envie isto a todos e não esqueça de anotar o número de série do seu
celular!!! ****
*Passamos para frente muitas piadas pela Internet . *****
*Mas se você estiver disposto a passar esta informação, *****
*realmente poderá ajudar alguém!* ****
****
** **
****
****
****
****
****
****
****
****
****
****
****
****
****
****
****
**
**
------------------------------
E-mail verificado pelo Terra Anti-Spam.
Para classificar esta mensagem como spam ou não spam, clique
aqui<http://ecp.terra.com.br/cgi-bin/reportspam.cgi?+_d=SCY0MzUxNDgwI3Blcm0hdGVycmEmMSwxMzE1MDYzNjY3LjQ4Nzg1NC40NDM5LmJldHVuZS50cG4udGVycmEuY29tLDM0NjQwTerraMail>
.
Verifique periodicamente a pasta Spam para garantir que apenas mensagens
indesejadas sejam classificadas como Spam.
------------------------------
Esta mensagem foi verificada pelo E-mail Protegido Terra.
Atualizado em 02/09/2011
------------------------------
E-mail verificado pelo Terra Anti-Spam.
Para classificar esta mensagem como spam ou não spam, clique
aqui<http://ecp.terra.com.br/cgi-bin/reportspam.cgi?+_d=SCY0MzUxNDgwI3Blcm0hdGVycmEmMSwxMzE1MDY0MjM2LjYxNDExNS4xNjYwMi5wcmV2b3N0LnRwbi50ZXJyYS5jb20sNDUxMjg=TerraMail>
.
Verifique periodicamente a pasta Spam para garantir que apenas mensagens
indesejadas sejam classificadas como Spam.
------------------------------
Esta mensagem foi verificada pelo E-mail Protegido Terra.
Atualizado em 02/09/2011
--
View this message in context: http://apache-poi.1045710.n5.nabble.com/Apache-POI-3-8-SXSSFWorkbook-Unreadable-Content-tp4658852p4780326.html
Sent from the POI - Dev mailing list archive at Nabble.com.
Re: Apache POI 3.8 (SXSSFWorkbook) - Unreadable Content
Posted by Nick Burch <ni...@alfresco.com>.
On Tue, 2 Aug 2011, jguilhermemv wrote:
> Regarding the file, it makes use of some CellStyles and Merged Regions.
Try without them, and see if that fixes it. You need to narrow your
problem down before you can figure out what to correct. Try to identify
the simplest file that fails, and the most complex one that works, the gap
there is your issue
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org