Re: [libreoffice-users] Appearance of hyperlinks in Calc spreadsheets
On 22/10/2019 15:27, Dave Barton wrote: -- *From:* Philip Jackson [mailto:philip-jack...@gmx.com] *Sent:* Tuesday, October 22, 2019, 11:43 UTC *To:* LibreOffice *Subject:* [libreoffice-users] Appearance of hyperlinks in Calc spreadsheets LO 6.0.7.3 in UbuntuStudio 18.04 LTS In a Calc spreadsheet, I have a column consisting only of hyperlinks to websites. They are correctly formed and work fine with Ctrl-click. My problem is the appearance of the column. Each link is in black text backed by a dark gray background colour (like indications of 'fields' in Writer).� That makes it difficult for me to read. My preference would be black or even blue text on a plain white background like the rest of the spreadsheet. The Help file provides the same information for formatting hyperlinks under Calc as it does for Writer. Essentially it suggests changing the attributes via character styles > internet links. I can't find any access to character styles in Calc let alone internet links styles. Nor is there anything applicable to hyperlinks in cell formatting. (And in any case, the Help text doesn't apply even to my version of Writer either - but in Writer, I can at least change paragraph styles to get the effect I would like). I think I have searched thoroughly but I know it's easy to miss some details so I'm appealing for any useful tips that you may be able to provide to help me modify these attributes. What happens if you tap the F11 function key or select the menu option View -> Styles ? Either one should open the the Styles & Formatting panel, where you should see Hyperlink in the list of cell styles. Right click on Hyperlink and select modify. In the Cell Style: hyperlink dialog there are options to set font and background colors. Note your existing cells with hyperlinks in them will have the default style and you will have to select those cells and apply the Hyperlink style to them. I don't have access to the Ubuntu edition of LibreOffice at the moment, but the above procedure works perfectly for me using the standard edition downloaded from TDF mirror servers. F11 and 'Manage Styles' from View and Format menus were my first port of call. But they only produce Default, Heading and Result styles under Cell Styles and Default and Report under Page styles. There are no other options and no Hyperlink style. You are correct that my cells are Default style and attempt to modify this style opens the usual Cell Format dialogue which has no mention of hyperlink. I thought there could be such a mention under the Font Effects tab - but no. However, a PM from another list member suggested where I could find Field Shadings and this lead to a solution for me. Under Tools | Options | LibreOffice | Application Colours | Custom Colours. Then scroll down to find Text Document and Field Shadings where I set the field shadings to a custom light grey colour. This improved the readability of my hyperlinks in Calc without, I hope, eliminating the usefulness of field shadings in Writer documents. Thanks to all. Philip -- 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
[libreoffice-users] Re: Building libreoffice with clang on ppc64
Here's the backtrace. The process that segfaults is gengan.bin: #0 0x00081baea134 in (anonymous namespace)::cpp_mediate(unsigned long, void**, void**, long, long*) (nOffsetAndIndex=60434681040, gpreg=0x3ffef830, fpreg=0x3ffef7c8, sp=4611686018427320272, pRegisterReturn=0x3ffef7b8) at bridges/source/cpp_uno/gcc3_linux_powerpc64/cpp2uno.cxx:396 #1 0x00081bae9f50 in privateSnippetExecutor() () at bridges/source/cpp_uno/gcc3_linux_powerpc64/cpp2uno.cxx:563 #2 0x0008121de234 in cppu::throwException(com::sun::star::uno::Any const&)Python Exception No type named 挀漀洀⸀猀甀渀⸀猀琀愀爀⸀甀挀戀⸀䤀渀琀攀爀愀挀琀椀瘀攀 䄀甀最洀攀渀琀攀搀䤀伀䔀砀挀攀瀀琀椀漀渀.: (exc=) at cppuhelper/source/exc_thrower.cxx:207 #3 0x00081672ebd4 in ucbhelper::cancelCommandExecution(com::sun::star::ucb::IOErrorCode, com::sun::star::uno::Sequence const&, com::sun::star::uno::Reference const&, rtl::OUString const&, com::sun::star::uno::Reference const&) (eError=com::sun::star::ucb::IOErrorCode::IOErrorCode_NOT_EXISTING, rArgs= uno::Sequence of length 2 = {...}, xEnv=empty uno::Reference, rMessage="an error occurred during file opening", xContext=uno::Reference to (fileaccess::BaseContent *) 0x81d0b5258) at ucbhelper/source/provider/cancelcommandexecution.cxx:109 #4 0x00081d1ac3c0 in fileaccess::throw_handler(int, int, com::sun::star::uno::Reference const&, rtl::OUString const&, fileaccess::BaseContent*, bool) (errorCode=12, minorCode=2, xEnv=empty uno::Reference, aUncPath="file:///tmp/usr/ports/editors/libreoffice/work/libreoffice-6.3.2.2/workdir/Gallery/symbols/symbols", pContent=0x81d0b5220, isHandled=false) at ucb/source/ucp/file/filglob.cxx:362 #5 0x00081d1eb260 in fileaccess::TaskManager::endTask(int, rtl::OUString const&, fileaccess::BaseContent*) (this=0x81c84bcc0, CommandId=11, aUncPath="file:///tmp/usr/ports/editors/libreoffice/work/libreoffice-6.3.2.2/workdir/Gallery/symbols/symbols", pContent=0x81d0b5220) at ucb/source/ucp/file/filtask.cxx:408 #6 0x00081d18c1a8 in fileaccess::BaseContent::endTask(int) (this=0x81d0b5220, CommandId=11) at ucb/source/ucp/file/bc.cxx:1165 #7 0x00081d189ad8 in fileaccess::BaseContent::execute(com::sun::star::ucb::Command const&, int, com::sun::star::uno::Reference const&) (this=0x81d0b5220, aCommand=..., CommandId=11, Environment=empty uno::Reference) at ucb/source/ucp/file/bc.cxx:382 #8 0x0008166fa59c in ucbhelper::Content_Impl::executeCommand(com::sun::star::ucb::Command const&) (this=0x81c82ac00, rCommand=...) at ucbhelper/source/client/content.cxx:1254 #9 0x0008166fb42c in ucbhelper::Content::getPropertyValuesInterface(com::sun::star::uno::Sequence const&) (this=0x3fff0b78, rPropertyNames=uno::Sequence of length 1 = {...}) at ucbhelper/source/client/content.cxx:491 #10 0x0008166faa28 in ucbhelper::Content::getPropertyValues(com::sun::star::uno::Sequence const&) (this=0x3fff0b78, rPropertyNames=uno::Sequence of length 1 = {...}) at ucbhelper/source/client/content.cxx:450 #11 0x0008166fa894 in ucbhelper::Content::getPropertyValue(rtl::OUString const&) (this=0x3fff0b78, rPropertyName="Title") at ucbhelper/source/client/content.cxx:429 #12 0x0008141f6324 in FileExists(INetURLObject const&) (rURL=...) at svx/source/gallery2/galmisc.cxx:228 #13 0x0008141e9f78 in GalleryThemeEntry::ImplGetURLIgnoreCase(INetURLObject const&) (rURL=...) at svx/source/gallery2/gallery1.cxx:204 #14 0x0008141e97a0 in GalleryThemeEntry::GalleryThemeEntry(bool, INetURLObject const&, rtl::OUString const&, bool, bool, unsigned int, bool) (this=0x81cdfe800, bCreateUniqueURL=true, rBaseURL=..., rName="symbols", _bReadOnly=false, _bNewFile=true, _nId=0, _bThemeNameFromResource=false) at svx/source/gallery2/gallery1.cxx:131 #15 0x0008141eca28 in Gallery::CreateTheme(rtl::OUString const&) (this=0x81bb80800, rThemeName="symbols") at svx/source/gallery2/gallery1.cxx:608 #16 0x100119dc in createTheme(rtl::OUString const&, rtl::OUString const&, rtl::OUString const&, std::__1::vector >&, bool) (aThemeName="symbols", aGalleryURL="file:///tmp/usr/ports/editors/libreoffice/work/libreoffice-6.3.2.2/workdir/Gallery/symbols", aDestDir="file:///tmp/usr/ports/editors/libreoffice/work/libreoffice-6.3.2.2/extras/source/gallery", rFiles=std::vector of length 90 = {...}, bRelativeURLs=true) at svx/source/gengal/gengal.cxx:74 #17 0x1001115c in GalApp::Main() (this=0x10040048 ) at svx/source/gengal/gengal.cxx:298 #18 0x0008136b6208 in ImplSVMain() () at vcl/source/app/svmain.cxx:201 #19 0x0008136b790c in SVMain() () at vcl/source/app/svmain.cxx:235 #20 0x10024448 in sal_main() () at vcl/source/salmain/salmain.cxx:38 #21 0x100243dc in main(int, char**) (argc=10, argv=0x3fff1b58) at vcl/source/salmain/salmain.cxx:32 On 19-10-21 21:38:29, Piotr Kubaj wrote: > Hello, > > I'm trying to build LibreOffice 6.3.2 on FreeBSD/powerpc64
Re: [libreoffice-users] Appearance of hyperlinks in Calc spreadsheets
From: Philip Jackson [mailto:philip-jack...@gmx.com] Sent: Tuesday, October 22, 2019, 11:43 UTC To:LibreOffice Subject:[libreoffice-users] Appearance of hyperlinks in Calc spreadsheets LO 6.0.7.3 in UbuntuStudio 18.04 LTSIn a Calc spreadsheet, I have a column consisting only of hyperlinks to websites. They are correctly formed and work fine with Ctrl-click.My problem is the appearance of the column. Each link is in black text backed by a dark gray background colour (like indications of 'fields' in Writer).� That makes it difficult for me to read. My preference would be black or even blue text on a plain white background like the rest of the spreadsheet.The Help file provides the same information for formatting hyperlinks under Calc as it does for Writer. Essentially it suggests changing the attributes via character stylesinternet links. I can't find any access to character styles in Calc let alone internet links styles. Nor is there anything applicable to hyperlinks in cell formatting.(And in any case, the Help text doesn't apply even to my version of Writer either - but in Writer, I can at least change paragraph styles to get the effect I would like).I think I have searched thoroughly but I know it's easy to miss some details so I'm appealing for any useful tips that you may be able to provide to help me modify these attributes.Philip What happens if you tap the F11 function key or select the menu option View -Styles ? Either one should open the the StylesFormatting panel, where you should see Hyperlink in the list of cell styles. Right click on Hyperlink and select modify. In the Cell Style: hyperlink dialog there are options to set font and background colors. Note your existing cells with hyperlinks in them will have the default style and you will have to select those cells and apply the Hyperlink style to them. I don't have access to the Ubuntu edition of LibreOffice at the moment, but the above procedure works perfectly for me using the standard edition downloaded from TDF mirror servers. Hope that helps. Dave -- 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] Experimental macro features: How to determine object types?
Den tis 22 okt. 2019 kl 14:32 skrev Stephan Bergmann : > On 22/10/2019 14:23, Johnny Rosenberg wrote: > > *Sub TestDim oRange As com.sun.star.sheet.XSheetCellRange > > > oRange=ThisComponent.getSheets().getByIndex(0).getCellRangeByPosition(0,0,10,10) > >Dim oDescriptor As com.sun.star.util.XSearchDescriptor > > oDescriptor=oRange.createSearchDescriptor() ' Gives an error message.End > > Sub* > > And how do you enable "the experimental features in Basic"? If I have a > working reproducer, I can take a look at why things behave oddly. > Two steps: 1. Tools ⇨ Options… ⇨ ▼ LibreOffice ⇨ Advanced ⇨ ☒ Enable experimental features (may be unstable) 2. Tools ⇨ Options… ⇨ ▼ LibreOffice ⇨ Basic IDE ⇨ ☒ Use extended types Kind regards Johnny Rosenberg -- 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] Experimental macro features: How to determine object types?
Den tis 22 okt. 2019 kl 09:00 skrev Stephan Bergmann : > On 21/10/2019 21:43, Johnny Rosenberg wrote: > > Den mån 21 okt. 2019 kl 12:53 skrev Stephan Bergmann < > sberg...@redhat.com>: > >> On 18/10/2019 20:16, Johnny Rosenberg wrote: > >>> *Private Function ItemFound(sItem As string, _ oRange As > >>> com.sun.star.sheet.XSheetCellRange) As Boolean Dim oDescriptor As > >>> com.sun.star.util.XReplaceDescriptor > >>> oDescriptor=oRange.createSearchDescriptor()* > >>> *⁝* > >>> *⁝* > >>> *End Function* > >>> > >>> So the answer to my question seems to be > >>> ”com.sun.star.util.XReplaceDescriptor”. Exactly why is a little blurry > to > >>> me at the moment. > >> > >> css.util.XReplaceDescriptor is derived from css.util.XSearchDescriptor. > >> I assume that what dim'ing you need should depend on what you do with > >> oDescriptor in the part you elided: If you only call > >> XSearchDescriptor-methods on it, then dim as XSearchDescriptor should > >> suffice. If you call any of the XReplaceDescriptor-only methods > >> (getting/setting the ReplaceString), then you need to dim as > >> XReplaceDescriptor. > >> > > But in that case, why did the error message happen at the > > ”oDescriptor=oRange.createSearchDescriptor()” line? I hadn't started to > use > > it yet… > > So what /is/ the exact error message? > > That's strange. I was convinced that I already said that, but I can't find it in the thread, so maybe I just didn't. The exact message is: ”Object not accessible. Invalid use of an object.” If I change the Dim statement from ”Dim oDescriptor As com.sun.star.util.XSearchDescriptor” to ”Dim oDescriptor As com.sun.star.util.XReplaceDescriptor”, the error message doesn't appear and everything seems to work. Example code for testing this: *Sub TestDim oRange As com.sun.star.sheet.XSheetCellRange oRange=ThisComponent.getSheets().getByIndex(0).getCellRangeByPosition(0,0,10,10) Dim oDescriptor As com.sun.star.util.XSearchDescriptor oDescriptor=oRange.createSearchDescriptor() ' Gives an error message.End Sub* *Sub TestDim oRange As com.sun.star.sheet.XSheetCellRange oRange=ThisComponent.getSheets().getByIndex(0).getCellRangeByPosition(0,0,10,10) Dim oDescriptor As com.sun.star.util.XReplaceDescriptor oDescriptor=oRange.createSearchDescriptor() ' Works fine.End Sub* I just think it's a little funny: I want to create a search descriptor, but ”declaring” it as such doesn't work, I need to ”declare” it as a replace descriptor. It's a little hard to take those things in. :) Kind regards Johnny Rosenberg -- 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
[libreoffice-users] Appearance of hyperlinks in Calc spreadsheets
LO 6.0.7.3 in UbuntuStudio 18.04 LTS In a Calc spreadsheet, I have a column consisting only of hyperlinks to websites. They are correctly formed and work fine with Ctrl-click. My problem is the appearance of the column. Each link is in black text backed by a dark gray background colour (like indications of 'fields' in Writer). That makes it difficult for me to read. My preference would be black or even blue text on a plain white background like the rest of the spreadsheet. The Help file provides the same information for formatting hyperlinks under Calc as it does for Writer. Essentially it suggests changing the attributes via character styles > internet links. I can't find any access to character styles in Calc let alone internet links styles. Nor is there anything applicable to hyperlinks in cell formatting. (And in any case, the Help text doesn't apply even to my version of Writer either - but in Writer, I can at least change paragraph styles to get the effect I would like). I think I have searched thoroughly but I know it's easy to miss some details so I'm appealing for any useful tips that you may be able to provide to help me modify these attributes. Philip -- 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] Advice needed on reporting a bug
On Tue, 22 Oct 2019, Tom Williams wrote: > Hi! I have a Word document that I downloaded from an online Sharepoint > site that appears mis-formatted in LibreOffice Writer 6.2.7.1 on Ubuntu > 19.04 Linux. It appears as if the page breaks are off. In any event, > the document is a legal document so I'm not willing to post the document > "as is" in a bug report, if I end up filing one. > > What would be a good alternative to preserve the information that shows > the formatting issues but not include the other legal information, in > the document? > > Thanks in advance! One possibility is to replace all characters by something else. For example, in Find & Replace, turn on 'Regular expressions' (under 'Other options') and replace '[a-z]' by 'x'. When you say 'the page breaks are off', do you mean that the page breaks occur in different places? Are they off by only a little? Maybe it's because the document uses a font that your system doesn't have so the font is being replaced by a font with slightly different font metrics? I believe that sometimes the formatting won't be quite the same even between different versions of Word, much less between Word and another word processor. - Robert -- 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] Experimental macro features: How to determine object types?
On 21/10/2019 21:43, Johnny Rosenberg wrote: Den mån 21 okt. 2019 kl 12:53 skrev Stephan Bergmann : On 18/10/2019 20:16, Johnny Rosenberg wrote: *Private Function ItemFound(sItem As string, _ oRange As com.sun.star.sheet.XSheetCellRange) As Boolean Dim oDescriptor As com.sun.star.util.XReplaceDescriptor oDescriptor=oRange.createSearchDescriptor()* *⁝* *⁝* *End Function* So the answer to my question seems to be ”com.sun.star.util.XReplaceDescriptor”. Exactly why is a little blurry to me at the moment. css.util.XReplaceDescriptor is derived from css.util.XSearchDescriptor. I assume that what dim'ing you need should depend on what you do with oDescriptor in the part you elided: If you only call XSearchDescriptor-methods on it, then dim as XSearchDescriptor should suffice. If you call any of the XReplaceDescriptor-only methods (getting/setting the ReplaceString), then you need to dim as XReplaceDescriptor. But in that case, why did the error message happen at the ”oDescriptor=oRange.createSearchDescriptor()” line? I hadn't started to use it yet… So what /is/ the exact error message? -- 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