[dev] Farewell
In case anyone is still reading these lists: I have left Oracle and started a new job, not related to OpenOffice.org. Because of this, I won't have enough time for any meaningful participation in the new OpenOffice.org at Apache. So it's time for me to say goodbye. OpenOffice.org has always been great fun for me, so I'm happy to see some familiar names in the Apache project, which makes me confident they will be able to continue the success of OpenOffice.org. Thanks everybody for a great time! Niklas -- - To unsubscribe send email to dev-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[dev] Re: Implementation of Row Exchange Button in Calc
On 15.06.2011 23:19, Martin Hediger wrote: I was thinking, would it be possible to implement some kind of row-row exchange button in Calc? Of course, the same could apply to column-column exchange. It depends on the desired behavior of that button. Probably it can be a combination of insert rows, move cells and delete rows. These are all available via API, so it can be implemented as an extension. How do you want to select the rows to exchange? Anyway, would be cool if someone could point me out to some part of the code where one might start looking at this. See http://wiki.services.openoffice.org/wiki/Extensions_development for general information about extension development. Niklas -- - To unsubscribe send email to dev-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[dev] Replacing LGPL libraries: Use of lp_solve for Calc's linear solver
Hi, Dependencies on LGPL libraries may soon become a problem. One such library is lp_solve, which is the basis of the OpenOffice.org Linear Solver in Calc. It would certainly be a nice twist of irony if the evil-grasping-Sun-solver became exclusive to LibreOffice, but I'll go ahead and spoil the fun: COIN-OR (www.coin-or.org) has a lot of OR code under the less-evil EPL or CPL licenses. Among it: Clp for linear programming, Cbc for integer conditions, and CoinMP, which wraps these in a single shared object with a C interface. I created issue 118160 and attached a simple proof-of-concept patch to use CoinMP instead of lp_solve. From some limited testing, this seems to work very well. Some changes will still be needed for building and packaging, and perhaps some tweaking of solver settings. But the patch shows that replacing lp_solve is clearly a (pardon the pun) solvable problem. Niklas -- - To unsubscribe send email to dev-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[dev] Re: Replacing LGPL libraries: Use of lp_solve for Calc's linear solver
On 11.06.2011 17:43, rony wrote: On 11.06.2011 17:36, Niklas Nebel wrote: Dependencies on LGPL libraries may soon become a problem. What would be the problem here? [Just curious why it was o.k. in the past, but may be a problem soon ?] http://www.apache.org/legal/3party.html It would certainly be a nice twist of irony if the evil-grasping-Sun-solver Again, not sure what you mean with evil-grasping here? Doesn't Oracle (Sun) hold the copyright and can issue a version with any license of their choice? It was called such by someone else, which is part of the irony of it. Niklas -- - To unsubscribe send email to dev-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[dev] Re: refactoring OUString
On 07.06.2011 13:15, tora - Takamichi Akiyama wrote: As many already know, malloc() is too general and too expensive. Moreover, free() is much more expensive than malloc(). e.g. a source code of malloc() in glibc: http://sourceware.org/git/?p=glibc.git;a=blob;f=malloc/malloc.c We use our own implementation, rtl_allocateMemory (see sal/rtl/source/alloc*). But of course the point remains valid: Both allocation and deallocation take time. Even though current OpenOffice.org runs as a multi-thread process, it runs as if it is a single thread. So, we could have several options to implement its underlying memory allocation mechanism for the specific purposes of OpenOffice.org. If there was only a single thread, we could get rid of quite some locking overhead. But in fact, with clipboard, UNO acceptor thread and such stuff, we have just enough multithreading going on to cause the overhead, without the benefit of actually doing work in parallel. Of course we should try to make more use of multiple threads. This isn't a new idea either, see http://wiki.services.openoffice.org/wiki/Calc/Performance/misc. Christian did some experiments with parallel loading a while ago (http://blogs.oracle.com/GullFOSS/entry/xml_performance_and_now_for). The results for Impress weren't spectacular, but Calc or Writer may be different. 2) Slicing cheese and throwing them out at once For the internal tasks such as Save as and Export to we might get a big advantage. Such a task starts from the framework, calls thousands of methods, and finally leaves the only single value meaning a SUCCESS or FAILURE. No String instance involved during the task is needed to be persistent. Right now, that isn't entirely true. For example, saving might need to calculate a formula, and the calculated result is then kept in the cell, in a string that continues to be referenced after saving. There might be similar cases elsewhere. These would probably have to be moved into a separate step before saving. Sounds a bit fragile, but then it could actually save a significant amount of time. I think the above are just a tip of potential, brilliant ideas. Let's discuss later this kind of topic once the surrounding situation is settled. On the other hand, now might be a perfect time to discuss crazy ideas, without mundane details getting in the way. Niklas -- - To unsubscribe send email to dev-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[dev] Re: refactoring OUString
On 06.06.2011 19:43, tora - Takamichi Akiyama wrote: And also, please cover the underlying memory allocation mechanism which would be another key factor for the performance improvement. There's an old suggestion to treat small strings differently, see http://wiki.services.openoffice.org/wiki/Uno/Binary/Analysis/String_Performance. Niklas -- - To unsubscribe send email to dev-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[dev] Re: __attribute__((packed)) for enum
On 19.05.2011 16:40, tora - Takamichi Akiyama wrote: As you pointed out, the installed font might be one of the factors. Excel files are prepared on Windows while I am trying to open them on CentOS and/or Solaris. Those systems have a different font set. Another point that I have been suspecting since OpenOffice.org 2.x is artificial Ascendant. The vcl module had implemented a feature that mathematically produced an artificial Ascendant of glyph. Compared with typical Western font files which usually have certain amount of ascendant, typical Japanese font files have an ascendant of value zero from, probably, historical reasons. To make implementation of the upper layer applications such as Writer, Calc, and Impress, the underlying module, vcl, tries to internally take care of the differences. It is good, but, I feel, the artificial ascendant, thus, virtual text height, might be slightly higher than its expectation. That might lead a cause to slightly increase unnecessary amount of row height. There's been some tweaking of CJK font metrics in VCL, but I'm not really familiar with that. BTW, in contrast to the topic on artificial ascendant, what I have been currently aiming at is that how to create an preview image of Microsoft Office files running on back-end servers without any user interaction. For the purpose, which might be better? (a) One spreadsheet is converted into a single too-small image file. (b) One spreadsheet is converted into two or four image files. Reducing a font size right before calling OutputDevice::SetFont seems to work. I am trying this attempt for a while. If you want to shrink everything to make sure you don't generate too many pages, perhaps it's better to reduce the print scale (ATTR_PAGE_SCALE, or PageScale via API). That would apply to simple cells and EditEngine content equally. Niklas -- - To unsubscribe send email to dev-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[dev] Re: __attribute__((packed)) for enum
On 18.05.2011 03:40, tora - Takamichi Akiyama wrote: The size of class Impl_Font would reduce to 50 bytes or so from 88 bytes. How big benefits could we get when such structure or class instances are produced in large numbers? Generally, this is a very valid concern. In some places where we found out (or just assumed) that it makes a difference, we currently use smaller integer types directly for member variables, instead of enum. For example, see eCellType in ScBaseCell (sc/inc/cell.hxx). Or FormulaToken (formula/inc/formula/token.hxx), where the type of eOp and eType even depends on DBG_UTIL. I don't know if Font objects are constructed in very large numbers. Niklas -- - To unsubscribe send email to dev-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[dev] Re: __attribute__((packed)) for enum
Am 18.05.2011 13:44, schrieb tora - Takamichi Akiyama: The motivation of this topic comes from a different point. I have been looking for a way to prevent a well-known phenomenon A single sheet that fits in a A4 paper with Excel turns into two or four A4 papers with Calc. Tweaking nPPTX and nPPTY ? Reducing a font size just before calling OutputDevice::SetFont() from the inside of sc and editeng ? Four pages means that both width and height are wrong? They are handled quite differently. Column widths in Calc are static (stored in twips internally). The conversion from Excel's character-based units is done during import. Automatic row heights are updated based on cell formats and contents. The edit engine is used only for complex cell contents. With simple cells, we cheat a bit and avoid the OutputDevice::SetFont call, for performance reasons. The calculation is based on the height of the default font (determined from an OutputDevice once), the direct value from the font height format, and some tweaking, see lcl_GetAttribHeight in sc/source/core/data/column2.cxx. This obviously leaves lots of room to arrive at different values from Excel. In some cases even correctly so, because optimal height is supposed to fit the cell content with your current setup (system, installed fonts). Niklas -- - To unsubscribe send email to dev-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[dev] Re: Cells command no longer functions
On 18.04.2011 01:31, Andrew Douglas Pitonyak wrote: Have VBA compatibility items been removed from OOo in version 3.3? I do not have 3.2 to test, but, I do see that this does not function in 3.3. Much of the VBA implementation really only works if the document is in VBA mode. This is a similar problem to issue 117392 (but not fixed with the same change). Niklas -- - To unsubscribe send email to dev-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[dev] Re: build.pl debug=1 for sw and svx
On 06.04.2011 08:54, tora - Takamichi Akiyama wrote: Could you tell me how to easily do build.pl debug=1 or similar actions in a specific, renovated module such as sw and svx after fully building the entire source code tree with normal options? The way I used to do was like this: (full build) cd $SRC_ROOT dmake (individual build with a debug option) cd sw mv $INPATH ${INPATH}-normal build.pl debug=1 An attempt like that seems no longer applicable with the recent DEV300_m10x. It seems files being created are now stored in solver/, instead. It is cool and makes me excited. :-) To rebuild a single module with debug info in the new build system, use cd sw make -sr clean make -sr debug=t See also http://blogs.sun.com/GullFOSS/entry/gbuild_meet_the_new_boss. Niklas -- - To unsubscribe send email to dev-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[dev] Re: build.pl debug=1 for sw and svx
On 06.04.2011 18:45, tora - Takamichi Akiyama wrote: make -r deliverlog running on OpenSolaris x86 prints same type of warning messages and then eventually create the log file. $ make -r deliverlog ... make: *** Warning: .LOW_RESOLUTION_TIME file `/x/solver/300/unxsoli4/inc/svx/sxsoitm.hxx' has a high resolution time stamp ...(repeated 2 by 500 times for each file)... On OpenSolaris x86, even after executing make -sr make -r deliverlog, the delivered file under $OUTDIR is slightly older (in nanoseconds) than its original one. Consequently, copy action might occur again and again. Should I use /usr/gnu/bin/cp instead of /bin/cp, or else??? Is it really copied again? The whole point of .LOW_RESOLUTION_TIME is to ignore these small differences (see http://www.gnu.org/software/make/manual/html_node/Special-Targets.html and http://wiki.services.openoffice.org/wiki/Build_Environment_Effort/Status_And_Next_Steps). Niklas -- - To unsubscribe send email to dev-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[dev] Re: Importing Filter fixes from Symphony
On 30.11.2010 16:44, MOULIN Camille wrote: During random tests with IBM's Symphony, I realized that three of the most annoying bugs in Calc's filters were actually fixed there. Issue 89232 Fill operations should not touch filtered rows. Issue 12666 autofilter works just on one sheet (only one auto-range per file) Issue 85305 Dynamically grow a filtered range for autofilter I know that Symphony is not an open source project, but do you think it would be possible to have those fixes upstreamed to OOo ? A little update on this: We have received a patch for issues 85305 and 89232. It's in CWS calc66 now. Niklas -- - To unsubscribe send email to dev-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[dev] Re: OOo Pivoting Code Extraction
On 28.02.2011 23:23, Nuno Oliveira wrote: As I'm taking this project again, I bumped into some questions that you may answer me immediately, I'm sure! Well I'm trying to discover which and where is the function that performs the pivoting calculation. By the hints you gave me before I'm searching for this function on dptabres.cxx, and there I found a Calculate function, but it makes me believe that it is not the function I'm searching for... Also I am searching for the input for this calculation, and that function takes some arguments that I can't assume as a structure holding all the data to perform such computation. Can you give me some more hints about the form that the input takes for the calculation? And which is the main function where the pivoting calculation starts? It's all distributed across several classes. ScDPSource::CreateRes_Impl creates ScDPResultMember objects pColResRoot and pRowResRoot which (in their children) contain the results. The CalcResults call then creates a cache of the source data and iterates through the rows (in ScDPTableData::CalcResultsFromCacheTable and ProcessRowData). For each source data row, ScDPResultMember::ProcessData is called which updates the results. In the results, ScDPResultMember has the information about a whole column or row. pChildDimension (ScDPResultDimension) is an array of ScDPResultMember objects for the next nested field. pDataRoot (ScDPDataMember) holds the column/row result, and in the case of pRowRoot it also has a similar structure of child member arrays (pChildDimension) for the results within that row. The data for an individual result value is updated with each source entry in ScDPAggData::Update, and the result is calculated from that in ScDPAggData::Calculate. Does that help a bit? Niklas -- To unsubscribe, e-mail: dev-unsubscr...@openoffice.org For additional commands, e-mail: sy...@openoffice.org with Subject: help
Re: [dev] OOo Pivoting Code Extraction
On 16.02.2011 13:52, Nuno Oliveira wrote: My name is Nuno Oliveira, and me and my colleagues, we are enrolled in a project at University of Minho (Portugal), which consists in finding all the code related to the pivot tables (data pilot) operations in the calc tool. Then we want to extract and isolate that code to put it into a stand-alone 'tool' so we are able to test the performance of that code in several environmental contexts. That sounds very interesting. The questions I make are the following: -- do you ever searched for that code or made similar searches? -- do you have any method to easily find that or other code (including tools for slicing or program comprehension in general)? -- can you give me some pointers, based on your experience, about where to search for documentation on the pivot code class? The implementation is mostly in sc/source/core/data, in the files that start with dp. A few starting points: - The classes in dptabsrc.cxx are the implementation of the DataPilotSource UNO service for table data. The actual calculation of the results is in dptabres.cxx. - ScSheetDPData (dpshttab.cxx) feeds sheet data into the calculation, ScDatabaseDPData (dpsdbtab.cxx) uses a database connection. - ScDPObject (dpobject.cxx) is the object that's stored in a spreadsheet document. It uses ScDPOutput (dpoutput.cxx) to take the results from the DataPilotSource service and output them into spreadsheet cells. Niklas - To unsubscribe, e-mail: dev-unsubscr...@openoffice.org For additional commands, e-mail: dev-h...@openoffice.org
Re: [dev] OOo Pivoting Code Extraction
On 16.02.2011 15:57, Nuno Oliveira wrote: I have some other question: I'm using version 3.3.0 of OOo and there is also these two classes with name pivot.cxx and pivot2.cxx. Is that anyhow related with the pivoting code and those classes you mentioned? (these classes are inside binfilter package to be more precise) The whole binfilter module is only used for loading and saving old file formats. You can completely ignore that. In the sc module outside of binfilter, the only thing that's left in pivot2.cxx is the code to copy some struct members. Niklas - To unsubscribe, e-mail: dev-unsubscr...@openoffice.org For additional commands, e-mail: dev-h...@openoffice.org
Re: [dev] RDF metadata issue
On 09.02.2011 15:50, underscore wrote: The problem is that the metadata looks like this : rdf:RDF xmlns:rdf=http://www.w3.org/1999/02/22-rdf-syntax-ns#; rdf:Description rdf:about=../content.xml#id322214793 ns1:sectionType xmlns:ns1=http://editor.bungeni.org/anx/;Clause/ns1:sectionType ns2:sectionUUID xmlns:ns2=http://editor.bungeni.org/anx/;1723-18388-38383-38383/ns2:sectionUUID /rdf:Description /rdf:RDF Notice how the ns1 and ns2 namespace prefixes are duplicated But i want it to look like this -- rdf:RDF xmlns:rdf=http://www.w3.org/1999/02/22-rdf-syntax-ns#; rdf:Description rdf:about=../content.xml#id322214793 xmlns:anx=http://editor.bungeni.org/anx; anx:sectionTypeClause/anx:sectionType anx:sectionUUID1723-18388-38383-38383/anx:sectionUUID /rdf:Description /rdf:RDF Why do you want it to look like that? The first example should look the same to any well-behaved tool. Niklas - To unsubscribe, e-mail: dev-unsubscr...@openoffice.org For additional commands, e-mail: dev-h...@openoffice.org
Re: [dev] AboutGRAPH.EXE
On 12/14/10 04:39, 许山川 wrote: I am sorry to reply late,you say activating an OLE object ,can you explain it in detail? thanks! the problem now is that when GRAPH.EXE appears,the speed of ppt_loading will slows down. To load and display a file with an OLE object, the OLE server application usually isn't needed because the replacement image is used. You should check if any of your changes cause the object to be activated or modified. Niklas - To unsubscribe, e-mail: dev-unsubscr...@openoffice.org For additional commands, e-mail: dev-h...@openoffice.org
Re: [dev] AboutGRAPH.EXE
On 12/10/10 04:32, 许山川 wrote: When I load the ppt document, because it is loaded by multi-threaded, the process list will produce GRAPH.EXE, who can tell me why? and how can I avoid it? Sounds like you're somehow activating an OLE object (chart) in the file. Niklas - To unsubscribe, e-mail: dev-unsubscr...@openoffice.org For additional commands, e-mail: dev-h...@openoffice.org
Re: [dev] Performance: Loading a large plain data file takes very long - solution proposal
On 12/04/10 15:24, Bartosz wrote: Loading a large plain data file takes very long. This problem was described at: http://wiki.services.openoffice.org/wiki/Calc/Performance/The_Ou_case Look at file: http://svn.services.openoffice.org/opengrok/xref/DEV300_m94/sc/source/filter/xml/xmlsubti.cxx 38% of time spent in ScMyTables::NewColumn() because of replicated use of aTableVec[nTableCount - 1] (vector::operator[]) What do you think about instead using: aTableVec[nTableCount - 1] use instead: aTableVec.back() I think it could increase an perfomance slightly. Did you measure if that makes a real difference? Eike's suggestion on the wiki page is to reduce the number of operator[] calls by obtaining a pointer or reference once. That will probably help more. Niklas - To unsubscribe, e-mail: dev-unsubscr...@openoffice.org For additional commands, e-mail: dev-h...@openoffice.org
Re: [dev] Code for Pictures
On 12/01/10 11:35, Annika Westerlaken wrote: Currently I am working on a project which requires me to rewrite Writer documents without opening them. The next step is to insert a picture, still without opening the document. The problem is that when I use the original name of the picture, the document has to be repaired. The picture has been renamed to a 32 characters code. It seems this specific code is required to refer to the picture. To see how this code is being determined/generated, I have tried searching the source code. Unfortunately, I have no idea where to look. So I was hoping if someone could either point me in the right direction, or answer my question directly. You don't have to use the same names. Just make sure your files are correctly listed in manifest.xml. Niklas - To unsubscribe, e-mail: dev-unsubscr...@openoffice.org For additional commands, e-mail: dev-h...@openoffice.org
Re: [dev] Re: Code for Pictures
On 12/01/10 14:01, Annika Westerlaken wrote: Thanks for your input. You're right about the entry being needed in manifest.xml, that was already taken care of however. I'm sorry for not being clear enough in my initial message. If I were to unzip an odt file containing a picture and rename this picture in content.xml, manifest,xml and the actual file in the Pictures folder and rezip it, OOo will ask to repair the document when I try to open it. Did you update the zip file, or create a new one? If you create a new file, you have to take special care of the mimetype entry. The repair dialog usually points to a problem on the zip storage level, not a picture that can't be found. Niklas - To unsubscribe, e-mail: dev-unsubscr...@openoffice.org For additional commands, e-mail: dev-h...@openoffice.org
Re: [dev] Crash on PDF export with m92
On 11/19/10 13:10, Pavel Laštovička wrote: I am experiencing crashes or malloc memory corruption when I do export to PDF. The logs I am attaching were created in daemon mode with jodconverter library as a client. I tried to export the same .ods document to .xls without problem. What do you think? Should I update to m91 and try it with that version? Do you also get a crash if you export to PDF manually? Does it happen with all files, or only a specific one? Niklas - To unsubscribe, e-mail: dev-unsubscr...@openoffice.org For additional commands, e-mail: dev-h...@openoffice.org
Re: [dev] Improve MS Office Calc compatibility - easy2fix patch
On 11/04/10 00:53, Bartosz wrote: MS Office Calc could handle sheets in a workbook limited by available memory: http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP005199291.aspx OpenOffice could handle only 256 sheets. To improve compatibility I suggest to increase max number of sheets to 512. There is already submitted issue: http://www.openoffice.org/issues/show_bug.cgi?id=35901 I checked it and it could be done without problems (All variables are defined as SCTAB or long type). It is easy2fix issue. What do you think about this idea? There are some fixed-size arrays and loops, so we would have to look for performance implications first. Niklas - To unsubscribe, e-mail: dev-unsubscr...@openoffice.org For additional commands, e-mail: dev-h...@openoffice.org
Re: [dev] Adding a Comment to a Cell
On 09/27/10 11:13, Phil Hibbs wrote: Is there a way of adding a Comment to a cell in a macro? I tried recording it but it didn't work. See http://wiki.services.openoffice.org/wiki/Documentation/DevGuide/Spreadsheets/Cell_Annotations. Niklas - To unsubscribe, e-mail: dev-unsubscr...@openoffice.org For additional commands, e-mail: dev-h...@openoffice.org
Re: [dev] Linking info from spreadsheets with passwords
On 09/24/10 16:28, Andy Thompson wrote: we have 12 individual spreadsheets that are submitted by individuals with our organization ... these spreadsheets are password protected to open. at corporate office we have an additonal spreadsheet that extracts (via links) info from those 12 individual spreadsheets. in Excel when we open the Corporate spreadsheet and respond that we wish to update the linked data ... we are prompted for the 12 individual passwords related to the 12 individual spreadsheets. in OpenOffice we are currently not prompted for the passwords to open the 12 individual spreadsheets and all linked cells are displayed with a #REF error. Is this function possible and now do we set the corporate spreadsheet to prompt for the 12 passwords if we are indicating to update the linked data. Sounds similar to issue 108404 (http://qa.openoffice.org/issues/show_bug.cgi?id=108404), but there the result was zero values, not #REF. You could check if you get different results with OOo 3.3.0 Beta. Niklas - To unsubscribe, e-mail: dev-unsubscr...@openoffice.org For additional commands, e-mail: dev-h...@openoffice.org
Re: [dev] I have a blank Calc document that shows red text in 3.3
On 08/23/10 23:44, James wrote: I deleted the text. The question is how did the image get there? Probably by pasting HTML from a web page. Niklas - To unsubscribe, e-mail: dev-unsubscr...@openoffice.org For additional commands, e-mail: dev-h...@openoffice.org
Re: [dev] Open Office - RTD Support
Vaibhav Poonekar schrieb: I am working with a product based company. We have a product that uses MS-Excel with RTD functionality. Many of our customers are using Open-Office Calc due to its ease of use and stability. Our team has also found out that Open Office is quite easy and does not have any license issue. We want to integrate Open-Office calc in our application but we were unable to find the RTD like functionality. I am not sure whether this is the correct email-id i am sending my queries to. Please reply if Open-Office Calc has any possibilities of supporting RTD or send me the respective team's email id whom i can get in touch with. You can also check Issue # 109595 You can implement an add-in function with a variable result, see http://wiki.services.openoffice.org/wiki/Documentation/DevGuide/Spreadsheets/Variable_Results, and in that implementation, do whatever is necessary to get the results and notifications. Niklas - To unsubscribe, e-mail: dev-unsubscr...@openoffice.org For additional commands, e-mail: dev-h...@openoffice.org
Re: [dev] FASTBOOL macro vs bool - decrease memory usage
On 06/24/10 12:29, Mathias Bauer wrote: The idea is so good that someone is already working on it. :-) There is ongoing work to replace a lot of ancient types like BOOL, USHORT etc. by sal_... types, with the exception that BOOL/FASTBOOl will be replaced by bool. BOOL - bool will cause problems. Memory usage for new BOOL[n], mixed use with sal_Bool (pointers, references), the occasional special value (SfxChildWinInfo::bVisible). Shouldn't we go the safe way and change BOOL to sal_Bool instead? Niklas - To unsubscribe, e-mail: dev-unsubscr...@openoffice.org For additional commands, e-mail: dev-h...@openoffice.org
Re: [dev] FASTBOOL macro vs bool - decrease memory usage
On 06/24/10 13:07, Bartosz wrote: BOOL - bool will cause problems. Memory usage for new BOOL[n], mixed use with sal_Bool (pointers, references), the occasional special value (SfxChildWinInfo::bVisible). Shouldn't we go the safe way and change BOOL to sal_Bool instead? I agree with you Niklas. It will be much better/safer to change FASTBOOL to sal_Bool. I was talking about BOOL, not FASTBOOL. FASTBOOL usage is much more limited. Replacing FASTBOOL with bool seems possible and more in line with its original intention. I agree with Stephan that it's best to remove the FASTBOOL type altogether and change the places where it's used (much fewer than for BOOL). Niklas - To unsubscribe, e-mail: dev-unsubscr...@openoffice.org For additional commands, e-mail: dev-h...@openoffice.org
Re: [dev] FASTBOOL macro vs bool - decrease memory usage
On 06/24/10 13:52, Stephan Bergmann wrote: Re memory usage: BOOL[n] and bool[n] would each be n bytes in size, or what am I missing? You're right, forget about that part. Re mixed use with sal_Bool: haven't encountered this problem often over the last years (and I liberally use bool instead of sal_Bool/BOOL since ages) -- also, it might be better to try to adapt the mismatching uses of sal_Bool to bool, too, leaving usage of sal_Bool to the only place it belongs, C++ UNO. If you write new code, you see what you're doing. In existing code, BOOL and sal_Bool are often used interchangeably. sal_Bool only belonging to UNO may be a good idea, but not reality. And I don't see an easy way to adapt existing code to that rule. If we change the typedef and then go through the list of compiler errors, we'll only end up with something like sal_Bool bSalFoo(bFoo); process(bSalFoo); bFoo=bSalFoo; and probably still break something that's found only years later. Re the occasional special value: I guess one day we should bite the bullet and clean those up for good. That might be a good thing anyway. But then it should be done separately, so the result can be compiled and tested immediately. Niklas - To unsubscribe, e-mail: dev-unsubscr...@openoffice.org For additional commands, e-mail: dev-h...@openoffice.org
Re: [dev] about the sPageNumber parameter
On 06/21/10 10:41, wangxiang wrote: I'm trying to read the SW code and encounter some problem: like http://svn.services.openoffice.org/opengrok/xref/DEV300_m82/sw/source/ui/utlui/bookctrl.cxx#122 part of the code is here: http://ooo.pastebin.com/P5EswNu2 who can tell me how the paramter sPageNumber is changed ? What exatly does ((SfxStringItemhttp://svn.services.openoffice.org/opengrok/s?defs=SfxStringItemproject=/DEV300_m82 *)pStatehttp://svn.services.openoffice.org/opengrok/s?defs=pStateproject=/DEV300_m82 )-GetValuehttp://svn.services.openoffice.org/opengrok/s?defs=GetValueproject=/DEV300_m82() mean ? StateChanged is called to notify the SwBookmarkControl of a changed status value. The value is in a SfxStringItem, so pState is cast to a SfxStringItem pointer. See the parts about sfx2 based specific statusbar item controllers and mixed sfx2/UNO based environment at http://wiki.services.openoffice.org/wiki/Framework/Article/OpenOffice.org_2.0_User_Interface_Controller_Internals. Niklas - To unsubscribe, e-mail: dev-unsubscr...@openoffice.org For additional commands, e-mail: dev-h...@openoffice.org
Re: [dev] question about sheet ?
On 05/17/10 16:30, Qzi er wrote: I can't understand the code below , what's the deference between getByIndex( 0 ) and *getByName( OUString::createFromAscii(Sheet2)); *; Just what the names suggest: getByIndex(0) returns the first sheet, getByName looks for a sheet with a specific name. XSpreadsheetDocument and XSpreadsheets ; See the pictures at http://wiki.services.openoffice.org/wiki/Documentation/DevGuide/Spreadsheets/Working_With_Spreadsheet_Documents for an overview of the services SpreadsheetDocument and Spreadsheets. why I need use Reference XSpreadsheets twice ? //query for a XSpreadsheetDocument interface Reference XSpreadsheetDocument rSheetDoc (xComponent, UNO_QUERY); //use it to get the XSpreadsheets interface Reference XSpreadsheets rSheets = rSheetDoc-getSheets(); //query for the XIndexAccess interface Reference XIndexAccess xSheetsIA (rSheets, UNO_QUERY); Any sheet = xSheetsIA-getByIndex( 0 ); Reference XSpreadsheet rSpSheet (sheet, UNO_QUERY); If you mean the last line, it's XSpreadsheet, not XSpreadsheets. Niklas - To unsubscribe, e-mail: dev-unsubscr...@openoffice.org For additional commands, e-mail: dev-h...@openoffice.org
Re: [dev] Help Download Source
On 05/07/10 15:49, Romildo Ferreira wrote: I got the packages but i can't find the java implementation of the java inteface XGoalSeek (I believe that must be SpreadsheetDocument.java, or I'm wrong?) It's a UNO interface, with the implementation in C++, in file sc/source/ui/unoobj/docuno.cxx, method ScModelObj::seekGoal. Niklas - To unsubscribe, e-mail: dev-unsubscr...@openoffice.org For additional commands, e-mail: dev-h...@openoffice.org
Re: [dev] OOo's Toolbar Icons - Saving Space
Konstantin Tokarev schrieb: I also propose to remove star wars game from Calc to save space (or at least move it to separate package if there are lots of fans) As chance would have it, that one was dropped already with the modules reorganization in CWS svxsplit. But in terms of space, it was 50K or so. Any discussion about it wastes more space than the code itself. Niklas - To unsubscribe, e-mail: dev-unsubscr...@openoffice.org For additional commands, e-mail: dev-h...@openoffice.org
Re: [dev] Re: Finding code for SvNumberFormatter
On 04/17/10 17:36, Matt Needles wrote: Thanks, Niklas. I see from these sources where to add the new format code, but I can't find where the actual rendering of the formats is done. That is, where is the code that creates the output string in the specified format? Can you help please? SvNumberFormatter::GetOutputString calls SvNumberformat::GetOutputString. There are separate variants for strings and numbers. Some locale-dependent code is in i18npool. Niklas - To unsubscribe, e-mail: dev-unsubscr...@openoffice.org For additional commands, e-mail: dev-h...@openoffice.org
[dev] Re: [sc-dev] Debug the Calc Source Code
On 04/11/10 15:37, rashi dhing wrote: I am getting the error The breakpoint will not currently be hit. No symbols have been loaded for this document after adding a breakpoint to a line in the source file. I have been doing the following: 1) Running Calc by clicking in scalc.exe from the programs dir of the installation set. 2) Opening VS2008 and attaching the process soffice.bin 3)Opening the source files that I need to debug. 4)Adding the breakpoint. But that is when the error arises. I did everything on Calc to hit the breakpoint but nothing happens.Do I have to build the calc source in debug mode ? Has anyone had a similar situation ? Yes, build the affected code with debug=true. You can mix debug and non-debug code, so you don't have to build the whole module with debug information. In fact, until CWS dr73 is integrated, building the complete sc module with debug info will fail, see issue 100534. Niklas - To unsubscribe, e-mail: dev-unsubscr...@openoffice.org For additional commands, e-mail: dev-h...@openoffice.org
Re: [dev] Finding code for SvNumberFormatter
On 04/12/10 19:04, Matt Needles wrote: Where in the CVS tree can I find the code for this class? I'd like to try to add some code, but I need to see the class to find out how to do it. You can use OpenGrok (http://svn.services.openoffice.org/opengrok/) to find class definitions. SvNumberFormatter used to be in svtools/inc/svtools/zforlist.hxx and svtools/source/numbers/zforlist.cxx. In recent developer builds (DEV300m68 and above) it's in svl instead of svtools. Only very old versions are in CVS. Current versions are in Mercurial. Niklas - To unsubscribe, e-mail: dev-unsubscr...@openoffice.org For additional commands, e-mail: dev-h...@openoffice.org
[dev] Re: [sc-dev] Debug the Calc Source Code
On 04/06/10 09:03, rashi dhing wrote: Hi ! Is there a good debugger which can be implemented on the source code of openoffice inorder to step into the lines and add break points at various locations of the code. I am using Cygwin on Windows to compile and build the code. Are gdb and C++ Builder good options ? Would it involve loading all the files into the debugger or just the exe file (scalc.exe for the sc project) ? You can use the Microsoft debugger, see http://www.openoffice.org/servlets/ReadMsg?list=devmsgNo=23888. Niklas - To unsubscribe, e-mail: dev-unsubscr...@openoffice.org For additional commands, e-mail: dev-h...@openoffice.org
Re: [dev] 65,000 lines on calc
On 03/24/10 22:30, Camillem wrote: If you mean the 65536 lines limit, I hasn't yet (at least not in Dev75) http://www.openoffice.org/issues/show_bug.cgi?id=30215 Interesting details on Kohei Yoshida's blog : http://kohei.us/2010/02/20/increasing-calcs-row-limit-to-1-million/ Right. Fixes for the remaining problems are still in progress. We don't want to cause performance problems for those who don't use the larger number of rows. See issue 110116 for an extreme example. The quick dirty solution of enlarging the broadcast slot sizes would slow down recalculation a bit. We'll try to avoid that. Niklas - To unsubscribe, e-mail: dev-unsubscr...@openoffice.org For additional commands, e-mail: dev-h...@openoffice.org
Re: [dev] java rdf problem again
On 03/25/10 08:47, Andrea Chiumenti wrote: Sorry I'm a bit confused, and browsing the site and using google I'm not able to get a solution. I've also tried with XURI nodeTableName = URI.create(m_xContext, tableName); but I get this error: CURI::initialize: argument not splittable: no separator [#/:] Could you please give me a sample snippet ? Just use something like XURI nodeTableName = URI.create(m_xContext, http://www.wingstech.it/gam3/v1.0/tableName;); One more thing: To get the URI for removeMetadataFile, you shouldn't use getURL from the XModel interface. Better use the document's XURI interface (parent of XDocumentMetadataAccess), so you always get the exact URI that the rdf implementation expects. Niklas - To unsubscribe, e-mail: dev-unsubscr...@openoffice.org For additional commands, e-mail: dev-h...@openoffice.org
Re: [dev] Exception on trying to set an rdf metadata in java
On 03/24/10 13:23, Andrea Chiumenti wrote: Object xMetafield = xDocFactory.createInstance(com.sun.star.text.textfield.MetadataField); XText xMetafieldText = (XText)UnoRuntime.queryInterface(XText.class, xMetafield); xMetafieldText.setString(); // clear the field: delete all content --- LINE 110 The field must be inserted before accessing its content. Niklas - To unsubscribe, e-mail: dev-unsubscr...@openoffice.org For additional commands, e-mail: dev-h...@openoffice.org
Re: [dev] java rdf problem again
On 03/24/10 16:33, Andrea Chiumenti wrote: XURI nodeTableName = URI.create(m_xContext, gam3:tableName); The code generates this rdf file: ?xml version=1.0 encoding=utf-8? rdf:RDF xmlns:rdf=http://www.w3.org/1999/02/22-rdf-syntax-ns#; rdf:Description rdf:about=http://.wingstech.it/gam3/v1.0; ns1:tableId xmlns:ns1=gam3:A_TABLE/ns1:tableId ns2:tableName xmlns:ns2=gam3:12345/ns2:tableName /rdf:Description /rdf:RDF What I needed was instead something like this: ?xml version=1.0 encoding=utf-8? rdf:RDF xmlns:rdf=http://www.w3.org/1999/02/22-rdf-syntax-ns#; rdf:Description rdf:about=http://.wingstech.it/gam3/v1.0; gam3:tableIdA_TABLE/gam3:tableId gam3:tableName12345/gam3:tableName /rdf:Description /rdf:RDF In the URI.create call, the parameter should include the namespace URI, not the prefix. A prefix (like ns1) is then generated. You can see it in the example output: If gam3: was replaced by something like http://www.wingstech.it/gam3/v1.0/;, it would be equivalent to the second fragment (except for the namespace definition, which is missing there). Niklas - To unsubscribe, e-mail: dev-unsubscr...@openoffice.org For additional commands, e-mail: dev-h...@openoffice.org
Re: [dev] Should assertions abort?
On 03/18/10 19:16, Terrence Enger wrote: Long version: I just managed to provoke ... Error: Invalid MediaDescriptor detected: Found no URL. From File /home/terry/OOo_hacking/DEV300_m75/comphelper/source/misc/mediadescriptor.cxx at Line 586 Abort ? (Yes=abort / No=ignore / Cancel=core dump) I suppose I should create an issue for this, just because the guidelines say that every assertion failure should be raised as an issue. Still, I shall hold off in case somebody cares to comment. The reasoning is: If we fix the harmless assertion failures, the remaining ones might point us to more serious problems. So, yes, this should be changed. Niklas - To unsubscribe, e-mail: dev-unsubscr...@openoffice.org For additional commands, e-mail: dev-h...@openoffice.org
Re: [dev] Re: mysterious headers */inc/segdefs.hxx
On 03/10/10 19:39, David Tardon wrote: Ha, I wondered why these headers weren't present in the sw module too :) I'll create an issue and remove the remaining ones too, then. It's happening already: http://hg.services.openoffice.org/cws/dr73/rev/f0ff1950d291, http://hg.services.openoffice.org/cws/dr73/rev/341b02a4d27f. Niklas - To unsubscribe, e-mail: dev-unsubscr...@openoffice.org For additional commands, e-mail: dev-h...@openoffice.org
Re: [dev] Calc for Life Science: Who are the masters of output2.cxx - and can those persons guide me a little ?
On 03/09/10 14:14, Jan Holst Jensen wrote: I am dabbling with in-cell rendering of molecules and proteins in Calc. I have made a custom build of DEV300_M60 (I know - it's old now) where I have added code that to some extent can do the job. You can take a look at my progress so far at http://www.biochemfusion.com/work/in-cell/status1.html I haven't found myself able to sufficiently grok the logic in output2.cxx's ScOutputData::DrawStrings() so I can override the cell rendering reliably enough. Also, I could use a hint as to how I should implement proper preview and print support - seems like it is mostly a matter of scaling (?). ScOutputData has member variables nPPTX and nPPTY for the factor of pixels per twip. Just use those instead of a fixed factor, and scaling will adjust to the printer (or different zoom in the view). There is still a special case to be handled though: If the configuration option User printer metrics for text formatting is set, the bPixelToLogic parameter to DrawStrings is TRUE, and PixelToLogic / LogicToPixel has to be used. Niklas - To unsubscribe, e-mail: dev-unsubscr...@openoffice.org For additional commands, e-mail: dev-h...@openoffice.org
Re: [dev] Showing a dialog from My java OTX component
On 02/26/10 16:13, Andrea Chiumenti wrote: Hello, after the dispatch operation I open a message dialog the informs the user that the operation has been successfully concluded. Something like JOptionPane.showMessageDialog(null, Transmission completed! , Info, JOptionPane.INFORMATION_MESSAGE); This obviously has a swing layout, how can I do in the OpenOffice way ? This is described in the Developer's Guide. Take a look at http://wiki.services.openoffice.org/wiki/Documentation/DevGuide/GUI/Message_Box. Niklas - To unsubscribe, e-mail: dev-unsubscr...@openoffice.org For additional commands, e-mail: dev-h...@openoffice.org
Re: [dev] help to Migrate Openoffice 3.1 calc to Vb6
On 02/08/10 09:58, jeyaraj wrote: I am Jeyaraj.R From Maduarai which in tamilnadu(India) I am working in Tvs company we are planning to migrate MS-Office To Open Office. We have developed Our Software Using Vb/Sql Server we have genereated so many mis reports using MS-office Excel with vb6.0. Now we need the sample code for Openoffice 3.1 with Vb 6.0. How to write the data in calc using Visual basic 6.0 ? Please send the sample code it will help to migrate easily. General information about the Automation Bridge is at http://wiki.services.openoffice.org/wiki/Documentation/DevGuide/ProUNO/Bridge/Automation_Bridge, and there's an older tutorial about OOo and VB at http://www.kalitech.fr/clients/doc/VB_APIOOo_en.html. A short overview about the spreadsheet API (using OOo Basic) is at http://wiki.services.openoffice.org/wiki/Spreadsheet_common. Niklas - To unsubscribe, e-mail: dev-unsubscr...@openoffice.org For additional commands, e-mail: dev-h...@openoffice.org
Re: [dev] Formulas Calc
On 01/20/10 00:40, Jorge Eduardo Jaime Castro wrote: I am trying to find out where is the code about duration.modif formula, If you can help me. I will thank you. If you mean DURACION.MODIF, Spanish for MDURATION, it's AnalysisAddIn::getMduration in scaddins/source/analysis/financial.cxx, and the helper function GetDuration in scaddins/source/analysis/analysishelper.cxx. Niklas - To unsubscribe, e-mail: dev-unsubscr...@openoffice.org For additional commands, e-mail: dev-h...@openoffice.org
Re: [dev] Stay-put buttons
On 01/06/10 12:52, R. Georgeson wrote: I looked at toolbars but a) when you generate the toolbar it just puts in as text whatever name you've given the relevant macro without AFAICS any control over colours or font size and I guess without the ability to indicate keyboard shortcuts. If I dock the generated toolbar on the edge of the window (I don't want to reduce the visible rows - I'd need probably 3 toolbars for all the functions and it's a smallish screen) it rotates the text which is hopeless. An add-on component can also specify images instead of text for its toolbar entries, see http://wiki.services.openoffice.org/wiki/Documentation/DevGuide/WritingUNO/AddOns/Images_for_Toolbars_and_Menus. Maybe that helps. Niklas - To unsubscribe, e-mail: dev-unsubscr...@openoffice.org For additional commands, e-mail: dev-h...@openoffice.org
Re: [dev] Selecting the contents of a spreadsheet cell
On 12/02/09 18:53, true...@gmail.com wrote: When a part of the contents of a spreadsheet cell is selected with the cursor, is it possible to get just the selected part, and not the whole contents of the cell ? Not directly, but could try some tricks with the view's XTransferableSupplier interface. Niklas - To unsubscribe, e-mail: dev-unsubscr...@openoffice.org For additional commands, e-mail: dev-h...@openoffice.org
Re: [dev] OpenOffice Calc in the Financial Markets.
On 11/15/09 17:28, Cassio Neri wrote: What are the issues with OOo Calc and what could be done? Please, forgive me if I'm wrong, but I think: 1. Currently, there is no way to recalculate all changed formulas in current sheet. Although the documentation says that F9 does so, in fact, it doesn't. I've recently reported this bug http://qa.openoffice.org/issues/show_bug.cgi?id=105743 I'm working on this issue and I going to submit a patch. With this patch F9 recalculates all changed formulas in current sheet. This is in accordance with OOo documentation. However it's in opposition with my own suggestion in the bug report (that is, to use Shift+F9 as in Excel). I've changed my mind because I found many places (in the web and in OOo help) stating this behavior for F9. I'll come back to this issue below. I'm not sure if it's good to change the existing behavior of F9 this way. In fact we have a request to include external references in F9 (see issue 29370), so maybe adding a new shortcut for current-sheet-only would be better. 2. As far as I know, there are no volatile functions in OpenOffice add-ins. Of course, the OOo API allows add-in functions to return volatile results. This is much more powerful than what we need and consequently more complex to implement. All we need is to tell OOo that some formulas must always be considered out of date even if they don't seem to be. Recall that in Excel, Shift+F9 recalculates all changed formulas in the current sheet. Since for the add-ins that I'm considering all functions are volatile, it implies that Shift+F9 recalculates all (add-in) formulas in current sheet. Therefore, we can avoid any change in the OOo API while keeping the same user's felling provided that Shift+F9 recalculates all cells in the current sheet. I hope I can make a patch for that. We have the open issue 69903 for this. It's not a matter of a simple patch, because we need a way for an add-in to signal that a function should always be recalculated. Having considered issues 1 and 2 above, in a more general way, we have issue number 3: 3. The majority of users work with automatic calculation turned on. For this reason, I guess, OOo is not very well tested when automatic calculation is turned off. I already found and reported another bug in this set up. http://qa.openoffice.org/issues/show_bug.cgi?id=106135 Yes, thanks for reporting it. 4. Sometimes, we want to recalculate just one cell which calls an add-in function. In Excel it's enough to double click on the cell to start it's edition and then press Enter without modifying anything. I don't really know if Excel recalculates anyway or only because the add-in function is volatile. OOo realizes that we haven't change anything it doesn't recalculate. That's not a big issue. A simple workaround is to make a fake change (e.g. one can press LeftArrow before pressing Enter). Unfortunately, it doesn't work when the result is an array. That's a big issue. I would like to report a bug but I can't give a simple way to reproduce it. The problem is that I have to provide the complete code for an add-in. The is not a simple task: The simplest add-in I can think of requires 4 files (one C++, one IDL and two XML) and complicated instructions on how to build it. For an array formula, you have to select the array, edit the formula, move the text cursor, then press Shift-Ctrl-Enter to input an array formula again. Yes, it's a bit cumbersome. Maybe we also need an explicit way to recalculate single formulas, or formulas in a selection. Niklas - To unsubscribe, e-mail: dev-unsubscr...@openoffice.org For additional commands, e-mail: dev-h...@openoffice.org
Re: [dev] Promoting the ODF-Story (or how to break it)
On 10/02/09 11:55, Andre Schnabel wrote: While doing translations for OOo 3.2 I just came across, that we introduced a ODF 1.2 *extended* file format in OOo. From a technical point of view I have some ideas, why this is usefull and needed. But from a users POV, this is rather puzzling. At the one hand we try to promote ODF as standard - we even go that far to introduce venodr independet icons for ODF files (as we want to show, that ODF is ODF, no matter what application you use). At the other hand, we now have three flavours of ODF in OOo and none of these is the ISO standard (what is ODF 1.0). That new entry is part of proper ODF handling. Conforming OpenDocument extended documents are specified in the ODF 1.2 drafts, and are the clean way of handling new features, instead of treating them as if they were already specified. What standard ist this, where you need to change version recommendations even if you upgrade from one minor application version to the next? 3.1 didn't have any features beyond ODF 1.2, so the entry would have been somewhat pointless. See issue 95188. The configuration value remains the same, so you don't have to change anything if you upgrade. Niklas - To unsubscribe, e-mail: dev-unsubscr...@openoffice.org For additional commands, e-mail: dev-h...@openoffice.org
Re: [dev] What is a SLOT and What is a WHICH?
On 08/05/09 05:28, Zhu Lihua wrote: I think: if nId 4999, it's a Slot. if nId = 4999 and nId !=0 , it's a Which. What are the terms slot and which mean? Which-IDs are used to store items in an ItemSet. For most efficient operation, they should be consecutive, so each module uses its own IDs, defined in ranges of items that are stored together. For uniform communication with UI elements (like dialogs or tool bars), an ItemPool can define a Slot-ID for each Which-ID. The same Slot-ID is then used for an item across the modules (like SID_ATTR_CHAR_FONT for the font description). Niklas - To unsubscribe, e-mail: dev-unsubscr...@openoffice.org For additional commands, e-mail: dev-h...@openoffice.org
Re: [dev] Issues with Insert and Delete in merged range
On 07/24/09 10:43, Abhishek Sinha wrote: I cannot insert or delete column within a merged range. Please advice if there is a solution to this. This will be possible in version 3.2, see http://qa.openoffice.org/issues/show_bug.cgi?id=8302. If you don't want to wait, you could also try the extension at http://extensions.services.openoffice.org/project/CalcEasyToolbar. Niklas - To unsubscribe, e-mail: dev-unsubscr...@openoffice.org For additional commands, e-mail: dev-h...@openoffice.org
Re: [dev] Build Comments
On 07/22/09 09:00, Thorsten Behrens wrote: all distros I know of are using the non-gpc clipper since ages, I'm not aware of any regressions there. Also, if my memory does not fail me, Hamburg switched to non-gpc for 3.0, at least I don't find any traces of WITH_GPC in solenv anymore. No trace means it's used: .IF $(WITH_GPC)!=NO Niklas - To unsubscribe, e-mail: dev-unsubscr...@openoffice.org For additional commands, e-mail: dev-h...@openoffice.org
Re: [dev] R1C1 deprecated?
On 04/08/09 09:21 AM, Padmavyuha wrote: I'm wondering whether there has been a decision in OpenOffice v3.xx to remove support for the R1C1 formula schema in spreadsheets? Two observations that prompt this question: i) in v3.xx, the Format::Sheet::Use R1C1 option has been removed (I notice that the Novell oo-build project has re-implemented this globally in the OpenOffice Calc::Calculate prefs pane in their OpenOffice v3.xx builds) It's not deprecated, it's just not finished (issue 72191), and that option has never been in the builds from download.openoffice.org. ii) in v3.xx, the MS Excel 03 XML import/export functionality has been broken (it worked beautifully in v2.xx). When you choose that save-as option, OpenOffice now exports using its own ODFF [.a1] schema instead of the R1C1 schema that Excel XML requires, making it unreadable in Excel (and other apps that support that doctype). And as of v3.xx, Excel 03 XML docs do not import properly into Calc if they contain cell references in their formulae. That's a different problem, see issues 94261 and 96018. Niklas - To unsubscribe, e-mail: dev-unsubscr...@openoffice.org For additional commands, e-mail: dev-h...@openoffice.org
Re: [dev] Get list of top votes on QA site?
On 03/25/09 08:02, André Schnabel wrote: I am looking for a way to list the issues with the largest number of votes on the QA site (qa.openoffice.org). I tried going to: qa.openoffice.org - Miscellaneous link - Issue Votes link The list at this location (http://qa.openoffice.org/iz_votes.html) has not been updated since 2006-02-19, and the spreadsheet template it mentions (issuevotes.ots) doesn't seem to have a way to let me list the issues with the largest number of votes. The link that is used by the spreadsheet is (very long:) http://www.openoffice.org/issues/buglist.cgi?Submit+query=Submit+queryissue_status=UNCONFIRMEDissue_status=NEWissue_status=STARTEDissue_status=REOPENEDvotes=50cmdtype=doitorder=issues.votes%20desc%2C%20issues.priority interestinng - the spreadsheet crashes with OOo 3.1 :( Oh, that's quite bad. Thanks for noticing it. As soon as Issue Tracker works again, I will submit an issue and try to get it into 3.1. Niklas - To unsubscribe, e-mail: dev-unsubscr...@openoffice.org For additional commands, e-mail: dev-h...@openoffice.org
Re: [dev] Get list of top votes on QA site?
On 03/25/09 11:47, Niklas Nebel wrote: Oh, that's quite bad. Thanks for noticing it. As soon as Issue Tracker works again, I will submit an issue and try to get it into 3.1. http://qa.openoffice.org/issues/show_bug.cgi?id=100538 Niklas - To unsubscribe, e-mail: dev-unsubscr...@openoffice.org For additional commands, e-mail: dev-h...@openoffice.org
Re: [dev] OOo BASIC Calc extension - sheet functions in library other than Standard - how ?
On 03/17/09 14:08, Peter Eberlein wrote: Jan Holst Jensen schrieb: Peter Eberlein wrote: no, you cannot add functions to the Standard library using an extension. You'll have to develop an Add-in (in C++, Java or Python). if issue http://qa.openoffice.org/issues/show_bug.cgi?id=53615 (allow other libraries) is solved, things will become easier. It is an issue from 2005, so it seems I shouldn't hold my breath for a solution... ? Ask Niklas... No quick solution in sight. We don't want to load and search all libraries, and we don't have any additional information available besides the function name. Niklas - To unsubscribe, e-mail: dev-unsubscr...@openoffice.org For additional commands, e-mail: dev-h...@openoffice.org
Re: [dev] Namespace prefix is relevant for validity...?
On 03/04/09 18:21, Florent Georges wrote: I found something weird with OOo 3.0.1 (OOO300m15, build 9379.) I create a new, empty file with Writer. Then I edit the file META-INF/manifest.xml to change the prefix used from 'manifest' to 'mf'. And Writer does not want to open it anymore. It proposes to repair it but without success. If I edit the file again to revert my changes, everything's fine (so that should not be related to the tools I used to edit the file.) See issue 93558 (http://qa.openoffice.org/issues/show_bug.cgi?id=93558). Niklas - To unsubscribe, e-mail: dev-unsubscr...@openoffice.org For additional commands, e-mail: dev-h...@openoffice.org
Re: [dev] Patch is waiting review for 6 motnh - Issue 35579 (Calc).
On 02/10/09 20:17, Kirill Palagin wrote: Niklas Nebel пишет: That one should find its way into 3.2. Thanks. Maybe this one http://qa.openoffice.org/issues/show_bug.cgi?id=8302 too? Maoyg is working on issue 8302. I don't know if it will be finished in time for 3.2. Niklas - To unsubscribe, e-mail: dev-unsubscr...@openoffice.org For additional commands, e-mail: dev-h...@openoffice.org
Re: [dev] Patch is waiting review for 6 motnh - Issue 35579 (Calc).
On 02/07/09 19:22, Kirill Palagin wrote: Dear developers, please review and comment on latest patch in voted http://www.openoffice.org/issues/show_bug.cgi?id=35579. As you can see from the issue, this is not a patch that got no attention, but it went through several iterations of review and changes already. There is of course a limit of how much effort we can put into a single issue. If someone else wants to take a look at the latest patch and point out remaining problems, that would be very welcome. Niklas - To unsubscribe, e-mail: dev-unsubscr...@openoffice.org For additional commands, e-mail: dev-h...@openoffice.org
Re: [dev] function formulas / source code
On 02/08/09 07:46, Anibal Pacheco wrote: I'm looking since 2 days how to reach the formulas (or the source code) of the functions like PMT or any one in calc. I have to write them in javascript to translate an spreadsheet into HTML for a client that asked this to me. And I can't find such code / formula. Do you know where can I find them? Built-in functions are in sc/source/core/tool/interpr*.cxx, see http://wiki.services.openoffice.org/wiki/Calc/Implementation/Spreadsheet_Functions for more details. Some add-in functions are in scaddins/source/analysis. More general information, sometimes including formulas, is available in the ODF Formula specification, see http://www.oasis-open.org/committees/documents.php?wg_abbrev=office-formula. Niklas - To unsubscribe, e-mail: dev-unsubscr...@openoffice.org For additional commands, e-mail: dev-h...@openoffice.org
Re: [dev] Patch is waiting review for 6 motnh - Issue 35579 (Calc).
On 02/09/09 21:16, Kirill Palagin wrote: Niklas Nebel пишет: As you can see from the issue, this is not a patch that got no attention, but it went through several iterations of review and changes already. There is of course a limit of how much effort we can put into a single issue. If someone else wants to take a look at the latest patch and point out remaining problems, that would be very welcome. So this issue was silently abandoned 7 month ago? It's an open issue, with some work already done. And I'm serious about the welcome part. Is issue 5550 abandoned too? That one should find its way into 3.2. Niklas - To unsubscribe, e-mail: dev-unsubscr...@openoffice.org For additional commands, e-mail: dev-h...@openoffice.org
Re: [dev] Unused file in sc
On 10/20/08 09:11 AM, David Tardon wrote: Seems that sc/source/ui/app/template.cpp is an unused file--it's not built, it includes header which is not present anymore. Why it hasn't got deleted yet? Or did it reappeared during CVS-SVN conversion? Just small enough so it was never noticed. It was there in CVS, too (and it's template.cxx, not template.cpp). Btw, in sc/source/ui/app/makefile.mk, all files listed in EXCEPTPIONSFILES are listed in SLOFILES also. Isn't that a problem? EXCEPTIONSFILES is used like that all over the place. Perhaps unnecessary, but not a problem. Niklas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dev] CHINA001
Kohei Yoshida wrote: I will then follow this convention and comment out all unused methods with //UNUSED2008-05. I put the date there so that we will know how long that code has been commented out (to perhaps help us remove it later on after a certain period of time). That sounds good. Niklas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dev] CHINA001
Caolan McNamara wrote: Its connected to the binfilter stuff, comments in the non-binfilter code with CHINA001 should basically indicate that the code was removed from the non-binfilter code because it was believed only needed to support other-code that is now solely in the binfilter, i.e. the legacy 5.2 binfilter filters and other similar things. The CHINA001 lines are from dialogdiet01, where dialog code was moved into separate libraries (issue 24916). Old binfilter code in sc was only partially removed so far, this causes some of the entries in your list. Niklas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dev] List of 2730 uncallable methods in DEV300_m10
Caolan McNamara wrote: On Fri, 2008-05-09 at 16:47 +0200, Eike Rathke wrote: while ScCompressedArray::GetPrevValue() is currently unused it is the counterpart of GetNextValue() and IMHO should be kept for completeness of implementation. Perhaps #ifdef FUTURE around it, or else I can add such things to the whitelist if that's undesirable. Good old opt-in vs. opt-out choice. I'd prefer to leave all methods in the header files, commented out and marked somehow, unless someone has (manually) determined that they really shouldn't be there. Otherwise, inevitably, it will cause problems much later, where you look at a class and ask yourself, how is that supposed to work, I can (for example) add an entry but not remove it. I know these marks are ugly and tend to stay there forever (example: CHINA001), but it's still better than always having to dig through the CVS log to see if the class you're looking at is still the class as it was intended to be. Niklas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dev] [Calc] Data pilot from OLAP data
Andreas Saeger wrote: What are the preconditions to create a data pilot from OLAP data as suggested by the disabled third option in the first pilot dialog and in the online help: Help called from Select source dialog: External source/interface Opens the External Source dialog where you can select the OLAP data source for the DataPilot table. That third option is enabled if you have an implementation of the UNO service com.sun.star.sheet.DataPilotSource, for example from an extension. It's then up to that extension to provide the results. It could use an OLAP server, but I'm not aware of an extension that actually does so. Niklas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dev] sc project to fix flashing of cells
Gregg Weber wrote: I would like to work on a change to the sc code. I have built the 2.0.4 source on my machine, and browsed the code for a month or so. The change my company wants me to make involves improving the drawing of the cells area of the sc window. Currently, it flashes, because the whole thing is drawn on the window, so you see a background square, then the grid appears, then the cells contents, etc. Of course it all happens very fast, but the result is an annoying flashing appearance. The usual xlib solution is to draw into an offscreen pixmap, then copy the completed pixmap to the window. In gridwin4.cxx I would want to change the aOutputData at line 516 from a window to a pixmap, and at the end of the ScGridWindow::Draw routine, copy the pixmap to the screen. I am not an expert at xlib, or the openoffice higherlevel routines calling xlib, so I am not sure of the correct details. Would anyone care to assist me with this project? Since 2.0.4, there have been some changes to that code, in preparation of a similar solution. The XOR-ed elements (cell cursor, selection and some more) are now overlays, handled by class OverlayManager. The cell contents are at the moment still drawn to the window, though. This is not a perfect solution (as evidenced by issue 73602). The current plan is to draw cell contents into a VirtualDevice managed by the OverlayManager, too (as you wrote, pass that device to ScOutputData). We still have to find a solution for the editing of text in a cell or drawing object, because the EditEngine that handles text edit can currently only work with a Window. Niklas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dev] Lock a document for concurrent access?
Jan Holesovsky wrote: I'm not sure if concurrent access for documents is a good idea. Currently our merging is not perfect and you will have a lot of disappointed users. For me this is doing the second step before the first. Without a better merging we can't offer concurrency. I am a fan of incremental improvements ;-) So if the merging is not 100%, the users will tell us we'll be able to fix that. I cannot do analysis of all the corner cases; all I know is that the merging works well enough for basic work. I will improve it in the next iteration based on the feedback if it's not sufficient. Change tracking and merging in Calc is already supposed to handle all content (not formatting) changes that are not disabled in recording mode. That seems to be enough to make the feature useful. Besides that I don't think that something must be changed in osl. We just have to change our way how we interpret the results from openFile. Unfortunately it must be. I don't want to open the file again, I just want to set/clear the lock, and there's no API for that in osl. Why not open it again? Treat it more like import/export instead of load/save, with embedded objects in a temporary storage, and don't keep a file handle. Then, before saving, check if your shared file is still there (you'll have to read it anyway, for the intermediate changes). Niklas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dev] Calc C#CLI programming - Get the used range in a sheet - XUsedAreaCursor
Paul Veuve wrote: But accessible methods for xUsedCursor in C# are only: xUsedCursor.Equals() xUsedCursor.GetHashCode() xUsedCursor.GetType() xUsedCursor.gotoStartOfUsedArea() xUsedCursor.gotoEndOfUsedArea() xUsedCursor.ToString() There is no method nor property for .RangeAddress Service SheetCellCursor includes service SheetCellRange, so you can just query for XCellRangeAddressable interface. Niklas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dev] In the Works: New OOo C++ Coding Standards
Thorsten Behrens wrote: You've hit the point exactly. There are some rules that require consistency and easy discernibility of local and member variables, and that's about all that needs to be said about that. Whether a member starts with m_ or with ma is largely irrelevant - as long as it is used consistently (module boundaries would be a natural border here). Historically, OOo modules differ on that, to some extent, and it would be IMO be a waste of time to enforce one single naming scheme. Historically, modules also differ on a lot of other subjects. That's why we need these guidelines in the first place. A little bit of naming convention is certainly needed. Nobody wants to see a mixture of Foo aFoo(maFoo); CFoo foo(_foo); foo f_(f); even if it's in different modules. Niklas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dev] In the Works: New OOo C++ Coding Standards
Kohei Yoshida wrote: The first thing that caught my eye is that, you guys are switching from using tab characters for indentation to using spaces. I'm actually fine one way or the other (though quite a number of developers I've worked with prefer using spaces for indentation), but I'm curious about the reasoning for this change. We've had this rule (to use spaces) for quite some time, it's just a bit difficult to find. It's mentioned in http://tools.openoffice.org/coding.html, which is no longer linked to (replaced with CodingGuidelines.sxw). In practice, for new code, the rule is mostly followed. Niklas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dev] Web CVS?
Matthias B. wrote: Is it possible to access the OOo repository via Web? I'm sitting behind a firewall so I can't use CVS to access the repository. Use the Version control - CVS link on the project page (sw.openoffice.org). Niklas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dev] Specs. closer to a solution
Mathias Bauer wrote: Primarily interaction with User Experience, but also Documentation, l10n - I'd like to ensure not only that they have a clearly defined opportunity to comment / have their say; but that their window of opportunity here is time limited :-) 'discuss' with ... UserEx is fundamentally synchronous, and very hard to verify later, and perhaps open to lots of problems. Much as I hate process, I'd like to be able to point to a mailing list post and say no replies in 2 weeks = uncontroversial approved. I see. I think at least no developer (neither Sun or non-Sun) will have any problem to agree here. :-) One does. If we consider User Experience involvement with UI changes important, we can't skip that step whenever they are too busy to look at a specific issue. Otherwise, we could do the same with QA: If they don't object within two weeks, a change is integrated. That would speed up things, too. :-) Niklas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dev] Unicode---Give us all of it!
Stephan Bergmann wrote: I doubt that it is that many places that need to be changed. (For example, what do you think needs to be done for text import/export?) The obvious changes for text import: - Separator characters are user-supplied, so they can no longer be handled as a sal_Unicode. - Where fixed field width is used, characters instead of code units have to be counted. The less obvious ones start to appear once you look through the details of implementations like the preview in the dialog. Niklas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dev] Unicode---Give us all of it!
Stephan Bergmann wrote: In a first step, I will try to identify and gather as many places in OOo that need to be adapted, but I need your help for that: IF YOU KNOW OF ANY PLACE IN OOo THAT NEEDS TO BE ADAPTED, PLEASE LET ME KNOW. Wouldn't that be more or less any occurence of sal_Unicode? There's hundreds of them in Calc alone. Niklas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dev] Unicode---Give us all of it!
Philipp Lohmann - Sun Germany wrote: Wouldn't that be more or less any occurence of sal_Unicode? There's hundreds of them in Calc alone. That depends probably on the details. If for example you are searching for ansi1252 code characters in a unicode string (e.g. '/' for URL or filename parsing springs to mind), then you need not change that code since those codes do not coincide with the possible surrogate values. I guess many instances may fall into that category where searching for a known constant unicode is concerned. Hundreds to look through, still quite a lot to actually change (text import/export, parsing, input handling, ...). However if we were to change the underlying format of OUString, then also these cases would possibly have to be adjusted; e.g. UTF-8 leaves only true ascii (128) values as a single encoded character (one byte in that case). However if i'm not mistaken, changing OUString from 2 byte values will not be possible since it would change UNO protocol incompatibly, yes ? I'm not saying it can't be changed as Stephan suggested, I'm just wondering if we really need a long list first. Niklas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dev] Specifications - summary suggestions ...
Kohei Yoshida wrote: On 11/3/06, Mathias Bauer [EMAIL PROTECTED] wrote: Let's put it that way: it should be possible to integrate something even if the original goal laid out in the spec wasn't reached but the result is good enough. Good enough means that we could live with it even if nothing was changed until the release date. This is something you always must take into account, especially in case of community development. ... We never should accept unfinished UI work in a way that parts of the necessary functionality *willingly* don't work to a degree that users will expect in a professional application. This can't be described by a fixed percentage but I assume that it can be judged with common sense. If developer, QA and other participants agree that it's good enough, then let's take it. I like the way you put it. This is essentially what I was trying to say in my post. Looks like we're on the same page here. But note how the original goal laid out in the spec wasn't reached implies that there was a spec to begin with. Niklas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dev] changing the OOo-Configuration via API has no effect during runtime
Mathias Bauer wrote: Are you sure that it doesn't affect even new documents you create later? Then it would be a bug (Writer having a cached value that doesn't react on changes of the configuration) and you should create an issue. One may call it a bug, but it's not surprising. When the old config items were changed to read their values from the configuration, proper notification wasn't added in most places. It was something to be added later, and we all know how later never comes. Niklas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dev] Specification Process Possibilities ...
Jim Watson wrote: http://www.openoffice.org/issues/show_bug.cgi?id=2977 In this case something different was specified and fixed, while the bug persists at http://www.openoffice.org/issues/show_bug.cgi?id=33851 Are you saying it's a bad thing that there is a specification that details what was done for 2.0? Would you prefer us saying We've done something about this issue, wait for the release to see what it was? Niklas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dev] Specification Process Possibilities ...
Kai Backman wrote: We all want to improve quality. The user is the one who judges quality. If users don't agree with each other, that doesn't help much. Unless you want to play ping pong and fix the behavior back and forth with each release. Niklas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dev] Calc cell justification
Alan Yaniger wrote: If I have a given ScBaseCell object, I want to set the justification based on its text. I know that I can get the text through GetStringData(). But how can I change the justification setting of that cell? The alignment attribute is part of the cell attributes that are stored for cell ranges within a column in the ScAttrArray class. But if you want to dynamically change the alignment based on content, including formula results, it's probably better to extend the handling of default alignment that currently aligns text left, numbers right. Look for occurences of SVX_HOR_JUSTIFY_STANDARD, especially in sc/source/ui/view/output2.cxx, which has the code for text output. If you have further questions, we should take this to the dev@sc.openoffice.org list. Niklas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dev] Calc, making print only current sheet installation default?
Kirill S. Palagin wrote: What do you think of default Calc's behavior to print complete workbook instead of just current sheet? Printing all sheets seems counterintuitive and wasteful in the age of Reduce, Reuse, Recycle. There is very old issue http://www.openoffice.org/issues/show_bug.cgi?id=10530 for that. The default for the print options dialog can be set under Options - Calc - Print. If not this, at least making result of Print more consistent with Export to PDF and Page Preview (last two do not respect Print only selected sheets and output all sheets regardless) would make behavior more logical and predictable to users. Please share your thoughts on the subject. Page preview is a different, independent view on the document (you can keep a preview window open while editing the same file in another window), not a function that is called with a selection state. P.S. Is there any sense in voting for issues? Does anyone looks into number of votes when deciding on new features, RFEs, design change requests? Issues with many votes stand out and are looked at, but of course that doesn't mean they are automatically implemented. Niklas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dev] ustring - global hash (?)
Stephan Bergmann wrote: As discussed, the single global solution has some drawbacks compared to any local solutions (which can potentially get away with never removing from the cache, or not being thread-safe), so a list of places that already use or would most probably benefit from using this technique would be interesting when making a decision. Issue 63500 (a limited-size hash for string cell content in Calc) is related to this. Niklas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dev] Real-time data in OpenOffice Calc
Vasko Tomanov wrote: Do anyone have any idea how to create a add In which put real-time financial data in OpenOffice Calc ? For example in Excel there is a RTDServer interface. Do OpenOffice Calc have something similar ? I will appreciate any idea how a real-time data add In can be implemented or from where to start the development. You should write an add-in function with results of type com.sun.star.sheet.XVolatileResult. The Developer's Guide has an example where a counter is incremented from a background thread. Niklas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dev] Re: [documentation-dev] creating Excel files
Dave Calkins wrote: I'd like to be able to export to an Excel file from my app which will be running in a shop floor environment on a machine which would not have MS Office or Open Office installed. Why don't you just install OOo and control it using the API? Would it be feasible to re-use the Excel file writing code from OpenOffice? I downloaded the OO SDK and was scanning the developer's guide, however, it seems to be coming from the approach of connecting to a running OO instance as opposed to re-using OO code in your own app (on a machine which wouldn't have OO installed). If you really want to use parts of our source, there's a bit of an overview of the Excel filter classes at http://sc.openoffice.org/servlets/ProjectDocumentList under Source Code Documentation. It's not completely up to date, but it might help to get started. Niklas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dev] Adding my own tags into ODF-Format
Tom Schindl wrote: thanks for your reply I think the easiest soltion would use the attribute way described in the last mail I sent. Is it allowed to have custom attributes in ODF? Do you just want to load the file, ignoring the extra content, or do you need to preserve your markers? Foreign elements and attributes are ignored in most places. In a few places, like style:table-cell-properties in a cell style, foreign attributes are read and preserved. In the case of a cell style, they are then included when the cell is copied or moved, and written again in the cell's style when the file is saved. Niklas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dev] Adding my own tags into ODF-Format
Yeatts, Garnett W. CONTR J9C329 wrote: Most of the foreign elements and markers are lost when the file is saved. I am also interested in adding some custom attributes or information to ODF files. Is there a recommended way of adding more information to an ODF document using the existing schema that would be persisted through saving in OO? Metadata if it's for the whole document, or own propertites in styles if it's related to single parts. Niklas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dev] Adding my own tags into ODF-Format
Tom Schindl wrote: From your mail i got the feeling that this is not possible at the moment in OpenOffice. Wouldn't it be a simple to restore this non-odf values e.g. as strings next to the object and insert them back when saving the object (I know this is not so easy but you may get my point :-). It's possible, but you need one indirection: The marker is added to an (automatic) cell style, your processing code has to keep track of which cell style contains which marker, and react on a cell with a style with a marker. You don't even have to manually edit the content.xml file. A cell's foreign attributes (from its style) are available in the API property UserDefinedAttributes. Niklas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dev] How to get row value in array formula
mesa rit wrote: In Excel, when I used the array formula on a group of cells, I can use like {0;1;2;3;4} for the rowValue of the cell and {0,1,2,3,4} for the column value of the cell. What is the equivalent method in OpenOffice? Array constants will probably be supported sometime in the future (issue 32342). Until then, you can always put the sequence of numbers into a cell range and use a reference to that. I have asked in the user forum, but no answer received. I am wondering, whether this feature is available in open office? We also have a separate spreadsheet users list, [EMAIL PROTECTED] the neearest I can get is =row(...) but it will return the row number of the whole sheet. What I need is the row number of the selected array. You can also use ROW()-ROW(xx), where xx is the first cell of the array formula, or something like ROW(B5:B7)-ROW(B5). Niklas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dev] Find a bug in Microsoft Excel
刘俊峰 wrote: A date displays 2006-6-2, but becomes 2006-6-3 when read out according to file format. I find that Microsoft Excel counts the days of year 1900 as 366. Yes, that's known and documented in Microsoft's knowledge base. How to know whether the value of a RK cell is a date? From the number format. Niklas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dev] x86 osl/interlck.h performance
Jens-Heiner Rechtien wrote: BTW column 1 and 2 are directly comparable to the columns below, a 23% improvement from m164 to m170, wow! A large part of that might be due to issue 64109, which was introduced in m162 and fixed in m167. Niklas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dev] XTableCharts.addNewByName()
Tadashi Ohmura wrote: ::com::sun::start::table::XTableCharts class's addNewByName() method's parameter bColumnHeaders and bRowHeaders do not work. In the document: Parameter bColumnHeaders if set to true , the topmost row of the source data will be used to set labels for the category axis or the legend. Parameter bRowHeaders if set to true , the leftmost column of the source data will be used to set labels for the category axis or the legend. But when I set these parameters true, the topmost row of the source data is not used to set labels for the category axis or the legend the leftmost column of the source data is not be used to set labels for the category axis or the legend. Generally this works. Any more details on what you're doing? Niklas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dev] Creating a listener for Cell Data change in OpenOffice calc.
Sathya C wrote: Is there a way to know which cell in the range was modified? If you add the listener to a cell range or sheet, no, and you'll also be notified only once if several cells are modified at the same time. If you want to observe individual cells (and there's not too many of them), you can try adding a listener to each cell. Niklas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dev] Creating a listener for Cell Data change in OpenOffice calc.
Sathya C wrote: I am writing an add-in for OpenOffice Calc. I want my program to get notified when something is entered into a the spreadsheet cell or the data has been modified in the data cell. Can you please advice me which Listener I should be using. I tried using XEventListener and XActivationEventListener. But none of these interfaces are delivering me the events when the datacell change occurs. Use the XModifyBroadcaster interface of the cell or cell range you want to observe. Niklas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dev] Finding out the cell address inside the addon
Dinesh Varadharajan wrote: I forgot to mention i am writing java addon and inside it we wont be having any reference. And also there seems to be no way of doing any callbacks to the formula execution. The position of the cell that's being calculated isn't available to an add-in function, sorry. You'll have to add a parameter to the function. What kind of callback are you referring to? Niklas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [dev] Calc, VLOOKUP 1.1 - 2.0: Changing of default behaviour?
Andrew Douglas Pitonyak wrote: When I created the document. I think that I noticed a behavior change NOT a specification change. In other words, I thought (correctly, or incorrectly) that it always assumed sorted, but the behavior changed when an unsorted list was incorrectly referenced as sorted. That's right. See issue 2168 for details. Niklas - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]