RE: [sc-dev] Question about OpenOffice.org Calc: CSV import enhancements

2007-04-23 Thread Kirill S. Palagin
Basically the problem boils down to not having text delimiter in pairs (http://www.openoffice.org/issues/show_bug.cgi?id=31441). I have the file with me and found offending line, if anyone needs the file. That other spreadsheet app handles this scenario by treating everything between unmatched del

RE: [sc-dev] Question about OpenOffice.org Calc: CSV import enhancements

2007-04-23 Thread Kirill S. Palagin
Hello. I suspect that your file is special in some way. As mailing list will filter out attachements you can either send the file to me, post your file at some file hosting server (www.mytempdir.com, for example) or file issue yourself (you need to register at http://www.openoffice.org/servlets/Jo

Re: [sc-dev] There is a new bug

2007-04-23 Thread Niklas Nebel
gaozm wrote: > Do you mean that Fontwork can be disabled in note? Yes, exactly, changing the GetFormTextState methods as mentioned. Niklas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTE

Re: [sc-dev] R + Calc Update

2007-04-23 Thread Niklas Nebel
Leonard Mada wrote: could you please explain what this code does? { ScMatValType nType = GetDoubleOrStringFromMatrix( fVal, rString); bIsString = (nType != SC_MATVAL_VALUE); } My thinking is: - it gets content of current table cell - IF content is a numerical value, fVal is set - IF content is s

Re: [sc-dev] R + Calc Update

2007-04-23 Thread Niklas Nebel
Leonard Mada wrote: PROPER CODE I imagine this implemented in the following way: - write native Calc function (C++) that: - iterates trough selected table cells - reads cell content - performs eventual 'missing values' => 'NA' substitutions - creates a string using th

Re: [sc-dev] Once again, the thing I am missing most inOpenOffice

2007-04-23 Thread Erich Neuwirth
The are described in out Wiki at http://rcom.univie.ac.at Currently, R(D)COM version 2.51 has a problem with RExcel when rcom is not installed. There are 2 solutions. * Install rcom from CRAN, and then in R execute the following commands 1. library(rcom) 2. comRegisterRegistry

[sc-dev] Question about OpenOffice.org Calc: CSV import enhancements

2007-04-23 Thread Stepan Bechynsky
Hi, I have tried to import CSV file to Calc. CSV file has 16408 lines. Calc imported just 13268 lines. I cut file to 13000 lines and Calc imported just 11011 lines. Is it known bug? I am using OOo 2.2 on Windows Vista Ultimate. I can send you CSV for testing. Regards, Stepan Bechynsky Developer