Re: [libreoffice-users] Calc - Numeric format [H]:MM

[Alex Kempshall]

Hi Johnny

The problem started in 6.2.0.

The problem has been fixed in 6.3.0.0.alpha0+

Don't know in which version between 6.2.0 and 6.3.0 the problem was 
actually fixed.


Alex

On 14/02/2019 16:53, Johnny Rosenberg wrote:

Den tors 14 feb. 2019 kl 08:41 skrev Juan Antonio :


Hallo. I use a calc sheet to make a time control. The cells where I
introduce
de time are formatted to display the Hour an Minute, according to the
format
code [H]:MM.

Now, from the new version of LibreOffice 6.2, some cells subtract one
minute
to the time. For example, *if I introduce 16:48, the cell displays 16:47*.
See the image below.


That doesn't happen to me.
1. What is displayed if you use the format [H]:MM:SS.00?
2. What is displayed if you change the format to
0.?

In my case the following is displayed:
1. 16:48:00.00
2. 0.7000

LibreOffice Calc version 6.1.4.2
Operating system: Manjaro
Kernel: Linux 4.14


Kind regards

Johnny Rosenberg




¿Any idea? Thanks


Juan Antonio

<
http://document-foundation-mail-archive.969070.n3.nabble.com/file/t419414/LO_forum.jpg>




--
Sent from:
http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html

--
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



--
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] Calc - Numeric format [H]:MM

[Alex Kempshall]

I think it's a bug!

Just tried it on my system [H]:MM

I started with 16:46 in the cell which was OK

I changed the cell contents to 16:47 which was OK

I changed the cell contents to 16:48  the cell contents stayed at 16:47 
but the contents of the Input Line was correct at 16:48


I changed the cell contents to 16:49 the cell contents changed to 16:48 
but the contents of the Input Line was correct at 16:49


Weird.

Using HH:MM seems to be OK.

Have you checked bugzilla?

Alex



On 14/02/2019 07:40, Juan Antonio wrote:

Hallo. I use a calc sheet to make a time control. The cells where I introduce
de time are formatted to display the Hour an Minute, according to the format
code [H]:MM.

Now, from the new version of LibreOffice 6.2, some cells subtract one minute
to the time. For example, *if I introduce 16:48, the cell displays 16:47*.
See the image below.

¿Any idea? Thanks

Juan Antonio





--
Sent from: 
http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html



--
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] Cut/Copy problems in LO

[Alex Kempshall]

Have you tried

Copy a section in memoQ -> start notepad -> paste that section into 
notepad -> Copy that section from notepad -> move to Writer -> paste 
that section into writer


Alex


On 09/08/18 06:05, Thomas Blasejewicz wrote:

On 2018/08/09 12:36, Steve Edmonds wrote:



On 09/08/18 15:01, Thomas Blasejewicz wrote:

On 2018/07/05 9:40, Thomas Blasejewicz wrote:

On 2018/07/05 5:23, Virgil Arrington wrote:

Okay, I've had the cut/copy/paste issue pop up again in LO. It just
happened today. By way of reminder, my configuration is as follows:

Sony Vaio laptop
Linux Mint 18
LO 6.0.3.2

The problem occurs ONLY with Libreoffice, but not with any other 
software as far as I can tell, using at least three
different versions: older version 4..somenthing, intermediate 
verions 5.2.. and the newest 6.0.5.2.
Once the problem pops up, I have to try all sort of things like 
deliberately saving all open files, repeating the copy+paste procedure
several times among different softwares, or, as Mr. Virgil said, 
close down LibreOffice. Usually Write alone WILL NOT be sufficient.
AND .. it does not make any difference whether I use keyboard 
commands or the mouse.

By now, the situation has developed into a nightmare!
There is nothing wrong with my operation -> it works just fine with 
other software.

The problem starts mostly when I use memoQ (a CAT tool):
Copy a section in memoQ -> move to Writer -> paste that section.
It may work ONCE - but then never again.
The exact same procedure, except for copying into a text editor or 
even MS-Word does NOT cause any problems.


What is this with LibreOffice?
Is there really nothing that can be done?
(I do NOT want to use Word and by now I have mostly forgotten how to 
use it anyway. That would make work very uncomfortable.)


Thank you.
Thomas

Grabbing at straws here, does it make any difference if, when you 
paste into Writer, you paste special>unformatted text.

steve


No, unfortunately it does not.




--
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] Mail Merge testing account fails

[Alex Kempshall]

Hi Max

What version of LibreOffice are you using?

Have you checked your settings are correct?

When I change the settings I've found that the "Test Settings" can fail.

Closing down LibreOffice completely and restarting always seems to fix 
it for me.


Alex


On 15/05/18 13:53, Maximilien Chaumon wrote:

Dear all,

I'm trying to set up sending emails with mail merge. I entered my
credentials etc. in Tools>Options>LibreOffice Writer>Mail Merge E-mail, but
when I hit "Test Settings", it hangs for a couple minutes and shows me the
following error. Same error with email accounts from several providers.
Is there a way I can fix this?

Many thanks!
Max

LibreOffice could not connect to the outgoing mail server. Check your
system's settings and the settings in LibreOffice. Check the server name,
the port and the secure connections settings
--
: Connection unexpectedly closed:
[Errno 104] Connection reset by peer, traceback follows
   File "/opt/libreoffice6.0/program/mailmerge.py", line 107, in connect
 self.server = smtplib.SMTP(server, port,timeout=tout)
   File "/opt/libreoffice6.0/program/python-core-3.5.4/lib/smtplib.py", line
251, in __init__
 (code, msg) = self.connect(host, port)
   File "/opt/libreoffice6.0/program/python-core-3.5.4/lib/smtplib.py", line
338, in connect
 (code, msg) = self.getreply()
   File "/opt/libreoffice6.0/program/python-core-3.5.4/lib/smtplib.py", line
391, in getreply
 + str(e))




--
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/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] LO:MailMerge supplying OutServerPassword via macro

[Alex Kempshall]

I've got some code that uses MailMerge to email documents. It works. 
However, the password is stored in registrymodifications.xcu in clear text.


Trying to move forward

I cleared the password from registrymodifications.xcu by

    Tools -> Options -> LibreOffice Writer -> Mail Merge E-mail -> 
Server Authentication


and deleting the contents of the password field.

The line in registrymodifications

changed from

oor:name="MailPassword" oor:op="fuse">XXX 
YYY


to

oor:name="MailPassword" oor:op="fuse">


I then changed my macro to include the MailMerge property 
OutServerPassword. As in the code snippet below



    oMailMerge = CreateUnoService("com.sun.star.text.MailMerge")
    oMailMerge.DocumentURL =  ConvertToUrl(strSelectedTemplate)
    oMailMerge.DataSourceName =  "MySQLDataBase"
    oMailMerge.CommandType = 0        'Command

    oMailMerge.Command = "MySQLDataBase.tbl_temporary"
    oMailMerge.OutputType = com.sun.star.text.MailMergeType.MAIL
    oMailMerge.Subject = strTitle
    oMailMerge.AddressFromColumn = "Email_Address"
    oMailMerge.OutServerPassword="XXX YYY"

    oMailMerge.SendAsHTML = True

    oMailMerge.execute(Array())



When I run the script it fails with the following error message box

BASIC runtime error.
An exception occurred
Type: com.sun.star.uno.Exception
Message: Mail merge failed. Sorry, no further information available..

What am I doing wrong?

Has anyone else got this working?








--
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/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] writer vs calc behaviour in LO 6.0.1.1

[Alex Kempshall]

On 24/02/18 19:03, Dave Stevens wrote:

Can anyone tell me a simple way to insert the data as characters rather
than a field?



Maybe use this process.

1. Insert the field date (fixed) in the format required
2. Select the inserted field date (fixed)
3. Cut the selected data
4. Paste (unformatted)

if this is too cumbersome code something as a macro and link it to the 
tool bar.



Alex


--
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/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] mail merge is incomplete

[Alex Kempshall]

On 24/12/16 19:42, Albert, Oszkó wrote:
I have LO 5.2.3.3 on openSUSE Leap42.2 with KDE. Selecting mailmerge 
wizard in LO writer there are only 5 steps included. I cannot figure 
out what is missing to complete the wizard to 8 steps and being able 
to send the letters via email.


This is the way that LO has gone. It now splits the setup from the 
actions. When you complete the five steps in the wizard, you don't need 
to complete all of them, and pressing the wizard's  button the 
new Mail/Merge tool bar should become available to use.


Alex

--
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] Re: Please confirm Calc bug - discontiguous selection of rows, right-click is very slow

[Alex Kempshall]

On Slackware 14.1

My timings are

4.4.2

15 discontiguous rows  - instant response
500 discontiguous rows - about 5 seconds


4.3.6

15 discontiguous rows - about 15 secods
500 discontiguous rows - over 600 seconds and still waiting

Clearly one of the developers has done something which has dramatically 
improved things in Linux world. Whether 5 seconds, in 4.4.2, for 500 
discontiguous rows is acceptable, I'll let others be the judge. If not 
raise a bug to draw out comments from the developers.



Regards



On 19/04/15 19:20, Andreas Säger wrote:

Am 19.04.2015 um 16:01 schrieb Tanstaafl:

On 4/19/2015 9:16 AM, Andreas Säger  wrote:

Am 19.04.2015 um 15:05 schrieb Tanstaafl:

After prior replies, it appears it may still be there in the 4.4.x
series, but maybe only on Windows.

I'll be installing the latest 4.4 soon, and will test some more before
opening a bug. Will report back here, and ask others to test a bit more
and comment, to try to determine

a) if it is indeed still there, and

b) if it is, is it windows only.

Thanks to all for replying...

Same behaviour with
LO 3.5
LO 4.4.2
AOO 4.1.1
tested under Windows (the latter 2) and Linux (all 3).

Hmmm... Graham replied that he saw no evidence of the problem on Linux
Mint with 4.4.2...

Graham? Can you confirm?



It really depends on how many rows you have selected.
And it does not happen with a selection of columns as you can see when
using my macro with the word Rows replaced with Columns.

With 500 selected rows there is a lag of several seconds.
With 5000 selected rows the CPU is used up for minutes.





--
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] MAIL MERGE: Default fields "Topic" and "Subject" are only printed in first document

[Alex Kempshall]

Sven

As a work-around have you considered hard-coding the Title and Subject in the 
Starting Document instead of inserting the Title and Subject fields?

Alex


On Sunday 27 Jul 2014 10:53:37 Sven Schüring wrote:
> oh well, I'm looking forward that this problem would be fixed soon in one
> of the next LO versions.
> 
> regards
> Sven
> 
> 
> On Sun, Jul 27, 2014 at 9:21 AM, Alex McMurchy <
> mcmurchy1917-libreoff...@yahoo.co.uk> wrote:
> 
> > *Bug 81782[1]* - MAILMERGE: Some fields (Title, Subject, Author) only
> > printed to the first document
> >
> > I see that someone else has now confirmed that the bug has been present
> > for a long time.
> >
> > Alex
> >
> >
> > On Saturday 26 Jul 2014 16:06:26 Sven Schüring wrote:
> > > Hi Alex,
> > >
> > > thanks for your confirmation.
> > > I've raised a bug to writer component as followed:
> > >
> > > https://www.libreoffice.org/get-help/bug/
> > >
> > > regards,
> > > Sven
> > >
> > >
> > > On Sat, Jul 26, 2014 at 10:05 AM, Alex McMurchy <
> > > mcmurchy1917-libreoff...@yahoo.co.uk> wrote:
> > >
> > > > Sven
> > > >
> > > > I can confirm your problem.
> > > >
> > > > I see Title/Subject only on the first page irrespective of whether I
> > save
> > > > the final merged document as a whole or as individual documents.
> > > >
> > > > I tested using the Mail Wizard tool.
> > > >
> > > > Raise it as a bug and post back here the reference.
> > > >
> > > > Alex
> > > >
> > > >
> > > >
> > > > On Thursday 24 Jul 2014 21:44:16 Sven Schüring wrote:
> > > > > Hi,
> > > > >
> > > > > I've some trouble with the default fields "Topic" and "Subject" of
> > the
> > > > > document properties.
> > > > > They are only printed in the first mail merge document if I set the
> > field
> > > > > to the document.
> > > > > At the following documents there are only whitespace.
> > > > >
> > > > > Can anyone confirm my problem?
> > > > > Is it a bug or a misused by myself?
> > > > >
> > > > > regards
> > > > > Sven
> > > > >
> > > > >
> > > >
> > > > --
> > > > 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
> > > >
> > > >
> >
> > 
> > [1] https://bugs.freedesktop.org/show_bug.cgi?id=81782
> >
> > --
> > 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

Re: [libreoffice-users] Re: Automating creation of PDF from Calc

[Alex Kempshall]

Hi Fernand and everyone else.

Thanks for the note. The reason for my initial posting was that I realised that 
using the Dispatcher was not helpful and I wanted to use the API methods. It 
wasn't until several days later with lots of googling that I fould that the API 
method to export to a PDF was 

oDocument=ThisComponent
oDocument.storeToURL(sURL, aMediaDescriptor)

plus the filter 

calc_pdf_Export

and it wasn't until I fell over the link

https://wiki.openoffice.org/wiki/API/Tutorials/PDF_export

that things became a lot clearer. Prior to this I was googling for a method 
like export as PDF and as there isn't one that explicitly has this or a similar 
name I couldn't find what I was looking for but suffering from information 
overload with the hundreds of thousands hits I was getting.

I've now decided to follow the discussions in the Apache Open Office Community 
Forum for "Macros and UNO API" as it seems to contain a wealth of information. 
I've not found any information of any relevance on the LibreOffice sites 
relating to the API. If there is any, can someone point me in the right 
direction. A simple guide to the key areas of the API would be really useful.

OpenOffice has this page which can search their API - 
http://www.openoffice.org/api/

So if I enter  "export as pdf" in the "The Office API Reference" and push the 
Search button I get 2 results which contains the information I was looking for. 
Though I do think the Description for the page found 
http://www.openoffice.org/api/docs/common/ref/com/sun/star/frame/XStorable.html 
  could also include something like "You are here because you want to export as 
PDF and here are some relevant examples.

Or am I being unhelpful and just complaining because I don't undestand how to 
navigate the API documentation?


Alex


On Monday 12 May 2014 12:37:59 Fernand Vanrie wrote:
> Alex ,
> 
> using the Dispatcher is not a good idea , use te API and basic to 
> automate some functions as printing to PDF under specific conditions.
> Please find below the code i use to print from a Writer doc
> 
> Sub export2PDF()
> 
> dim oDoc as object
> 
>  CheckReportUser()
>  sParent = checkparent
> 
> OpenParams = Array(MakePropertyValue("Hidden",True),)
> 
> odoc = ThisComponent
> 'dispatcher = createUnoService("com.sun.star.frame.DispatchHelper")
> aray = Split(Date,"/")
> D = Join(aray,"-")
> aray = Split(Time,":")
> T = Join(aray,".")
> 'path = ConvertToUrl( "file:///C:/export/test " & D & "_" & T & ".pdf" )
> sfilename = left(odoc.title,12)& ".pdf"
> path = ConvertToUrl( "file:///H:/LowRes_" &  sfilename )
> '
> 'all documentation about  filderdata: >>> 
> http://wiki.services.openoffice.org/wiki/API/Tutorials/PDF_export#PDF_Export_filter_data
> '**
> pdfFilterData() = array((makepropertyvalue("UseLosslessCompression", false))
>   AddPropertyValue(pdfFilterData,"Quality",90) ' only if we set 
> UseLosslessCompression to FALSE ( jpg)
> 'AddPropertyValue(pdfFilterData,"ReduceImageResolution",false)
> 'AddPropertyValue(pdfFilterData,"MaxImageResolution",300) ' only if we 
> set ReduceImageResolution to TRUE (only  75, 150, 300, 600 or 1200 can 
> been used
> AddPropertyValue(pdfFilterData,"UseTaggedPDF",false)
> AddPropertyValue(pdfFilterData,"SelectPdfVersion",0) '0= pdf1.4 , 1= pdf-xa
> AddPropertyValue(pdfFilterData,"ExportNotes",false)
> AddPropertyValue(pdfFilterData,"ExportBookmarks",false)
> AddPropertyValue(pdfFilterData,"OpenBookmarkLevels",-1)
> AddPropertyValue(pdfFilterData,"UseTransitionEffects",true)
> AddPropertyValue(pdfFilterData,"IsSkipEmptyPages",true)
> AddPropertyValue(pdfFilterData,"IsAddStream",false)
> AddPropertyValue(pdfFilterData,"EmbedStandardFonts",false)
> AddPropertyValue(pdfFilterData,"FormsType",0)
> AddPropertyValue(pdfFilterData,"ExportFormFields",true)
> AddPropertyValue(pdfFilterData,"AllowDuplicateFieldNames",false)
> AddPropertyValue(pdfFilterData,"HideViewerToolbar",false)
> AddPropertyValue(pdfFilterData,"HideViewerMenubar",false)
> AddPropertyValue(pdfFilterData,"HideViewerWindowControls",false)
> AddPropertyValue(pdfFilterData,"ResizeWindowToInitialPage",false)
> AddPropertyValue(pdfFilterData,"CenterWindow",false)
> AddPropertyValue(pdfFilterData,"OpenInFullScreenMode",false)
> AddPropertyValue(pdfFilterData,"DisplayPDFDocumentTitle",true)
> AddPropertyValue(pdfFilterData,"InitialView",0)
> AddPropertyValue(pdfFilterData,"Magnification",0)
> AddPropertyValue(pdfFilterData,"Zoom",100)
> AddPropertyValue(pdfFilterData,"PageLayout",0)
> AddPropertyValue(pdfFilterData,"FirstPageOnLeft",false)
> AddPropertyValue(pdfFilterData,"InitialPage",1)
> AddPropertyValue(pdfFilterData,"Printing",2)
> AddPropertyValue(pdfFilterData,"Changes",4)
> AddPropertyValue(pdfFilterData,"EnableCopyingOfContent",true)
> AddPropertyValue(pdfFilterData,"EnableTextAccessForAccessibilityTools",true)
> AddPropertyValue(pdfFilterData,"ExportLinksRelativeFsys",false)
> AddPropertyValue(pdfFilterData,"PDFViewSelection",0)
> 

Re: [libreoffice-users] Automating creation of PDF from Calc

[Alex Kempshall]

Hi Brian

I want to do it via a macro.

Out of the 85 sheets in the document I would want to create PDFs for 24 of 
them. I would soon get bored or make mistakes if I generated each manually.

Really what I'm looking for is to see if anyone can point me in the direction 
of the documentation for the API properties for exporting to PDFs.

Thanks

Alex




On Thursday 08 May 2014 15:43:43 Brian Barker wrote:
> At 14:23 08/05/2014 +0100, Alex McMurchy wrote:
> >I have a requirement to generate PDF's from specific set sheets 
> >contained in one Calc document, the document has 85 individual sheets.
> 
> You could set print ranges (Format | Print Ranges) on all the 
> relevant sheets - which could cover either entire sheets or ranges, 
> even multiple ranges, within them - and then either use File | Export 
> as PDF... (or the Export Directly as PDF button in the Standard 
> toolbar) or print to a virtual PDF printer (free versions are available).
> 
> Or have I misunderstood the detail of your requirement?
> 
> I trust this helps.
> 
> Brian Barker
> 
> 
> 

-- 
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] HOW CAN I CONVERT A NUMBER IN LibreOffice CALC TO TEXT IN LibreOffice CALC?

[Alex Kempshall]

That extension worked for me both for NumberText and MoneyText.

In my previous post I'd was talking about version 0.9.4. I didn't realise there 
was a newer version!

Alex



On Tuesday 25 Feb 2014 13:45:41 Paul D. Mirowsky wrote:
> Please download and install
> 
> http://extensions.libreoffice.org/extension-center/numbertext-1
> 
> I needed to format a number to written (long-hand) for a check. This did 
> produce what was needed.
> 
> When using MONEYTEXT(), reference your cell with the number in it. 
> Although the command asks for more, it is not required. It appears to 
> format from the default languages settings.
> Make sure your language settings are correct.
> 
> I did not test NUMBERTEXT, also within this extension.
> 
> Hope this helps.
> 
> Paul
> 
> On 2/24/2014 1:15 PM, e-letter wrote:
> > On 23/02/2014, Tanstaafl  wrote:
> >> Tom, please do NOT CC me directly, I am on the list and certainly don't
> >> need to see your messages twice.
> >>
> >> On 2014-02-22 7:01 PM, Tom Davies  wrote:
> >>> As the User Support mailing list for a gateway project i think it's
> >>> fairly good that we help people to learn that there are alternatives
> >>> to top-posting without making anyone feel as unwelcome as certain
> >>> other projects like to make their new users feel.
> > Gratuitous, contradictory nonsense.
> >
> >> That is hilarious coming from you Tom, since:
> >>
> >> 1. you never, EVER bottom/inline post, and
> >>
> > This is not the case historically when corresponding to programmers on
> > their list(s)
> >
> 
> 
> 

-- 
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] LibréOffice Base Forms, PostgreSQL (JDBC) and Table Joins

[Alex Kempshall]

Jim

You stated that you could generate a query to do what you require. Have you 
based your form on the query?

Alex


On Sunday 23 Feb 2014 10:05:11 Jim Seymour wrote:
> Alex,
> 
> Thanks for the follow-up.
> 
> Ideally there'd be one form for the asset(s), wherein each value
> could be entered or altered, the ones being foreign key references
> presenting a list from the desired column in the table to which the
> FK references.
> 
> For example: I can do an ad hoc query that looks roughly like
> 
> select ..., s.desc as "status", ... from hdwr_assets h
>   left join hdwr_status s on s.status_id = h.status_id...;
> 
> and a field named "status" will show in the output.
> 
> Ideally, I'd like to be able to do that.  In fact: I *can* do that in
> Queries -> Create Query in Design View), but not in a form?
> 
> Behind the scenes: When you clicked on a list box for "status" in the
> assets form, a list derived from "descr" in the status table would be
> presented. When a selection is made, the related status_id value
> would be placed in the status_id field for the selected hardware
> asset.
> 
> A sub-form would (could?) be presented, allowing one to alter the
> status table.
> 
> Btw: When I try to associate hdwr_assets.status_id to
> hdwr_status.status_id using the Forms Wizard, execution results in
> 
> Error: The data content could not be loaded.
> Error: SQL Status: 22023
>  The column index is out of range: 1, number of columns: 0.
> Information: The SQL command leading to this error is:
> 
>  SELECT * FROM "public"."hdwr_status" WHERE ( "status_id"
>  = :link_from_status_id )
> 
> Which is not valid SQL.
> 
> I would have thought this functionality would be present.  Even the
> most basic of database normalization in the most trivial of databases
> is going to result in multiple tables and FK references.
> 
> Thanks,
> Jim
> 
> On Sun, 23 Feb 2014 09:22:32 +
> Alex McMurchy  wrote:
> 
> > Jim
> > 
> > Is it that you want a single form, comprised of sub forms, whereby 
> > you can filter assets according to their status i.e. "deployed" or
> > "in stock"; from the results given select a specific asset which
> > presents the result, of that one asset, in a sub form from which
> > the asset can be amended?
> > 
> > Alex
> > 
> > On Saturday 22 Feb 2014 13:11:52 Jim Seymour wrote:
> > > Hi There,
> > > 
> > > I've researched and experimented with this, and I'm out of ideas.
> > > 
> > > For starters: LibréOffice 3.5.7.2, Build ID: 350m1 (Build: 2)
> > > 
> > > Before anybody suggests a newer version: I'm currently on Ubuntu
> > > 10.04 LTS (Lucid Lynx), so I'm stuck with it.  (Even my much newer
> > > Linux Mint desktop install at work is still 3.x, I believe.)
> > > 
> > > I have a database with a couple tables, as in
> > > 
> > > create table hdwr_assets (
> > >   atag   text primary key,
> > >   serno  text unique,
> > >   status_id  int references hdwr_status,
> > >   . 
> > >   .
> > >   .
> > > );
> > > 
> > > -- e.g.: "deployed", "in stock"
> > > create table hdwr_status (
> > >   status_id serial  primary key,
> > >   descr textnot null,
> > > );
> > > 
> > > The plan was to create a form that could query and alter hardware
> > > assets, selecting values for status_id from a drop-down list, the
> > > available selection being from the hardware status table.
> > > 
> > > Near as I can tell: The Forms Wizard simply isn't that smart?
> > > 
> > > Interestingly: A Query created in Design View DTRT, wrt FK
> > > references, but I can't persuade the Forms Wizard to do so.  In
> > > fact: FK references in the Forms Wizard appear to be thoroughly
> > > broken--at least in the version of LO I have?
> > > 
> > > Is there any way to accomplish what I want, or am I going to have
> > > to resort to Real Coding (Java, HTML+PHP+JS or whatever)?
> > > 
> > > Thanks,
> > > Jim
> > > 
> > 
> 
> 

-- 
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] Similar Problem?

[Alex Kempshall]

Having said all that. It would appear that I've never had  auto backup switched 
on.

Having switched it on I now see backups and autobackups for writer and calc 
documents. Nothing at all for base documents.

Alex



On Wednesday 15 Jan 2014 14:35:33 Alex McMurchy wrote:
> I used to have that problem. It seems to have stopped around about 16th July 
> 2013. Not sure why!
> 
> Either - 
> 
> I upgraded LibreOffice which stopped the feature
> or I did something else which I can't remember!
> 
> I'm currently on 4.1.4.2.
> 
> Alex
> 
> 
> 
> 
> On Wednesday 15 Jan 2014 07:38:25 Tom Davies wrote:
> > Hi :)
> > Errr, is it possible to switch the auto-save and auto-backups off for
> > a while and see if that improves things?  The thing i find difficult
> > about doing that is remembering to save properly and frequently
> > enough.  With Base i think it's also important to close properly.
> > 
> > There is some documentation and a handbook at
> > https://wiki.documentfoundation.org/Documentation/Publications
> > and the Faq at
> > https://wiki.documentfoundation.org/Faq
> > might be able to help too but the best place seems to be this mailing
> > list or the Base forums at Apache OpenOffice.
> > Regards from
> > Tom :)
> > 
> > On 15 January 2014 07:30, Tom Davies  wrote:
> > > Hi :)
> > > Errr, are you using the internal back-end?  You haven't connected to
> > > an external back-end have you?  You should really be keeping your data
> > > in an external back-end instead of having the whole database as a
> > > single file.
> > >
> > > Being able to do that is one of the main things that makes Base so
> > > much more powerful than Access.  The internal back-end got tacked on
> > > to make Base more familiar to people who have picked up bad habits by
> > > using Access.  It seems to be a bit broken though.  Annoyingly the
> > > Marketing Mailing List and all our flyers, posters and leaflets (at
> > > least all the ones that mention Base at all) keep pushing people into
> > > using the internal back-end despite the fact that users have even
> > > experienced data-loss by doing so.  I'm tempted to ask you to take
> > > this problem to the marketing list to get them to solve it but the
> > > experts in Base are mostly on this list and will hopefully be able to
> > > help with this issue.
> > >
> > > It should be possible to export your existing tables into an external
> > > back-end and this mailing list (note, not the marketing list) might be
> > > able to help you with that.
> > >
> > > The next smart thing about Base is that forms and reports can be, and
> > > are best made in Writer or/and (i think) Calc.  So normal users who
> > > are clueless about databases can read the data in a familiar setting
> > > and use familiar tools to format and edit things around the
> > > data-fields.  The forms and reports inside Base seem to be for
> > > data-entry and people who have some clue about databases.
> > >
> > > However i have never quite got around to getting to grips with all
> > > this.  So hopefully some of the experts might wade in and set me
> > > straight (again)
> > > Regards from
> > > Tom :)
> > >
> > >
> > >
> > >
> > > On 15 January 2014 05:57, Vince Radice  wrote:
> > >> I am running Fedora FC19-64 bit. Libreoffice Version: 4.1.4.2
> > >> Build ID: 4.1.4.2-2.fc19
> > >>
> > >> Here are some lines of a ls -la command
> > >>
> > >> -rw---.  1 vince root   0 Dec 13 13:10 GRNew odb_0.odb
> > >> -rw---.  1 vince root   0 Dec 13 15:58 GRNew odb_1000.odb
> > >> -rw---.  1 vince root   0 Dec 13 15:58 GRNew odb_1001.odb
> > >> -rw---.  1 vince root   0 Dec 13 15:58 GRNew odb_1002.odb
> > >> -rw---.  1 vince root   0 Dec 13 15:58 GRNew odb_1003.odb
> > >> -rw---.  1 vince root   0 Dec 13 15:58 GRNew odb_1004.odb
> > >> -rw---.  1 vince root   0 Dec 13 15:58 GRNew odb_1005.odb
> > >> -rw---.  1 vince root   0 Dec 13 15:59 GRNew odb_1006.odb
> > >> -rw---.  1 vince root   0 Dec 13 15:59 GRNew odb_1007.odb
> > >> -rw---.  1 vince root   0 Dec 13 15:59 GRNew odb_1008.odb
> > >> -rw---.  1 vince root   0 Dec 13 15:59 GRNew odb_1009.odb
> > >> -rw---.  1 vince root   0 Dec 13 13:26 GRNew odb_100.odb
> > >> -rw---.  1 vince root   0 Dec 13 15:59 GRNew odb_1010.odb
> > >>
> > >> My database name is GRNew,odb.
> > >> I was looking at some of the recent messages that were talking about LO
> > >> looping saving backups of untitled documents.  It mentioned Calc and 
> > >> Write
> > >> as being involved.  Could this be related to my problem?
> > >>
> > >> Thanks,
> > >> Vince Radice
> > >>
> > >>
> > >> On 01/14/2014 12:44 PM, Tom Davies wrote:
> > >>>
> > >>> Hi :)
> > >>> On Ubuntu 12.04 i have no files in there.  Do the file-names start
> > >>> with a ~ or with "lock"?  In either of those cases i think you can
> > >>> delete the files without worry but it might be worth testing that for
> > >>> 1 or 2 files.
> > >>>
> > >>>