Re: [libreoffice-users] Macros in spreadsheets
On 3/1/23 09:13, Michael Tiernan wrote: On 12/23/22 11:02 AM, Andrew Pitonyak wrote: If you are looking to cause functions to recalculate, Thanks for the reply. Here's the thing. It's not that I want to force a recalculate, it's that I have to in order to get the macros to respond. Here's an example: (What I expect when the spreadsheet finishes opening.) /*Cell*//* */ /*Contents*//* */ /*Display*//* */ D1 192.168.17.231/24 192.168.17.231/24 D2 =ipwithoutmask(D1) 192.168.17.231 D3 =ipmask(D1) 255.255.255.0 D4 =ipmasklken(D3) 24 Now, when I actually do open the spreadsheet, it says: /*Cell*//* */ /*Contents*//* */ /*Display*//* */ D1 192.168.17.231/24 192.168.17.231/24 D2 =ipwithoutmask(D1) #NAME? D3 =ipmask(D1) #NAME? D4 =ipmasklken(D3) #NAME? So, if I say it differently, it *seems* like the Macros aren't run when the spreadsheet is opened. The macro library has a "Main" entry that is empty. If I choose "Tools" -> "Macros" -> "Run macro" and then select "Main" and execute it, there's no visible change. BUT, if I go into the contents of "D2" and add a space at the end of the formula "=ipwithoutmask(D1)" to read "=ipwithoutmask(D1) " and hit return and the macro executes and displays the proper value. HOWEVER, none of the other cells change so I have to go into each one and do the same sort of thing, add a space at the end of the line or between the macro and the parenthesis, each time, hit return and it works properly. This is obviously not the correct way it should work. Hence my query about "starting" macros when the document is opened. So, that leads to, am *I* doing something wrong? Thanks for everyone's time. Not being familiar with Calc's macro functionality, what you are showing as your macro references looks like a formula, so I would check two things, which you may have already checked as I also haven't been following this thread, check your macro security options as they may be preventing your macros from running as the default option is to prevent unsigned macros from running. Also check your formula "recalculate of load" options as they may be set to not recalculate. With your main entry being empty I would expect running that to actually do nothing. Looking at the existing macro definitions and the way they are shown when placing the cursor in them, I would assume your macros are within a module, so when you reference the macro in your formula, do you need to reference is as, for example, .ipwithoutmask(D1)? regards, Steve -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Closing and reopening Writer - ver 7.4.1.1
On 19/9/22 17:19, Michael D. Setzer II wrote: On 19 Sep 2022 at 7:56, Ianseeks wrote: From: Ianseeks To: users@global.libreoffice.org Subject:[libreoffice-users] Closing and reopening Writer - ver 7.4.1.1 Date sent: Mon, 19 Sep 2022 07:56:02 +0100 HI With this latest version, if i close Writer, the next time I open it, its displayed as a very small square window in the top left hand corner of the screen which then have to resize to full screen. This happens with or without a document open but not evey time. Anyone else having this issue? regards Ian -- Not seeing that on Fedora 35 with XFCE, checked and I have 7.4.1.2 so don't know if that might have a fix? Info from help about version info copy. Version: 7.4.1.2 / LibreOffice Community Build ID: 3c58a8f3a960df8bc8fd77b461821e42c061c5f0 CPU threads: 2; OS: Linux 5.19; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded I'm on Fedora 36 using KDE and the version of libreoffice provided with the distribution which is 7.3.6.2 and I don't see the issue, but then I also haven't done any configuration of writer as yet. Version: 7.3.6.2 Build ID: 30(Build:2) CPU threads: 32; OS: Linux 5.19; UI render: default; VCL: kf5 (cairo+xcb) Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded regards, Steve opensuse:tumbleweed:20220915 Qt: 5.15.5 KDE Frameworks: 5.98.0 - KDE Plasma: 5.25.5 - kwin 5.25.5 kmail2 5.21.1 (22.08.1) - akonadiserver 5.21.1 (22.08.1) - Kernel: 5.19.8-1-default - xf86-video-nouveau: 1.0.17 -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy ++ Michael D. Setzer II - Computer Science Instructor (Retired) mailto:mi...@guam.net mailto:msetze...@gmail.com Guam - Where America's Day Begins G4L Disk Imaging Project maintainer http://sourceforge.net/projects/g4l/ ++ -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Bug report in calc, V.7.4
On 1/9/22 17:51, Harvey Nimmo wrote: On Thu, 2022-09-01 at 17:39 +1000, Stephen Morris wrote: On 29/8/22 09:21, Regina Henschel wrote: Hi Matthias, Matthias Lammer schrieb am 29.08.2022 um 00:24: Dear LibreOffice team, I want to file a very severe bug as follows: I create a simple function in Basic: Function myAdd(x, y, z) myAdd = x + y + z End Function Then I can call it as usual with =myAdd(...). Next, I want to update myAdd to subtract the values, I end up with: Function myAdd(x, y, z) myAdd = x - y - z End Function I save my changes and press F9 for recalculation That will not work. Neither any of the cells referenced as parameter nor the formula in the cell has changed. So F9 will not detect any change. but Calc still gives me the value for the adding up the 3 values. You need to use a 'Recalculate Hard' in this case, that is Strg+Shift+F9. Just a silly question, which key is Strg? regards, Steve Kind regards, Regina Strg is the German abbreviation for 'Steuerung', i.e. Control, Ctrl, on the English keyboard. Harvey Thankyou. regards, Steve -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Bug report in calc, V.7.4
On 29/8/22 09:21, Regina Henschel wrote: Hi Matthias, Matthias Lammer schrieb am 29.08.2022 um 00:24: Dear LibreOffice team, I want to file a very severe bug as follows: I create a simple function in Basic: Function myAdd(x, y, z) myAdd = x + y + z End Function Then I can call it as usual with =myAdd(...). Next, I want to update myAdd to subtract the values, I end up with: Function myAdd(x, y, z) myAdd = x - y - z End Function I save my changes and press F9 for recalculation That will not work. Neither any of the cells referenced as parameter nor the formula in the cell has changed. So F9 will not detect any change. but Calc still gives me the value for the adding up the 3 values. You need to use a 'Recalculate Hard' in this case, that is Strg+Shift+F9. Just a silly question, which key is Strg? regards, Steve Kind regards, Regina -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Bounced messages -- what's that?
On 22/8/22 19:19, Pertti T.J. Rönnberg wrote: Best LibreOffice gurus, Approx twice a month since January I've got that mail (on this address only; never before): /from: users+ow...@global.libreoffice.org/ /"Hi, this is the Mlmmj program managing the mailing list. Some messages to you could not be delivered. If you're seeing this message it means things are back to normal, and it's merely for your information. Here is the list of the bounced messages: - 57967"./// I am not aware of any missing messages and obviously "things are back to normal". My PC (Win10pro, 16GB, AMD Ryzen 7, SSD) seems to work as expected. I normally delete this message directly but decided now to ask. Any ideas what this is about - and where can I see "message 57967"? I've been getting those for quite some time as well. I've just been treating them as a scam. regards, Steve Thanks in advance Pertti Rönnberg -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] export data from Calc, import to Base
On 9/8/22 05:16, Harvey Nimmo wrote: Dear formum, I believe my objective should be rather simple, but I need to be pointed in the right direction. I have a column of text data (unique values) in Calc that I want to transfer to a Base table. The Base table has been set up with three columns, two of which I expect to remain empty after the data import. The one column of unique values will be the primary key. I thought that the best way to implement the data transfer would be to create a .csv file from the column of data, but I need help to find out how Calc supports this. Can anyone help? One idea I had, was to copy the data column (which contains more than 7000 values, incidentally) to a text file. Unfortunately, I do not understand enough about regular expressions to add two commas before each linefeed. Help there would be appreciated. (For completeness, the Base Table is a front end to a backend Mysql database, and I expect the import to be done using phpMyAdmin) Regards Harvey Hi Harvey, In Calc the File->Save As option has a filter of filetypes for the output file, one of which is .csv. This will then save your spreadsheet as a csv file. When you import the csv into Base you may have to configure the type and format for each of the fields you are importing. regards, Steve -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Writer 4.6.2.3 Failure With Word Document
On 10/15/2014 10:09 AM, Tom Davies wrote: Hi :) The macros are very specific to that 1 specific version of MS Office. To use the file in MSO 2007 or 2013 or 365 then you might need to have the macro rewritten. If you had them rewritten for LibreOffice then you probably wouldn't ever need to rewrite them again, except to add improvements or the fairly rare times that a relevant bit of functionality got completely rewritten in a different way. Is there any chance of posting the macro's code into an email for this public mailing list to have a look at? People sometimes have suggestions about what might need to be changed or even some coding suggestions sometimes! When Writer crashes it used to often be due to Java. Is it possible to turn java off for a bit? Tools - Options - Advanced/Java and then untick the box that enables java in LibreOffice. If the program grumbles about it then you can always switch it back on the same way. Another possibility is the memory settings Tools - Options - Memory and just ramp everything up quite a lot. Maybe not the number of steps you can take back but the amount of ram per object and the total ram allowed for the whole document seem like good ones to increase! Regards from Tom :) Thanks for the reply Tom, reading your response has prompted me that there may be some pertinent information I had forgotten to include. Because the document is a work document in needed to leave it in word format, so I was trying to save it as a .docm document so that it could be used back at work. As Writer appeared not to be able to handle the document I opened the document in Word 2013 which handled the document quite happily. Another issue I had was the document had track changes activated without any changes in the document having been committed. This process seems to function differently in each of Word 2002, Word 2010 and Word 2013 and Writer didn't seem to be able to handle this functionality at all. Edit - Changes - Show is selected by default (I'm assuming this is Writer's equivalent of Track Changes, if it isn't then I can't find any support for that) but Writer did not show any of the changes that had been done, it displayed the document as if all the changes had been committed. For example, all the text that had been deleted, instead of showing the text with a line through them as Word does, Writer did not display the text at all. I have just done a test now with Writer using its native format, with Edit - Changes - Show / Record options selected and it seems to be recording changes by user albeit that it doesn't know who the user is (probably because I haven't specified that information in its configuration), but even though it is doing this recording if I delete any text I have typed in, it just removes the text rather than showing it as deleted. regards, Steve On 14 October 2014 23:44, Stephen Morris samor...@netspace.net.au wrote: Hi, I have a sensitive Architectural Design document created in Word 2010 that contains macros, hence it is a .docm file. I have opened this document in Writer 4.6.2.3 and whenever Writer autosaves or I manually save the save process crashes Writer. Is there anything I can look at to try to determine why? Because of the nature of the document it is not something that I can release. regards, Steve -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to- unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Writer 4.6.2.3 Failure With Word Document
Hi, I have a sensitive Architectural Design document created in Word 2010 that contains macros, hence it is a .docm file. I have opened this document in Writer 4.6.2.3 and whenever Writer autosaves or I manually save the save process crashes Writer. Is there anything I can look at to try to determine why? Because of the nature of the document it is not something that I can release. regards, Steve -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Development of Extensions for LibreOffice
On 03/19/2013 01:56 AM, Tom Davies wrote: Hi :) Thanks for the answer. I think the question was beyond the scope of the Users List and i don't know if anyone got around to pointing the person to the devs lists. Hi Tom, Michael did point me at the developers list and when I sent my last mail through I cced the developers list, but as yet I haven't had a response. Michael has provided me with some more info that should help with what I am trying to do. regards, Steve Err, was there a slight typo in the last paragraph? Seems like grep got typed as grok? which you can grok for user-visible strings Perhaps would have been more generic as look for? Regards from Tom :) From: Michael Meeks michael.me...@suse.com To: Stephen Morris samor...@netspace.net.au Cc: LibreOffice Users users@global.libreoffice.org; Kohei Yoshida kyosh...@novell.com; libreoff...@lists.freedesktop.org Sent: Monday, 18 March 2013, 11:54 Subject: Re: [libreoffice-users] Development of Extensions for LibreOffice Hi Stephen, On Mon, 2013-03-18 at 08:34 +1100, Stephen Morris wrote: I am having all sorts of problems with the source code in Eclipse. I have created a new blank C++ project in Eclipse and imported the entire sc directory into that project. Subsequently I have opened dpgroupdlg.cxx in the editor (I'm also not sure why Eclipse displays all directories duplicated) and Eclipse is displaying errors on just about every statement in that file. Well - that's really Eclipse' problem :-) can you turn off it's bogus error display ? I guess getting help with Eclipse would be a good thing to do. Potentially you don't want to create a project - but just use it to edit the specific files. I think the first thing I need to do is to find all the include files and add those directories into the include file path in the project properties. One of the problems I have is that the statement com::sun::star::sheet::DataPilotFieldGroupBy::SECONDS, is producing an error complaining that symbol SECONDS is not found. This is from an UNO / generated header. It seems highly unlikely that Eclipse is going to do a perfect job of building LibreOffice. As such, I would use it as a syntax-colouring text editor - not in it's all-seeing monster mode ;-) How I configure eclipse to consider the idl file to be the same as the hpp file so that these symbols get resolved? I have no idea. You need to edit the code with some sort of source code editor, Elipse is one option. If it can't control it's urges to try to understand the entire (apparently not built) code-base then I'd recommend using something else ;-) I am also having difficulty determining which dp module equates to the dialog that gets displayed for variables that are dragged to the pivot table layout areas, to specify the attributes of those variables. Is there any documentation anywhere that explains what each module within the suite actually does and how they relate to what is actually displayed by Libreoffice for each function it performs? Each module ? each top-level directory has README - patches to improve them appreciated. Sadly there is no further good structural documentation at all. In general - if you want to go from the UI - the source code, you need to go via the .src files - which you can grok for user-visible strings, and then look for the defined names of those in the .hrc files - which are shared between resources and C++ and hence into the relevant source code and down to a widget. Hope that helps :-) Michael. -- michael.me...@suse.com , Pseudo Engineer, itinerant idiot -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Development of Extensions for LibreOffice
On 03/18/2013 10:54 PM, Michael Meeks wrote: Hi Stephen, On Mon, 2013-03-18 at 08:34 +1100, Stephen Morris wrote: I am having all sorts of problems with the source code in Eclipse. I have created a new blank C++ project in Eclipse and imported the entire sc directory into that project. Subsequently I have opened dpgroupdlg.cxx in the editor (I'm also not sure why Eclipse displays all directories duplicated) and Eclipse is displaying errors on just about every statement in that file. Well - that's really Eclipse' problem :-) can you turn off it's bogus error display ? I guess getting help with Eclipse would be a good thing to do. Potentially you don't want to create a project - but just use it to edit the specific files. I think what has caused my problem is that I am using the JEE version of Eclipse that I have added the C/C++ project to, and the JEE version has project auto build active by default, which is the only way java development should be done (in my opinion) as when you get these sorts of statement errors for standard java processes one of the solutions provided is for Eclipse to add the necessary include file into the code to resolve the issue (admittedly this won't work for user defined processes). I can turn off the auto build functionality. I think the first thing I need to do is to find all the include files and add those directories into the include file path in the project properties. One of the problems I have is that the statement com::sun::star::sheet::DataPilotFieldGroupBy::SECONDS, is producing an error complaining that symbol SECONDS is not found. This is from an UNO / generated header. It seems highly unlikely that Eclipse is going to do a perfect job of building LibreOffice. As such, I would use it as a syntax-colouring text editor - not in it's all-seeing monster mode ;-) I may be approaching this process from the wrong angle, but from my perspective I ideally need to create a project containing all the modules that make up calc, so that when I change the source code I can compile it and then run unit tests on the pivot processes and system tests on the entire calc program to make sure I haven't adversely impacted anything else in the application, particularly if I can implement the menu entry to allow formatting of pivot variables post pivot table creation. The easiest way to implement this is to create a project and then build the project which will then create the program. How I configure eclipse to consider the idl file to be the same as the hpp file so that these symbols get resolved? I have no idea. You need to edit the code with some sort of source code editor, Elipse is one option. If it can't control it's urges to try to understand the entire (apparently not built) code-base then I'd recommend using something else ;-) The only other editor I use occasionally is Netbeans but it does the same thing. I am also having difficulty determining which dp module equates to the dialog that gets displayed for variables that are dragged to the pivot table layout areas, to specify the attributes of those variables. Is there any documentation anywhere that explains what each module within the suite actually does and how they relate to what is actually displayed by Libreoffice for each function it performs? Each module ? each top-level directory has README - patches to improve them appreciated. Sadly there is no further good structural documentation at all. In general - if you want to go from the UI - the source code, you need to go via the .src files - which you can grok for user-visible strings, and then look for the defined names of those in the .hrc files - which are shared between resources and C++ and hence into the relevant source code and down to a widget. I'll check these out and see if I can understand these first to try to work out how each of the modules interact with each other amalgamate to produce the entire calc application. regards, Steve Hope that helps :-) Michael. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Development of Extensions for LibreOffice
On 02/13/2013 09:01 PM, Michael Meeks wrote: Hi Stephen, On Wed, 2013-02-13 at 07:59 +1100, Stephen Morris wrote: Out of interest do you have a bug or two you want to hack on there ? the Pivot table code is in: sc/source/ui/dbgui/dpgroupdlg.cxx One of the issues I have with pivot tables in calc is that calc won't allow input variables to be renamed at pivot table creation time, it only allows renaming variables after table creation by editing the data in the header cells. Calc also doesn't allow renaming of variables in the page section of the pivot table. Calc doesn't allow the specification of formats for the variables being added at creation time, or at a later date via the menus as excel does, Calc only provides the ability to do it after creation of the table by applying formats to the cells in the table, hence if cells are re-arranged the formatting gets out of whack, and if the source data changes such that more rows are added on refresh, the additional rows won't have the format applied. Oh - interesting. So the formats thing sounds like a useful core feature you'd want to add to the pivot rendering; and the other bits are UI features. Certainly you'd be most welcome to work on this - Kohei is prolly the best contact here. The first thing to do is to get a build: http://www.libreoffice.org/developers-2/ When you have a working build of master, then we can get going with some more code reading pointers, How does that sound ? in general it's great to include the developers list too (no subscription required) just CC libreoffice-dev libreoff...@lists.freedesktop.org All the best, Michael. Hi, I am having all sorts of problems with the source code in Eclipse. I have created a new blank C++ project in Eclipse and imported the entire sc directory into that project. Subsequently I have opened dpgroupdlg.cxx in the editor (I'm also not sure why Eclipse displays all directories duplicated) and Eclipse is displaying errors on just about every statement in that file. I think the first thing I need to do is to find all the include files and add those directories into the include file path in the project properties. One of the problems I have is that the statement com::sun::star::sheet::DataPilotFieldGroupBy::SECONDS, is producing an error complaining that symbol SECONDS is not found. In the include list there is an include of com/sun/star/sheet/DataPilotFieldGroupBy.hpp and I have found a directory of that name in the offapi subdirectory of libreoffice, but that path does not contain DataPilotFieldGroupBy.hpp it contains instead DataPilotFiedlGroupBy.idl which contains a definition of SECONDS and the other time symbols specific in the code. How I configure eclipse to consider the idl file to be the same as the hpp file so that these symbols get resolved? I am also having difficulty determining which dp module equates to the dialog that gets displayed for variables that are dragged to the pivot table layout areas, to specify the attributes of those variables. Is there any documentation anywhere that explains what each module within the suite actually does and how they relate to what is actually displayed by Libreoffice for each function it performs? regards, Steve -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Development of Extensions for LibreOffice
On 02/13/2013 09:01 PM, Michael Meeks wrote: Hi Stephen, On Wed, 2013-02-13 at 07:59 +1100, Stephen Morris wrote: Out of interest do you have a bug or two you want to hack on there ? the Pivot table code is in: sc/source/ui/dbgui/dpgroupdlg.cxx One of the issues I have with pivot tables in calc is that calc won't allow input variables to be renamed at pivot table creation time, it only allows renaming variables after table creation by editing the data in the header cells. Calc also doesn't allow renaming of variables in the page section of the pivot table. Calc doesn't allow the specification of formats for the variables being added at creation time, or at a later date via the menus as excel does, Calc only provides the ability to do it after creation of the table by applying formats to the cells in the table, hence if cells are re-arranged the formatting gets out of whack, and if the source data changes such that more rows are added on refresh, the additional rows won't have the format applied. Oh - interesting. So the formats thing sounds like a useful core feature you'd want to add to the pivot rendering; and the other bits are UI features. Certainly you'd be most welcome to work on this - Kohei is prolly the best contact here. The first thing to do is to get a build: http://www.libreoffice.org/developers-2/ When you have a working build of master, then we can get going with some more code reading pointers, How does that sound ? in general it's great to include the developers list too (no subscription required) just CC libreoffice-dev libreoff...@lists.freedesktop.org All the best, Michael. Hi Michael, That sounds great. I will probably need help when writing and designing the solution, as having not looked at the source code before I'm not sure how easy it will be to write it platform independent. Also, what I'm not sure about, which is more critical, is that if implement the functionality in a similar way to excel, am I breaching Microsoft copywrite and patents? regards, Steve -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Development of Extensions for LibreOffice
On 02/06/2013 04:56 AM, Michael Meeks wrote: Hi Stephen, On Mon, 2013-02-04 at 06:57 +1100, Stephen Morris wrote: I have Eclipse with the OpenOffice plugin to enable development of extensions for Libreoffice. Can someone tell where I can get documentation on the Libreoffice Calc internals and how to interface specifically to things like the Pivot Table dialogue so that it can be extended. I want to work around the fact that Pivot Tables in Calc 3.6.5 are functionally not equivalent to Excel 2002 let alone Excel 2010? Oh - that's bad :-) I was also thinking of developing these extensions in Java, are there any issues with doing so? Well - if you develop this in Java then it's unlikely to get into the code code. Also - you'll have a rather grim time trying to get everything you want, and (I suspect) you'll find embedding into arbitrary dialogs is not really easy at all. So - I -strongly- recommend just checking out the code, compiling it and poking the developers list for some code pointers to that dialog. Adding the features you need to the core, so everyone can enjoy them out of the box is almost certainly the best way to achieve your goals - and (after all) C++ is not so distantly related to Java :-) Hi Michael, I have already downloaded to source code and had considered modifying the code directly, but thought and extension might be easier and simpler, but if writing an extension means that it won't be guaranteed of making the product then modifying the code is the better way to go. I haven't looked at C++ in a long time but it shouldn't be that difficult to pick up again, and it should be easy to get the code suite into my Eclipse development environment once I update it for C++. I'm also running out of time for relating Calc's compatibility to Excel 2002 as in April/May the organisation I work for is upgrading to 2010, so I may just have to develop for compatibilty with that. I have 2010 installed on this machine at home, but it is running under Windows and I'll be doing my development work under Linux, and last time I looked Office 2010 doesn't run under Wine nor CrossOver Office. regards, Steve Does that make sense ? Thanks ! Michael. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: LibreOffice 4.0
On 02/05/2013 11:53 PM, Tom Davies wrote: Hi :) On the other hand MS Office still does not support many features of LibreOffice yet either. Plus a LOT of the functionality of MS Office depends on you buying the 'right' bundle and then buying extra apps on top of whatever is included in the bundle. For example the Student's version of MSO doesn't include Publisher or Access. Plus their default formats rely on everyone using the same version and the same OS as the person that created the document and only really works on desktop machines. Plus all the security issues that MS documents and the app has suffered from over the years are almost entirely avoided by Libreoffice and all the other OpenSource office programs. Will MSO ever catch up on security or cross-platform compatibility? Regards from Tom :) Microsoft may catch up on cross platform compatibility if they release Office for Linux as has been rumored, plus the fact that they have their development fingers in the Linux Kernel and KDE should assist with that, particularly if Microsoft want to realize their dream of taking over the world. As far as security is concerned, that will never happen. They don't have the reputation of Microsoft and Security don't go together for nothing, plus they continually demonstrate that they don't understand the basics of security. regards, Steve From: Urmas davian...@gmail.com To: users@global.libreoffice.org Sent: Tuesday, 5 February 2013, 13:42 Subject: [libreoffice-users] Re: LibreOffice 4.0 Chad Homan cho...@gmail.com: My question is, is LO 4.0 suppose to be the release that supports 120% of MSO97. Not yet, it does not support 100% of MS Word 2.0 (from 1992) yet. Of course it has some bells and whistles and even a couple of useful features, but still no cigar. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Development of Extensions for LibreOffice
On 02/04/2013 06:57 AM, Stephen Morris wrote: Hi, I have Eclipse with the OpenOffice plugin to enable development of extensions for Libreoffice. Can someone tell where I can get documentation on the Libreoffice Calc internals and how to interface specifically to things like the Pivot Table dialogue so that it can be extended. I want to work around the fact that Pivot Tables in Calc 3.6.5 are functionally not equivalent to Excel 2002 let alone Excel 2010? I was also thinking of developing these extensions in Java, are there any issues with doing so? regards, Steve Thankyou for the input guys. I'll search the wiki for information on the internals and hope that its not openoffice specific. I guess given the direction that Libreoffice is heading I'll have to search the internet for documentation and tutorials to learn python. regards, Steve -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Development of Extensions for LibreOffice
Hi, I have Eclipse with the OpenOffice plugin to enable development of extensions for Libreoffice. Can someone tell where I can get documentation on the Libreoffice Calc internals and how to interface specifically to things like the Pivot Table dialogue so that it can be extended. I want to work around the fact that Pivot Tables in Calc 3.6.5 are functionally not equivalent to Excel 2002 let alone Excel 2010? I was also thinking of developing these extensions in Java, are there any issues with doing so? regards, Steve -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
