color of recorded changes
How does one determine / change the color used when recording changes to a writer document? I'm working with a .docx from ms word, which I will export as a .odt. When I turn on Edit/Changes/Record the color used (there are no others in the document) is a very difficult to see light tan/yellow. Is there a way to assign the color used by author? Thanks, Gary - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Fwd: Undelivered Mail Returned to Sender
On 12/10/12 03:47, Martin Groenescheij wrote: I send the reply to your email address because the reply to users@openoffice.apache.org bounced. users@openoffice.apache.org: host mx1.eu.apache.org[192.87.106.230] said: 552 spam score (5.7) exceeded threshold (HTML_MESSAGE,MIME_HTML_ONLY,SPF_PASS (in reply to end of DATA command) Shame on spam-assassin or whatever it is :-) Thank you! That helps a lot, and I can modify the wrapping options to work for this document. However, I am puzzled because of the following: 1. If Frame3 is moved to the right so there is whitespace between it and Frame4, the text begins on a line even with the top of Frame3 and Frame4, and fills the whitespace between the two frames and the space immediately below Frame4. However, as it stands with Frame3 overlapping Frame4, it does not fill the space immediately below Frame4. Why not? Wrapping Optimal for Frame3 doesn't allow text to the left of the Frame If you change the wrapping for Frame3 from Optimal to Parallel you will see that it fill the gaps. If I change Frame3 to use Before wrapping, and leave Frame4 at Optimal, it does not fill in the space under Frame4. I can get that space to fill by changing Frame4 to use None. But why doesn't option After or Optimal or Parallel also work for Frame4? Just because it can't fill anything to the right because it is physically blocked by the box on the right (that is different from the box on the right forbidding text to its left) doesn't mean it should refuse to use the rest of the space which is actually available. Indeed, the Parallel option fills the space to the left of Frame4, but not the space below, even if Frame3 is set to Before. If Frame3 is set to Before and Frame4 is set to Parallel, why does it fill the space to the left of Frame4 but not the space below it? In this case all three frames say it is ok to put text below Frame4, and Frame2 and Frame4 say it is ok to put text to the left of Frame4, and in both cases Frame4 cannot put text to its right because Frame3 is in the way. But it puts text to the left and not below. As you describe it for Frame3, Optimal is behaving the same as After, allowing no text to its left. How is Optimal different from After? According to the 3.3 documents Optimal only prevents text to its side if there is less than 2cm available space, and in this case there is more than that. 3. Why doesn't paragraph 3 start in the empty space below Frame9? This may be the same as the last part of #2, but originally there was another box in the lower left corner of the page, and I wanted the text to begin in the space between it and Frame8, immediately below Frame9. Frame8 prevent text on the left (Optimal wrapping) Again, just because it can't fill on the right because it's physically blocked doesn't mean it should not use the rest of the space it is allowed to use. In general, wrapping should use all of the space it is allowed to use, unless some other object specifically prevents it from doing so. Again, what is the difference between Optimal and After if it's not the 2cm rule? Given the pictures of wrapping options in the Frame/Wrap dialog and the descriptions of the wrap options in the documentation, what are the rules to determine whether or not a space is filled? Which of the following statements (if any) are true: 1. In order to fill a space, the wrap options of all surrounding frames must specifically allow text in the space. 2. In order to fill a space, the wrap option of any one of the surrounding frames must specifically allow text in the space. 3. Something else?? Again, I can now see how to get what I want in any particular document by trying different wrap options, but it is not at all clear to me what the algorithm is. Is is also not clear to me what the difference between the After and Optimal options are, since the 2cm rule is not being applied. 5. If I move Frame10 up to where its anchor shifts to paragraph 3 and release the mouse, the frame jumps up to page 1, and its anchor point shifts to the left margin below paragraph 2. Why doesn't it stay anchored to paragraph 3, and why doesn't it stay where I dropped it? You should check values in the Frame window when you move Frames, this way you can see what the impact is. Thanks. In general: if you want the position of your Frames fixed anchor them to Page while setting the position From left to Entire page or Page text area and From Top to to Entire page or Page text area. If you want them to flow with the paragraph anchor them to the paragraph or character. Because you have mixed settings for different Frames you got unpredictable results. But there is only one frame of interest here, and it is being anchored to one of two paragraphs, both of which are on the same page, page2. There is nothing else on page2. If I set Frame10's Position on the Type tab to:
Re: My machine is French but I want OpenOffice in English. Why do you chose for me, why can't I select what I want? eom
On 02/04/13 13:40, Hagar Delest wrote: Le 04/02/2013 21:15, Gary Aitken a écrit : Is there a reason one can't have one version with multiple languages on a machine, so one user can use, for example, Spanish, another French, and a third English? Is the i18n stuff not configured at runtime? What do you mean? The language packs do just that. good, I thought that was the case. I thought the answer to the OP was that he had to download a different version of aoo. Perhaps he should have been told that if he was downloading for the first time and only wanted to use a single language, he should select a particular language; but if he wanted to add another he could just add the language pack he wanted. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: line break in multi-line input box
On 08/15/13 15:09, Andrew Douglas Pitonyak wrote: Did you try Shift+Enter? I ask because there is at least one control that used to use Ctrl+Enter for a new line that now requires Shift+Enter. Yes, I tried it. But no, it doesn't work either. shiftEnter backs up one tab alt and ctl do the same as the un-modulated enter, going to the next record. On 08/15/2013 02:16 PM, Gary Aitken wrote: Can anyone tell me how to insert a line break in a multi-line input form? In this case it's a front end for a database, and the field is a blob in a mysql db. Under ms access it was ctrlenter, but that is bound to moving to the next record. Thanks, Gary - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
scripts in AOO spreadsheets interpreted by MS excel?
It's my understanding the AOO document format for writer is a recognized standard; and I know they are readable by ms word. Is this also the case for the spreadsheet (calc) documents? Are they readable by MS excel? If so, are scripts (Java) also generally properly interpreted by MS excel? Thanks, Gary - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: scripts in AOO spreadsheets interpreted by MS excel?
On 09/01/13 09:56, Regina Henschel wrote: snip Is this also the case for the spreadsheet (calc) documents? Are they readable by MS excel? It depends on the version of Microsoft Office. They started lately to support ODF in Excel. Before MS 2007 you need a plugin. For MS 2007 itself I'm not sure. MS 2010 can read .ods files which are written using ODF1.1. But that format has no standard for formulas. MS 2007 does not read formulas, but only the stored values. It can read files written using ODF1.2 as well, although it complains, that the file is broken and needs to be repaired. MS 2013 can read .ods files using ODF1.2 including the formulas. Microsoft has a webpage, which gives an overview, what parts of ODF1.2 are not supported. Search for ODF 1.2 on site:microsoft.com should give you relevant results. Thanks, that's a help. If so, are scripts (Java) also generally properly interpreted by MS excel? I don't know and cannot test it. But it is unlikely, because the macros in Apache OpenOffice do not base on the file format (what the standard is about). But macros are based on the UNO framework. And UNO is based on data and methods of the internal representations, not on file format. The file format does not have methods at all, but only elements and attributes. If macros are involved, wouldn't the file format for the cell require specifying the macro binding, which would imply describing the language bindings to some extent, at least down to the procedure call level? That would imply if there were a java binding, at least one would know the procedure SpreadsheetCell::click(row, col) or something like that was specified, and the back-end would need to support it. But shouldn't a question about the ability of Excel be ask on a Microsoft forum? My assumption was that most people on an MS forum are not interested in interoperability, whereas a substantial percentage of those on this forum probably are of necessity. My apologies if it's inappropriate. I'm probably out of luck. I have a spreadsheet with an MS basic backend and I was hoping to rewrite it so I could run and distribute it in AOO even to those folks who can't / won't change because their institutions run M$. Thanks, Gary - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: scripts in AOO spreadsheets interpreted by MS excel?
On 09/01/13 22:57, Andrew Douglas Pitonyak wrote: On 09/01/2013 11:23 AM, Gary Aitken wrote: Is this also the case for the spreadsheet (calc) documents? Are they readable by MS excel? If so, are scripts (Java) also generally properly interpreted by MS excel? I was not aware that you could script Excel in Java. Do you mean control Excel in Java, or literally embed a Java Script that is runnable in Excel? I meant provide more complex code to be executed when various events occur in the spreadsheet. That code needs to have access to and the ability to modify other parts of the spreadsheet as well as maintain global state. None of this has to interact with any complex back end; it's just complex calculations for other (display-only) parts of the spreadsheet. I thought MS had bindings for things besides VB for excel; and was hoping there was some alignment between those and OO. It appears I was wrong on both counts. But I also thought I could use VB callbacks to call into a java back end to get around no java bindings. However, something like Obba may make what I need to do possible, although it's not obvious if it has a framework for also modifying the spreadsheet contents from the jvm. Gary - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: sending resume using open office
On 01/10/14 04:13, e-letter wrote: On 10/01/2014, users-digest-h...@openoffice.apache.org users-digest-h...@openoffice.apache.org wrote: jcish...@suddenlink.net wrote: To whom it may concern, My name is John, I have been using open office for some time now and fine it as good or better than windows office. I have a problem with AOO, every time I send a resume to a potential employer, it always comes back. What is the problem I am having ? I always need to move to the laptop, where I have saved Word for this occasion and then send the document. Please tell me what the answer to this problem is. I can not find Jcishome; Most employers in the United States want resumes in either Microsoft Word or PDF format. If you are sending an Open Document Test (.odt) file from OpenOffice Writer this is probably the problem. OpenOffice can save in Word's .doc format or even better It can email your resume as a .doc file but still save it in the default .odt format. Whenever possible, you should take the opportunity to use the native odt and not continue the proliferation of m$ formats. In this simple case of a CV, the document can be sent in PDF using the existing function of OO to create PDF files. If a editable version is requested, the recipient will be able to see an odt file if and odf-compliant software is used, such as the latest versions of m$office; there is a comparison of differences between formats. See: https://www.mail-archive.com/users@global.libreoffice.org/msg35626.html When dealing with organizations which I know or suspect use word, I make it a habit of prefixing the mail with something like: The attached doc is in open document format (odt), a world standard for word-processing documents. If you have trouble opening it, please let me know. Newer versions of microsoft word automatically deal with it, but older versions can be updated to allow reading current versions of their own (microsoft) documents as well as world standard documents. But as you point out, a pdf gets around that. If it has to be editable, there is a free add-on for older ms-word which allows reading odt, so even people using old versions of word should be able to read an odt. It's the same add-on that allows reading .docx stuff, I believe. Thank you, all the countries in Europe which forced that issue. Gary - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
duplex pages upside down
I'm not sure what caused this, as I haven't printed any duplex pages for a while, but now the back side of double-sided pages is printing upside down. The printer is an hp officejet pro 8500. I'm on a freebsd (*nix) system, using gutenprint/cups as the print driver. If I look at the page preview, the second sheet is properly oriented. Anyone have any ideas? --- List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: duplex pages upside down
On 01/25/14 15:59, Maurice Howe wrote: When you use short edge is there an apply tab or anything like that? No. It's a dropdown, so it shows up once the menu is clicked; then an OK to dismiss the whole dialog, then a Print to actually set the process in motion from the main print dialog. Wish I could at least figure out whether it was the driver or AOO, as it was working a few weeks ago. Unfortunately, I don't have another printer that has duplex capability. I suspect it's the driver, but I'll be danged if I can figure out what's wrong with it. On Sat, 25 Jan 2014 14:48:38 -0700 Gary Aitken I'm not sure what caused this, as I haven't printed any duplex pages for a while, but now the back side of double-sided pages is printing upside down. The printer is an hp officejet pro 8500. I'm on a freebsd (*nix) system, using gutenprint/cups as the print driver. If I look at the page preview, the second sheet is properly oriented. Anyone have any ideas? Change the flip option from 'long edge' to 'short edge' or cohtrariwise. --- List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Recent documents
On 01/25/14 19:02, Julian Thomas wrote: On 25 Jan 2014, at 16:52, Dave Barton d...@tasit.net wrote: Yes, it can be done manually by editing some configuration files, but it is much easier and convenient to use one of the available extensions. My own preference is the History Master extension: http://extensions.openoffice.org/en/project/history-master Downloaded and installed, but how do I get it to show more than the last 10 files? Go to Tools/AddOns... --- List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: duplex pages upside down
On 01/26/14 06:00, Regina Henschel wrote: Gary Aitken schrieb: On 01/25/14 15:59, Maurice Howe wrote: When you use short edge is there an apply tab or anything like that? No. It's a dropdown, so it shows up once the menu is clicked; then an OK to dismiss the whole dialog, then a Print to actually set the process in motion from the main print dialog. Wish I could at least figure out whether it was the driver or AOO, as it was working a few weeks ago. Unfortunately, I don't have another printer that has duplex capability. I suspect it's the driver, but I'll be danged if I can figure out what's wrong with it. Isn't there a setting in the driver or in the operating system to print raw data? No. The only thing that looks like it could be raw output is the choice in the properties subdialog of the print dialog called Printer Language Type which allows selection of pdf (the default) and several levels of postscript, one of which is labelled from driver which I assume means use the driver says it likes ps. How does OO do printing? Does it produce a pdf and then hand that off? If so, then presumably the print to file option for pdf is the exact output that would be fed to the print mechanism? When sending to the printer I have the option of different varieties of postscript as well as pdf (default), but print to file only shows pdf so I assume that's what oo produces? If I print to file and generate a pdf, it looks ok, but of course it is page-by-page without any duplexing operating. It is behaving as if there is a %%Requirements: duplex (tumble) command in the postscript file. I suspect the problem is in the print system, not oo, but it would be nice to get the output from OO right before it goes to the print mechanism, and then also know what the cmd is that it's using to send to the print spooler. Thanks for any insights, Gary --- List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: duplex pages upside down
On 01/26/14 16:36, Regina Henschel wrote: Hi Gary, Gary Aitken schrieb: On 01/26/14 06:00, Regina Henschel wrote: Gary Aitken schrieb: On 01/25/14 15:59, Maurice Howe wrote: When you use short edge is there an apply tab or anything like that? No. It's a dropdown, so it shows up once the menu is clicked; then an OK to dismiss the whole dialog, then a Print to actually set the process in motion from the main print dialog. Wish I could at least figure out whether it was the driver or AOO, as it was working a few weeks ago. Unfortunately, I don't have another printer that has duplex capability. I suspect it's the driver, but I'll be danged if I can figure out what's wrong with it. Isn't there a setting in the driver or in the operating system to print raw data? No. The only thing that looks like it could be raw output is the choice in the properties subdialog of the print dialog called Printer Language Type which allows selection of pdf (the default) and several levels of postscript, one of which is labelled from driver which I assume means use the driver says it likes ps. So why not try it out? Already did that quite a while ago. What information do you see in Cups? I've got a HP ColorLaserJet (which understands postscript) and see: Defaults: job-sheets=none, none media=iso_a4210x297mm sides=two-sided-long-edge Not sure what you mean by in cups, but if you are referring to the subdialog of the print dialog that comes up when I hit Print..., (i.e. the properties dialog from the Properties... button, Paper Tab: paper size orientation duplex (off, long edge (standard), short edge (flip)) Device Tab: Color Model Color Precision Media Type Print Quality Resolution Shrink Page If Necessary to Fit Borders and a whole bunch more which are color-correction related I've tried both duplex options, and they have the same effect (upside-down) I'm a Linux novice and can not really help you. Isn't there a freebsd forum? yes, and I'm pursuing that avenue also. But in order to do that, I need to know what the heck AOO does when it goes to print. I need to know how the system print mechanism is triggered from AOO, and what it is being fed. Otherwise, it's not clear where to look. after some more experiments Cups installs its own lpr command. On fbsd that is in /usr/local/bin; the system still has one in /usr/bin. Depending on the order in one's path, you get either the cups one or the system one -- unless a full path is specified. That's not particularly a good situation, but I don't think that's the problem; I think cups uses a full path (don't know if aoo does or not, or if it's even relevant, as I don't know how aoo interfaces to cups). If you take a proper .ps file set up for duplexing (below) and print it with the system lpr command, page 2 comes out right-side up. If you print it using the cups lpr command, page 2 comes out upside-down. If you take a 2 page OO document and print it duplexed via cups, it comes out upside down. If you first print it duplexed to a pdf file, and then: Using the system lpr command, it prints on two separate sheets. Using the cups lpr command, it prints duplexed upside down. That looks like there is something wrong with the cups lpr command. I'd be curious if anyone else sees the same behavior. more experiments If I move the cups lpr command out of the way and replace it with a symbolic link to /usr/bin/lpr, I still see the same behavior when printing from aoo. Which would imply that aoo is not using the lpr command to print. In the meantime, I'll go looking for some cups help. == duplex.ps == %!PS-Adobe-3.0 %cupsJobTicket: media=Letter sides=two-sided-long-edge %%BoundingBox: 36 36 576 756 %%Pages: 2 %%LanguageLevel: 2 %%Requirements: duplex %%DocumentNeededResources: font Times-Roman %%EndComments %%BeginDefaults %%PageOrientation: Portrait 0.0 setgray /Times-Roman findfont 24 scalefont setfont %%EndDefaults %%BeginSetup %%BeginFeature: *Duplex DuplexNoTumble /Duplex true /Tumble false setpagedevice %%EndFeature %%EndSetup %%Page: (Front Page (1)) 1 % Page 1 text newpath 100 100 moveto (Page 1 Duplex.ps) show showpage %%Page: (Back Page (2)) 2 % Page 2 text newpath 100 100 moveto (Page 2 Duplex.ps) show showpage %%EOF % --- List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: calc reference relative to named range
On 02/16/15 02:46, Josiane (telenet) wrote: I think I know why you want to name a column. Do you know that there is a handling that you can do to have an entire column do a formula? If you make a formula in C1. For example =B1-A1 Then you can make sure that this formula is made in the entire column without typing it in every cell. There is a point right below the cell (if it is selected) (see the attachment). If you set the cursor on that point, then you can pull this below. And all the cells below C1 will get this formula. If you do that then you will not need to name a column. Thanks, I'm aware of that. As stated below, the purpose in naming the column is not to allow some operation that is not otherwise possible; it's to make the entire spreadsheet more manageable, particularly over time, when one has difficulty remembering what a formula actually means. Op Mon, 16 Feb 2015 08:35:34 +0100 schreef Brian Barker b.m.bar...@btinternet.com: At 22:20 15/02/2015 -0700, Gary Aitken wrote: I can't find how to do this in the docs; not even sure it's possible but seems like it should be. Assume column A is named foo (select column, insert/name/define). In column B I can use the corresponding element in the same row in A in a formula by using its name, e.g. =foo*3 Is there a way to reference a cell in column foo (A) relative to the row in which the formula is being defined? What I want to do is subtract the previous row value from the current row one: =foo - [foo-1] How do I say that? =foo-INDEX(foo;ROW()-1) Mind you, I'm not at all sure why you would want to do this. Column A already has a perfectly serviceable name: A! Why not have in B2 just =A2-A1 and so on? Named ranges have their uses, such as referring to a table of values elsewhere in a document, but I don't think this is one. If you do want your foo column elsewhere, you could construct a parallel column of differences there too and then name that range instead (or as well). - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: calc reference relative to named range
On 02/16/15 00:35, Brian Barker wrote: At 22:20 15/02/2015 -0700, Gary Aitken wrote: I can't find how to do this in the docs; not even sure it's possible but seems like it should be. Assume column A is named foo (select column, insert/name/define). In column B I can use the corresponding element in the same row in A in a formula by using its name, e.g. =foo*3 Is there a way to reference a cell in column foo (A) relative to the row in which the formula is being defined? What I want to do is subtract the previous row value from the current row one: =foo - [foo-1] How do I say that? =foo-INDEX(foo;ROW()-1) Thanks; that was what I needed. Mind you, I'm not at all sure why you would want to do this. Column A already has a perfectly serviceable name: A! Why not have in B2 just =A2-A1 and so on? Because formulas are much more meaningful when the names used in them have some link to the reality they represent. NetUse = NetDeliveredToUs - NetFedToGrid makes much more sense than G2 = E2 - F2 In the example above, NetDeliveredToUs = KWHDeliveredToUs - INDEX(KWHDeliveredToUS;ROW()-1) Gary - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
calc reference relative to named range
Hi all, I can't find how to do this in the docs; not even sure it's possible but seems like it should be. Assume column A is named foo (select column, insert/name/define) In column B I can use the corresponding element in the same row in A in a formula by using its name, e.g. =foo*3 Is there a way to reference a cell in column foo (A) relative to the row in which the formula is being defined? What I want to do is subtract the previous row value from the current row one: =foo - [foo-1] How do I say that? Thanks, Gary - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
After Safe and restart, Editing Calc Chart loses data
Running aoo 4.1.1 on fbsd If I create a chart in calc, as long as I do not exit calc I can edit the chart. In addition, if the values on which the chart is based change, the chart changes. However, if I save the spreadsheet and exit calc, then run calc again and open the spreadsheet, things are screwed up. When first reopened, the chart looks fine. However, modifying data values no longer cause the chart to change, and when I double click on the chart to edit it all of the data in the chart disappears, as well as the axis labels which are based on the data. This is an unrecoverable error -- there's no way to undo the double click to get the data display in the chart back. Is this a known behavior? Is there something one can do to preserve the dynamic aspects of a chart? Thanks, Gary - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: After Save and restart, Editing Calc Chart loses data
Hi Brian, Thanks for the reply. Anyone, please give me a sanity check on this one. On 08/25/15 02:03, Brian Barker wrote: You don't seem to have had any replies to this message. At 13:15 23/08/2015 -0600, you wrote: If I create a chart in calc, as long as I do not exit calc I can edit the chart. In addition, if the values on which the chart is based change, the chart changes. However, if I save the spreadsheet and exit calc, then run calc again and open the spreadsheet, things are screwed up. When first reopened, the chart looks fine. However, modifying data values no longer cause the chart to change, and when I double click on the chart to edit it all of the data in the chart disappears, as well as the axis labels which are based on the data. This is an unrecoverable error -- there's no way to undo the double click to get the data display in the chart back. Is this a known behavior? Clearly not. Is there something one can do to preserve the dynamic aspects of a chart? They normally are, of course. The fact that no-one has replied suggests that no-one has any idea what is wrong. Can you create a small example file showing your problem and post it somewhere for people to see? Or send it to someone to look at? File is in http://www.dreamchaser.org/garya/downloads/ChartDataBug_3.ods Load it and follow the instructions. Thanks, Gary - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: After Save and restart, Editing Calc Chart loses data
On 08/25/15 20:48, Brian Barker wrote: At 07:56 25/08/2015 -0600, Gary Aitken wrote: At 13:15 23/08/2015 -0600, Gary Aitken wrote: If I create a chart in calc, as long as I do not exit calc I can edit the chart. In addition, if the values on which the chart is based change, the chart changes. However, if I save the spreadsheet and exit calc, then run calc again and open the spreadsheet, things are screwed up. When first reopened, the chart looks fine. However, modifying data values no longer cause the chart to change, and when I double click on the chart to edit it all of the data in the chart disappears, as well as the axis labels which are based on the data. This is an unrecoverable error -- there's no way to undo the double click to get the data display in the chart back. Is this a known behavior? Is there something one can do to preserve the dynamic aspects of a chart? Anyone, please give me a sanity check on this one. File is in http://www.dreamchaser.org/garya/downloads/ChartDataBug_3.ods Load it and follow the instructions. The document file certainly has a problem, but it behaves differently on my 4.1.1 on Windows XP: o The chart displays correctly when the document is opened. I see that behavior here. o I can select the chart so as to display the eight coloured handles - and can move it. When I move it, the three data points disappear on button release. o But I cannot select it using double-click so as to be able to edit it. Double click selects for editing here but data disappears. o Modifications to the chart data are indeed not reflected in the chart. same. I presume this is the case immediately after opening the file and before attempting to select the chart? But (crucially): o I can create a new chart successfully in the same document, which behaves correctly - even when the document is saved and reopened. I can create a new chart in the same document and it works fine, but not after saving and restoring. o Did you create this from a blank document or perhaps from some earlier original (that may have had problems)? It was created using the steps indicated in the file, from an empty new document. Typed in the two rows at the top, then did the steps listed below them. o Can you reproduce the problem in a new document? Very reliably. That's how the sample was generated (see previous answer) o Is there a problem with your template? Using the default empty spreadsheet when calc opens If you have set an alternative template, go to File | Templates | Organise... . Click Commands; if you see Reset Default Template , click it and select Spreadsheet. In a new document, does that make a difference? There is no menu entry for Reset Default Template; I haven't changed it. I trust this helps. I wish :-) So, just for grins, can you create a similar document on xp and let me see what happens here (fbsd)? Do you know if saving an unmodified calc file should be identical to the original? Especially if saved on a *nix system when created on a windows system? It's a binary format so there's a chance they should be the same. In which case I'd be curious to know if saving an xp generated file from *nix and reloading exhibits the problem. If so, that might finger a binary write issue. Gary - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: After Save and restart, Editing Calc Chart loses data
On 08/25/15 11:05, Joe Conner wrote: With my Ubuntu64 I open the file, and if I choose the graph and attempt to reposition it the data disappears. This too is odd. Thanks Joe. My sys is fbsd amd 64 so that's two different ones. I just filed a bug, 126490 On 08/25/2015 06:56 AM, Gary Aitken wrote: Hi Brian, Thanks for the reply. Anyone, please give me a sanity check on this one. On 08/25/15 02:03, Brian Barker wrote: You don't seem to have had any replies to this message. At 13:15 23/08/2015 -0600, you wrote: If I create a chart in calc, as long as I do not exit calc I can edit the chart. In addition, if the values on which the chart is based change, the chart changes. However, if I save the spreadsheet and exit calc, then run calc again and open the spreadsheet, things are screwed up. When first reopened, the chart looks fine. However, modifying data values no longer cause the chart to change, and when I double click on the chart to edit it all of the data in the chart disappears, as well as the axis labels which are based on the data. This is an unrecoverable error -- there's no way to undo the double click to get the data display in the chart back. Is this a known behavior? Clearly not. Is there something one can do to preserve the dynamic aspects of a chart? They normally are, of course. The fact that no-one has replied suggests that no-one has any idea what is wrong. Can you create a small example file showing your problem and post it somewhere for people to see? Or send it to someone to look at? File is in http://www.dreamchaser.org/garya/downloads/ChartDataBug_3.ods Load it and follow the instructions. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: location of icons
On 10/11/16 13:36, Girvin R. Herr wrote: > I have Slackware Linux, not freebsd, but on my system the icons are > cached and there is a program called /usr/bin/gtk-update-icon-cache, > which is supposed to update the cache when new icons are stored in > /usr/(local/)share/icons/hicolor. I have a manpage on it, so you > could try it to see if you have it. When I install AOO, my > installation script does this caching and I have no problems with the > icons in xfce4. It is also possible that xfce4 is expecting the > icons to be in /usr/share/icons rather than /usr/local/share/icons. > I have had such problems with other programs in the past. excellent, that did it. Thanks > Note: xfce4 expects the desktop files (*.desktop) to be +x, otherwise > I get a popup about the file being untrusted. It allows you to > bypass the popup, but it is annoying. I set the desktop files in > /opt/openoffice4/share/xdg/ to +x to resolve this. Misusing the > executable flags for trustworthyness is an xfce4 kluge, but that is > the way it is. hmm. mine are 444 and I don't get anything. Running xfce 4.12 Thanks again! > On 10/11/2016 12:16 PM, Gary Aitken wrote: >> On 10/11/16 12:42, Hagar Delest wrote: >> >>> How have you installed with the debs? If so, you should have a >>> desktop-integration folder inside the DEBS folder. Just install >>> it also. Else, check the folder: >>> /usr/share/icons/hicolor/32x32/apps >> Ah, thanks. Ok, I see the icons are there; on my system (freebsd) >> they are in /usr/local/share/icons/hicolor... which is where they >> should be. >> >> However, the xfce4 launcher icon chooser doesn't have a way to add >> an arbitrary path to the set of icons, so I can't set it. This is >> clearly not an aoo problem, but do you happen to know where the >> config path for the xfce4 icon chooser is? >> >> Thanks >> >>> Le 11/10/2016 à 20:31, Gary Aitken a écrit : >>>> Hi all, >>>> >>>> I just upgraded my os from fbsd-9.2 to 10.3 and installed aoo >>>> 4.1.2. The installation appears to have gone well, but when I >>>> start up my desktop (xfce4) the launchers with shortcuts to aoo >>>> are missing the icons. My >>>> /usr/local/applications/openoffice-4.1.2/*.desktop files have >>>> entries in them which look like: Icon=openoffice4-calc >>>> >>>> However, when I open the xfec4 panel / launcher to edit it, the >>>> icon entry says "No Icon" and when I go to select an icon there >>>> are no aoo icons present. >>>> >>>> Can someone tell me which option is needed to load the icons, >>>> which port / package they are in, and which file they are >>>> supposed to be in? I would have thought they were supposed to >>>> get loaded with the base aoo port. How do the icons get located >>>> without an actual path name in the specification? - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: location of icons
On 10/11/16 12:42, Hagar Delest wrote: > How have you installed with the debs? If so, you should have a > desktop-integration folder inside the DEBS folder. Just install it also. > Else, check the folder: /usr/share/icons/hicolor/32x32/apps Ah, thanks. Ok, I see the icons are there; on my system (freebsd) they are in /usr/local/share/icons/hicolor... which is where they should be. However, the xfce4 launcher icon chooser doesn't have a way to add an arbitrary path to the set of icons, so I can't set it. This is clearly not an aoo problem, but do you happen to know where the config path for the xfce4 icon chooser is? Thanks > Le 11/10/2016 à 20:31, Gary Aitken a écrit : >> Hi all, >> >> I just upgraded my os from fbsd-9.2 to 10.3 and installed aoo 4.1.2. >> The installation appears to have gone well, but when I start up my desktop >> (xfce4) the launchers with shortcuts to aoo are missing the icons. >> My /usr/local/applications/openoffice-4.1.2/*.desktop files have entries >> in them which look like: >>Icon=openoffice4-calc >> >> However, when I open the xfec4 panel / launcher to edit it, the icon >> entry says "No Icon" and when I go to select an icon there are no aoo >> icons present. >> >> Can someone tell me which option is needed to load the icons, which port / >> package they are in, and which file they are supposed to be in? I would >> have thought they were supposed to get loaded with the base aoo port. >> How do the icons get located without an actual path name in the >> specification? - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
location of icons
Hi all, I just upgraded my os from fbsd-9.2 to 10.3 and installed aoo 4.1.2. The installation appears to have gone well, but when I start up my desktop (xfce4) the launchers with shortcuts to aoo are missing the icons. My /usr/local/applications/openoffice-4.1.2/*.desktop files have entries in them which look like: Icon=openoffice4-calc However, when I open the xfec4 panel / launcher to edit it, the icon entry says "No Icon" and when I go to select an icon there are no aoo icons present. Can someone tell me which option is needed to load the icons, which port / package they are in, and which file they are supposed to be in? I would have thought they were supposed to get loaded with the base aoo port. How do the icons get located without an actual path name in the specification? Thanks for any hints, Gary - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: location of icons
On 10/11/16 13:30, Hagar Delest wrote: > In xfce (I use xubuntu), the icon chooser has a drop down list with > an entry for graphic files (rough translation from my French > interface). If selected, it enables the path field to navigate the > HD. Hmmm. Here's what I see: I have a panel of launchers at the bottom of the display. Right click on aoo launcher for writer, choose properties "Launcher" dialog displays with "OpenOffice Writer" as the only entry in the "General" tab. Click on 6th button in the right column, "Edit the currently selected item" "Edit Launcher" dialog displays for Name: OpenOffice Writer Icon: is empty; click on it "Select an Icon" dialog displays "Select icon from:" drop-down is first item; these are filters, not a way to navigate "Search icon:" entry field is second item; used to filter which icons display based on the text name of the icon has a button on the right used to clear the field I see no other data entries except for the display of possible icons. Is this the same chooser you're using? I tried everything in the settings manager and don't see an icon chooser, although I may have not included it if it's optional in the xfce4 install process. I'll keep poking around. Thanks > As a workaround, you can create a custom desktop entry in your > ~/.local/share/applications folder. Then put the full path of the > icon in the icon line. > Le 11/10/2016 à 21:16, Gary Aitken a écrit : >> On 10/11/16 12:42, Hagar Delest wrote: >> >>> How have you installed with the debs? If so, you should have a >>> desktop-integration folder inside the DEBS folder. Just install >>> it also. Else, check the folder: >>> /usr/share/icons/hicolor/32x32/apps >> Ah, thanks. Ok, I see the icons are there; on my system (freebsd) >> they are in /usr/local/share/icons/hicolor... which is where they >> should be. >> >> However, the xfce4 launcher icon chooser doesn't have a way to add >> an arbitrary path to the set of icons, so I can't set it. This is >> clearly not an aoo problem, but do you happen to know where the >> config path for the xfce4 icon chooser is? >> >> Thanks >> >>> Le 11/10/2016 à 20:31, Gary Aitken a écrit : >>>> Hi all, >>>> >>>> I just upgraded my os from fbsd-9.2 to 10.3 and installed aoo >>>> 4.1.2. The installation appears to have gone well, but when I >>>> start up my desktop (xfce4) the launchers with shortcuts to aoo >>>> are missing the icons. My >>>> /usr/local/applications/openoffice-4.1.2/*.desktop files have >>>> entries in them which look like: Icon=openoffice4-calc >>>> >>>> However, when I open the xfec4 panel / launcher to edit it, the >>>> icon entry says "No Icon" and when I go to select an icon there >>>> are no aoo icons present. >>>> >>>> Can someone tell me which option is needed to load the icons, >>>> which port / package they are in, and which file they are >>>> supposed to be in? I would have thought they were supposed to >>>> get loaded with the base aoo port. How do the icons get located >>>> without an actual path name in the specification? > - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: what is the jre environment looking for?
On 10/15/16 18:14, Girvin R. Herr wrote:
>
>
> On 10/15/2016 12:38 PM, Gary Aitken wrote:
>> On 10/15/16 13:15, Gary Aitken wrote:
>>
>>> After re-installing my os (freebsd 10.3), aoo (4.1.2), mysql
>>> (5.6), and java (openjdk7, 8) when I attempt to open a database I
>>> get the message "No Java installation found..." ok...
>>>
>>> The Tools/Options/OpenOffice/Java dialog shows no installed jre.
>>> I presume this is because they are installed in
>>> /usr/local/openjdkx which is not the standard linux place.
>>>
>>> However, when I go to add a JRE, it complains about the folder I
>>> selected not containing a java runtime environment.
>>>
>>> Which folder should I be pointing at? I've tried
>>> /usr/local/openjdk7 /usr/local/openjdk7/jre
>>> /usr/local/openjdk7/lib /usr/local/openjdk7/bin
>>> /usr/local/openjdk7-jre /usr/local/openjdk7-jre/bin
>>> /usr/local/openjdk7-jre/lib
>>>
>>> What, specifically, is it looking for to detect a jre? I've tried
>>> installing only the jre port, /usr/local/openjdk7-jre, but
>>> pointing at it doesn't help either.
>> It seemed to work after installing openjdk8-jre
>>
>> But the question remains, what is it looking for to identify a
>> jre? Why doesn't it identify openjdk7-jre as valid?
>>
> Gary, usr/local is a valid place to install programs in *nix.
> However, I have done so and found that some programs expect to be in
> /usr or expect to find programs in /usr, not /usr/local, so beware.
>
> Do you have a JAVA_HOME environment variable? If so, what is it
> pointing to? Mine, on Slackware Linux, is pointing to /usr/lib/java .
> By what you say above, I would guess yours should be pointing to
> /usr/local/openjdk7 . I have reluctantly installed Oracle jdk
> 1.8.0_40, so some locations may be different with openjdk7, but the
> concept should be the same.
I don't have JAVA_HOME set, but do have JAVA_VERSION set (1.7)
That may be an issue at some point, but for this particular problem
I don't think it is (since openjdk8-jre showed up ok).
> My OpenOffice java path is pointing to /usr/lib/java/jre . Normally,
> AOO searches the familiar paths for the java and posts the ones it
> finds in the Tools -> Options -> OpenOffice -> Java dialog. If a
> java is selected in that dialog, down at the bottom, it has a
> "Location" where it found it. I would try the JAVA_HOME first, and
> if that is set properly and AOO still cannot find the java, then
> manually "Add" your java path to the dialog.
The problem is that manually adding a path doesn't work.
I have both openjdk7-jre and openjdk8-jre installed,
as well as the complete jdk7 and jdk8;
in /usr/local/openjdk7-jre and /usr/local/openjdk8-jre and
/usr/local/openjdk7 and /usr/local/openjdk8 respectively.
Aoo automagically found the jre in openjdk8-jre, but not the one
in openjdk7-jre, or the ones in the full openjdkX installs.
If I open the dialog and point it at /usr/local/openjdk7-jre,
it claims there is no valid jre there.
However, there *is* as nearly as I can tell.
In particular, /usr/local/openjdk7-jre/lib/rt.jar exists and is
readable. Same for /usr/local/openjdk7/jre/lib/rt.jar.
Which is why I'm wondering how it determines whether a jre is present
or not.
With only JAVA_VERSION set (to 1.7), compiles and executions seem
to do the right thing:
$ java -version
openjdk version "1.7.0_91"
$ javac garya/ClassTest.java
$ ls -lt garya
total 16
-rw-r--r-- 1 garya 1001 246 Oct 15 20:09 Cl.class
-rw-r--r-- 1 garya 1001 533 Oct 15 20:09 ClassTest.class
-rwxr-xr-x 1 garya 1001 415 Oct 15 20:07 ClassTest.java
$ java garya.ClassTest
Hello
> Another note about java and database connectors. I use
> mysql-connector-java-5.1.18-bin.jar to connect my AOO to my mariadb
> (mysql) server. The jar files must be located in a specific place to
> be recognized by java (the jre). Mine is in
> /usr/lib/java/jre/lib/ext/. , or ${JAVA_HOME}/jre/lib/ext/. .
Already have that one covered, although I'm using 5.1.37
Mine is in /usr/local/openjdkX-jre/lib/ext similar to yours,
although it is actually a symlink to an installed port; the
actual file is in /usr/local/share/java/classes/mysql-connector-java.jar
Thanks
> HTH. Girvin Herr
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
Re: what is the jre environment looking for?
On 10/15/16 13:15, Gary Aitken wrote: > After re-installing my os (freebsd 10.3), aoo (4.1.2), mysql (5.6), > and java (openjdk7, 8) when I attempt to open a database I get the > message > "No Java installation found..." > ok... > > The > Tools/Options/OpenOffice/Java > dialog shows no installed jre. > I presume this is because they are installed in /usr/local/openjdkx > which is not the standard linux place. > > However, when I go to add a JRE, it complains about the folder I selected > not containing a java runtime environment. > > Which folder should I be pointing at? > I've tried > /usr/local/openjdk7 > /usr/local/openjdk7/jre > /usr/local/openjdk7/lib > /usr/local/openjdk7/bin > /usr/local/openjdk7-jre > /usr/local/openjdk7-jre/bin > /usr/local/openjdk7-jre/lib > > What, specifically, is it looking for to detect a jre? > I've tried installing only the jre port, /usr/local/openjdk7-jre, > but pointing at it doesn't help either. It seemed to work after installing openjdk8-jre But the question remains, what is it looking for to identify a jre? Why doesn't it identify openjdk7-jre as valid? Thanks, Gary - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
what is the jre environment looking for?
Hi all, First, thanks for all the helpful advice I've gotten on this list over the years. After re-installing my os (freebsd 10.3), aoo (4.1.2), mysql (5.6), and java (openjdk7, 8) when I attempt to open a database I get the message "No Java installation found..." ok... The Tools/Options/OpenOffice/Java dialog shows no installed jre. I presume this is because they are installed in /usr/local/openjdkx which is not the standard linux place. However, when I go to add a JRE, it complains about the folder I selected not containing a java runtime environment. Which folder should I be pointing at? I've tried /usr/local/openjdk7 /usr/local/openjdk7/jre /usr/local/openjdk7/lib /usr/local/openjdk7/bin /usr/local/openjdk7-jre /usr/local/openjdk7-jre/bin /usr/local/openjdk7-jre/lib What, specifically, is it looking for to detect a jre? I've tried installing only the jre port, /usr/local/openjdk7-jre, but pointing at it doesn't help either. Thanks, Gary - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
need sample xml file for input to writer
Hi all, I need to generate an odt file with text and links to image files. I've looked briefly at the 700+ page spec but am trying to save myself a lot of time as I need to produce the output asap for some volunteer work I'm doing, so... Can anyone provide me with a bare-bones XML file that can be read into Writer? It was my understanding an odt could be a straight xml document. The simple odt documents I've looked at are not xml, but zip files. Unzipping one leaves a number of files, including one called "content.xml". If I attempt to load only that file, I get an empty (at least it looks empty) document in Math, not Writer. What's the magic to get the xml file opened in Writer? I know I can unpack a simple odt and replace the content.xml file and then rewrite the .odt, read it into writer (which complains about corruption) and write it back out to get a good .odt. But that seems like a bad way of going about it and I'd like to be able to generate a simple xml that loads ok. Many thanks for any hints. Gary - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
selectively modifiable text document?
Hi all, Is it possible to make a text document (odt) read-only with selectively modifiable regions? I'm looking for an alternative to modifiable pdfs. Thanks, Gary - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Auto Correct question
On 05/27/17 18:11, Kimberly Wise wrote: HelloI am working on a spreadsheet that needs to have certainwording. Specifically I am trying to put in the phrase RTsCarswithout the hyphen but with the capitalization. Every time I put it in the T becomes lowercase. I need it tobe uppercase. Is there a way to format the cells to NOT auto correct toRtsCars and allow it to be RTsCars?Thank you in advance. Kimberly Under Tools/AutoCorrect Options: Options Tab Deselect "Correct TWo INitial CApitals - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: calc array expression using result of min fn
On 08/14/18 11:24, Oliver Brinzing wrote:
have you tried something like this:
{=SUM(IF(B2:B10<=C2:C10;1;0))}
Unfortunately, that won't work in my case; or rather, that's what I was
trying to avoid.
My example was a simplification; the actual need is for something like
MIN(B2:B10 ; C2:C10 ; D2:D10 ; ...)
One could nest if's, but that gets cumbersome with many columns, as in:
=SUM( IF(B2:B201for example, according to
https://ask.libreoffice.org/en/question/20404/how-do-i-make-an-array-formula-out-of-a-function-that-normally-takes-array-arguments/
the max()/min() functions do not work this way.
Is there a list someplace of functions that do and do not work with
array expressions?
Thanks for the reply,
Gary
I'm having trouble getting an array expression to work in calc.
What I want is this:
{ COUNT( (MIN(B2:B10; C2:C10) = B2:B10) ) }
That is, count the number of rows in which the minimum across
columns B and C is in column B.
The expression MIN(B3; C3) = B3 works fine when entered in an
individual row...
Any help would be much appreciated. I do know to use
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
calc array expression using result of min fn
I'm having trouble getting an array expression to work in calc.
What I want is this:
{ COUNT( (MIN(B2:B10; C2:C10) = B2:B10) ) }
That is, count the number of rows in which the minimum across columns
B and C is in column B.
The expression
MIN(B3; C3) = B3
works fine when entered in an individual row...
Any help would be much appreciated.
I do know to use
Thanks,
Gary
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
