Re: [libreoffice-users] Possible Bug in 4.2.0.4 Copy Paste in Firefox ESR 24.3ESR
2014-02-13 20:19 GMT+01:00 Tom Davies : > Hi :) > Wow!! That looks perfect for a bug-report > https://wiki.documentfoundation.org/BugReport > Versions numbers and everything there makes it much more useful. > > I rarely notice such things but lately there seem to have been a few > such issues between various programs in Windows. > Regards from > Tom :) > > > > On 13 February 2014 19:03, Dan Czuchra wrote: > > Hi all, > > > > > > > > I think I may have found a bug/strange combo with the release 4.2.0.4. I > > have some users of LO that are unable to copy/paste text into Gmail > emails. > > They can copy paste into Firefox search bars and url bars just fine, but > > nothing gets copy/pasted in an email in Firefox. I've cleared the cache, > > reinstalled Firefox and restarted the 4.2 computers multiple times and > > nothing has fixed this issue. > > > > > > > > I've tried copy pasting from LO to Gmail open in IE 11 and Chrome > > 32.XXX.107 and they work, but only in Firefox does this function fail. > I've > > made sure the documents are editable and I'm sure it's not an issue of > > PEBKAC. I've reproduced this bug on my own machine as well (which shares > > the same Windows 7 image as the rest of our company). > > > > > > > > Downgrading to LO 4.1 fixes this issue. Am I missing something or can > > anyone else confirm this on 4.2? > > > > > > > > Just so you know, we're running: > > > > > > > > Windows 7 SP1 Pro (x64) w/ the latest patches > > > > Java 7 u51 > > > > Flash 12.0.44 > > > > Firefox 24.3 ESR > > > > > > > > Let me know if you need more info. > > > > > > > > Dan > Dan, Tom : I suspect that this is (as so often previously) a Windows problem. I have no difficulty att all copying from a document in LibreOffice 4.2.0.4 (Build ID: 420m0(Build:4)) and pasting to Gmail on my main box, running Linux Mint 16 and Firefox Nightly (30.0a1 2014-02-15) Henri -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Crash Calc
Hello
with these 2 macros called alternatively, I crash Calc after 10-50 calls.
I feel like a memory leak, because before the crash there are abnormal
signs: display another sheet, significant delay ...
I call the macro "NouvelleFacture with a list where I chose the name,
then the macro Imprimer, it creates me a pdf and saves the current document
(Odoc.Store)
anyone have an idea?
Thanks!
Bonjour
avec ces 2 macros appelées alternativement , je plante Calc au bout de 10 à
50 appels.
j'ai l'impression d'une fuite mémoire, car avant le plantage il y a des
signes anormaux : affichage d'une autre feuille, delay important...
j'appelle la macro Nouvelle Facture avec une liste déroulante ou je choisi
le nom,
puis la macro Imprimer, celle-ci me crée un pdf et enregistre le document en
cours (Odoc.Store)
quelqu'un aurait une idée?
bonne journée!!
Sub NouvelleFacture (Evt)
dim oDoc as object
dim Feuille as object
Dim oRange As Object
Dim oCellLire as object, oCellEcrire as object
Dim i as Integer
Dim l as Long, ll as Long
Dim itemNum as Integer
Dim Nom as string, Adr1 as string, Adr2 as string, Ville as string, Chambre
as string
oDoc=thiscomponent
Feuille=oDoc.Sheets.getByName("Formules")
itemNum = Evt.Source.SelectedItemPos + 1
oCellLire = Feuille.getCellByPosition(3,9)'timer
l= oCellLire.GetValue
ll = Timer()
l=ll-l
oCellLire = Feuille.getCellByPosition(2,9)'drp impression, est vérifié à
l'ouverture d'une nouvelle facture
if oCellLire.GetValue = 0 AND l>10 then
i= MsgBox ("La facture n'a pas été enregistrée, continuer?", 4 + 32 + 256,
"Attention")
if i = 7 then
exit sub
End If
if i = 6 then
oCellEcrire = Feuille.getCellByPosition(3,9)'timer
l = Timer()
oCellEcrire.SetValue(l)
End If
else
oCellLire.SetValue(0)
End If
oCellLire = Feuille.getCellByPosition(2,10) 'num facture
i=oCellLire.Value
Feuille=oDoc.Sheets.getByName("Clients")
oCellLire = Feuille.getCellByPosition(0,itemNum) 'civi
Nom = oCellLire.string & " "
oCellLire = Feuille.getCellByPosition(1,itemNum) 'nom
Nom = Nom & oCellLire.string & " "
oCellLire = Feuille.getCellByPosition(2,itemNum) 'prénom
Nom = Nom & oCellLire.string
oCellLire = Feuille.getCellByPosition(3,itemNum) 'Adr1
Adr1 = oCellLire.string
oCellLire = Feuille.getCellByPosition(4,itemNum) 'Adr2
Adr2 = oCellLire.string
oCellLire = Feuille.getCellByPosition(5,itemNum) 'CP
Ville = oCellLire.string & " "
oCellLire = Feuille.getCellByPosition(6,itemNum) 'Ville
Ville = Ville & oCellLire.string
oCellLire = Feuille.getCellByPosition(7,itemNum) 'Chambre
Chambre = "Chambre " & oCellLire.string
Feuille=oDoc.Sheets.getByName("FactureIndividuelle")
oCellEcrire = Feuille.getCellByPosition(0,14)
oCellEcrire.SetString("Facture N°" & i)
oCellEcrire = Feuille.getCellByPosition(5,6)
oCellEcrire.SetString(Nom)
oCellEcrire = Feuille.getCellByPosition(5,7)
oCellEcrire.SetString(Adr1)
oCellEcrire = Feuille.getCellByPosition(5,8)
oCellEcrire.SetString(Adr2)
oCellEcrire = Feuille.getCellByPosition(5,9)
oCellEcrire.SetString(Ville)
oCellEcrire = Feuille.getCellByPosition(5,10)
oCellEcrire.SetString(Chambre)
oRange = Feuille.getCellRangeByPosition(0,18,0,29)'("A19:A30")
oRange.clearContents(31)
oRange = Feuille.getCellRangeByPosition(0,32,0,42)'("A33:E42")
oRange.clearContents(31)
oRange = Feuille.getCellRangeByPosition(5,18,5,29)'("F18:F30")
oRange.clearContents(31)
oRange = Feuille.getCellRangeByPosition(5,32,5,42)'("F33:F43")
oRange.clearContents(31)
oRange = Feuille.getCellRangeByPosition(6,18,6,29)'("G19:G30")
oRange.clearContents(31)
oRange = Feuille.getCellRangeByPosition(6,32,6,42)'("G33:G43")
oRange.clearContents(31)
oCellLire = Feuille.getCellByPosition(1,20) 'acte
oCellEcrire = Feuille.getCellByPosition(1,20)
oCellEcrire.Setstring(oCellLire.getstring)
End Sub
Sub Imprimer
Dim oDoc As Object
Dim FeuilleDep As Object, FeuilleArr As Object
Dim oCellLire as object, oCellEcrire as object
Dim Args1(2) as new com.sun.star.beans.PropertyValue
Dim Args2(2) as new com.sun.star.beans.PropertyValue
Dim Chemin As String, maDate As String
Dim i as Integer, ExoLig As Integer, numCli As Integer, numFact As Integer
Dim Client as String
Dim DrpModif as integer
oDoc = ThisComponent
FeuilleDep = oDoc.Sheets.getByName("Formules")
oCellLire = FeuilleDep.getCellByPosition(2,8)' DrpModif
DrpModif = oCellLire.getvalue
if DrpModif = 0 then
oCellLire = FeuilleDep.getCellByPosition(2,10) 'NumFacture
numFact = oCellLire.getvalue
oCellLire.setValue(numFact+1)
else
numFact = DrpModif
End If
oCellLire = FeuilleDep.getCellByPosition(2,8)' DrpModif
oCellLire.SetValue(0)
oCellLire = FeuilleDep.getCellByPosition (2,1) 'chemin
Chemin = oCellLire.getString
if Right(Chemin,1) <> "/" then
Chemin = Chemin & "/"
End If
oCellLire = FeuilleDep.getCellByPosition (5,5)'année
i = oCellLire.getValue
Chemin = Chemin & i & "/"
oCellLire = FeuilleDep.getCellByPosition (4,5)'mois
i = oCellLire.getValue
oCellLire = FeuilleDep.getCellByPosition (3,5)'jour
maDate = oCellLire.getValue
oCellLire = FeuilleDep.getCellByPo
[libreoffice-users] Re: averaging with missing values
On 2/15/2014 11:49 AM, Regina Henschel wrote: Hi William, william drescher schrieb: I have a table of systolic bloop pressures: 4 rows (weeks) x 21 cols (days) eg: week 1 130 133 140 ... (representing morning, noon, night of day 1 - followed by morning, noon and night of day 2..7) I want to compute the average pressure for the week. In a perfect world I would just use the average function. However, in this world I find that each row has between 3 and 10 missing values. To get the average now I sum the row's values and then divide by the number of values in the row. Can anyone suggest a way of getting the average without needing to manually count the values ? If the cells are really empty or have a function call that results in a text, then such cells will not be counted by the AVERAGE function. If the cells contain a formula, which results in 0, then you can use AVERAGEIF(range;"<>0"). Kind regards Regina Thank you for the information - couldn't be easier --bill -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] plantage Calc
Bonjour
avec ces 2 macros appelées alternativement , je plante Calc au bout de 10 à
50 appels.
j'ai l'impression d'une fuite mémoire, car avant le plantage il y a des
signes anormaux : affichage d'une autre feuille, delay important...
j'appelle la macro Nouvelle Facture avec une liste déroulante ou je choisi
le nom,
puis la macro Imprimer, celle-ci me crée un pdf et enregistre le document en
cours (Odoc.Store)
quelqu'un aurait une idée?
bonne journée!!
Sub NouvelleFacture (Evt)
dim oDoc as object
dim Feuille as object
Dim oRange As Object
Dim oCellLire as object, oCellEcrire as object
Dim i as Integer
Dim l as Long, ll as Long
Dim itemNum as Integer
Dim Nom as string, Adr1 as string, Adr2 as string, Ville as string, Chambre
as string
oDoc=thiscomponent
Feuille=oDoc.Sheets.getByName("Formules")
itemNum = Evt.Source.SelectedItemPos + 1
oCellLire = Feuille.getCellByPosition(3,9)'timer
l= oCellLire.GetValue
ll = Timer()
l=ll-l
oCellLire = Feuille.getCellByPosition(2,9)'drp impression, est vérifié à
l'ouverture d'une nouvelle facture
if oCellLire.GetValue = 0 AND l>10 then
i= MsgBox ("La facture n'a pas été enregistrée, continuer?", 4 + 32 + 256,
"Attention")
if i = 7 then
exit sub
End If
if i = 6 then
oCellEcrire = Feuille.getCellByPosition(3,9)'timer
l = Timer()
oCellEcrire.SetValue(l)
End If
else
oCellLire.SetValue(0)
End If
oCellLire = Feuille.getCellByPosition(2,10) 'num facture
i=oCellLire.Value
Feuille=oDoc.Sheets.getByName("Clients")
oCellLire = Feuille.getCellByPosition(0,itemNum) 'civi
Nom = oCellLire.string & " "
oCellLire = Feuille.getCellByPosition(1,itemNum) 'nom
Nom = Nom & oCellLire.string & " "
oCellLire = Feuille.getCellByPosition(2,itemNum) 'prénom
Nom = Nom & oCellLire.string
oCellLire = Feuille.getCellByPosition(3,itemNum) 'Adr1
Adr1 = oCellLire.string
oCellLire = Feuille.getCellByPosition(4,itemNum) 'Adr2
Adr2 = oCellLire.string
oCellLire = Feuille.getCellByPosition(5,itemNum) 'CP
Ville = oCellLire.string & " "
oCellLire = Feuille.getCellByPosition(6,itemNum) 'Ville
Ville = Ville & oCellLire.string
oCellLire = Feuille.getCellByPosition(7,itemNum) 'Chambre
Chambre = "Chambre " & oCellLire.string
Feuille=oDoc.Sheets.getByName("FactureIndividuelle")
oCellEcrire = Feuille.getCellByPosition(0,14)
oCellEcrire.SetString("Facture N°" & i)
oCellEcrire = Feuille.getCellByPosition(5,6)
oCellEcrire.SetString(Nom)
oCellEcrire = Feuille.getCellByPosition(5,7)
oCellEcrire.SetString(Adr1)
oCellEcrire = Feuille.getCellByPosition(5,8)
oCellEcrire.SetString(Adr2)
oCellEcrire = Feuille.getCellByPosition(5,9)
oCellEcrire.SetString(Ville)
oCellEcrire = Feuille.getCellByPosition(5,10)
oCellEcrire.SetString(Chambre)
oRange = Feuille.getCellRangeByPosition(0,18,0,29)'("A19:A30")
oRange.clearContents(31)
oRange = Feuille.getCellRangeByPosition(0,32,0,42)'("A33:E42")
oRange.clearContents(31)
oRange = Feuille.getCellRangeByPosition(5,18,5,29)'("F18:F30")
oRange.clearContents(31)
oRange = Feuille.getCellRangeByPosition(5,32,5,42)'("F33:F43")
oRange.clearContents(31)
oRange = Feuille.getCellRangeByPosition(6,18,6,29)'("G19:G30")
oRange.clearContents(31)
oRange = Feuille.getCellRangeByPosition(6,32,6,42)'("G33:G43")
oRange.clearContents(31)
oCellLire = Feuille.getCellByPosition(1,20) 'acte
oCellEcrire = Feuille.getCellByPosition(1,20)
oCellEcrire.Setstring(oCellLire.getstring)
End Sub
Sub Imprimer
Dim oDoc As Object
Dim FeuilleDep As Object, FeuilleArr As Object
Dim oCellLire as object, oCellEcrire as object
Dim Args1(2) as new com.sun.star.beans.PropertyValue
Dim Args2(2) as new com.sun.star.beans.PropertyValue
Dim Chemin As String, maDate As String
Dim i as Integer, ExoLig As Integer, numCli As Integer, numFact As Integer
Dim Client as String
Dim DrpModif as integer
oDoc = ThisComponent
FeuilleDep = oDoc.Sheets.getByName("Formules")
oCellLire = FeuilleDep.getCellByPosition(2,8)' DrpModif
DrpModif = oCellLire.getvalue
if DrpModif = 0 then
oCellLire = FeuilleDep.getCellByPosition(2,10) 'NumFacture
numFact = oCellLire.getvalue
oCellLire.setValue(numFact+1)
else
numFact = DrpModif
End If
oCellLire = FeuilleDep.getCellByPosition(2,8)' DrpModif
oCellLire.SetValue(0)
oCellLire = FeuilleDep.getCellByPosition (2,1) 'chemin
Chemin = oCellLire.getString
if Right(Chemin,1) <> "/" then
Chemin = Chemin & "/"
End If
oCellLire = FeuilleDep.getCellByPosition (5,5)'année
i = oCellLire.getValue
Chemin = Chemin & i & "/"
oCellLire = FeuilleDep.getCellByPosition (4,5)'mois
i = oCellLire.getValue
oCellLire = FeuilleDep.getCellByPosition (3,5)'jour
maDate = oCellLire.getValue
oCellLire = FeuilleDep.getCellByPosition (4,5)'mois
maDate = maDate & "/" & oCellLire.getValue
oCellLire = FeuilleDep.getCellByPosition (5,5)'année
maDate = maDate & "/" & oCellLire.getValue
Select Case (i)
case 1
Chemin = Chemin & "janvier/"
case 2
Chemin = Chemin & "février/"
case 3
Chemin = Chemin & "mars/"
case 4
Chemin = Chemin & "avril/"
case 5
Chemin = Chemin & "mai/"
case 6
Chemin = Chemin & "juin/"
case 7
Chemin = Chemin &
[libreoffice-users] LibreOffice Logo function
I am not able to define my own functions in LibreOffice Logo 4.2.1.1. TO test FORWARD 20 ; or whatever command END test does not works. Nothing happens, not even an error message. Some others having the same problem? I think it is a bug, but before reporting it as such I would like to verify that it really is a bug. Using Windows 7 LibreOffice downloaded from http://no.libreoffice.org/last-ned-libreoffice/ Defining my own functions works in 4.1. (Yes, I know that 4.2 is unstable and all that, but I am using it because I am translating LO to Norwegian nynorsk). Kolbjoern -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: [libreoffice-marketing] how many languages can LO support at the same time. . .
Hi *, On Mon, Jan 27, 2014 at 4:52 AM, Kracked_P_P---webmaster wrote: > > The problem I have with "selling" LO to computer centers, both regular and > ones that teach English as a second language, is how many languages can LO > support at the same time. The limit is only the diskspace and RAM (when having spellchecking in all languages enabled) > I am talking about two ways. 1 - usable dictionaries in the list. 2 - > different languages you can change your menus to. As much as you install/as much as there are available. But if using lots of languages and lots of dictionaries, RAM usage might be a limit on older systems. > The first one is the key for me. > > You have English, French, Spanish [3 regional versions], Italian, and 4 or 5 > other different language dictionaries, installed and enabled, in the > Extension Manager. How many of those languages are usable to the user > writing documents in English and one or two other languages at a time, all of them. Provided that you did install the extension as administrator for all users, and not for a single user only. > then > someone else sits down and tried to use his or hers language[s] with > English. So how many installed and enabled languages can be used at the > same time? I was told there was a very small limited number. I don't quite understand this sentence, and whoever did tell you that the usage of languages would be limited. But it's not true, except maybe for RAM usage if LO needs to load many large dictionaries for many languages. > Then the second is not much of a problem for me. Yet, since you can switch > between language packs and their help packs, how many can you install and be > able to switch back and forth between English and the other non-English > languages? You can install all of them and switch between all of them. Diskspace is the limitation here. And you probably don't want to have users switch between UI languages all the time, but rather have different (system level) user-accounts for that, as very likely LO won't be the only software that should display another UI language > Of course, if a center worker needs to switch the menus back to English, or > to their default settings, how easy is it if the person/worker does not > read/speak the language the menu is currently in? If they did it once, no problem, Just remember at what position Tools|Options is, then you can just click through the option dialog until you find the right tab. > Is it possible to make a > script to reset the "preferences" back to a default instead of some manual > copy/paste-over some file? It is possible, but doesn't really make sense. Use different system-accounts for that. > She had to use several different packages of MS Office, since > she needed to write in English, French, Hebrew, and one other language that > I cannot remember the name of. To make this perfectly clear: You don't need to install the corresponsing UI package to write in a foreign language. You can write arabic, chinese, german, etc all with using the english UI. > I do > not know if LO can write both English and Hebrew, since one is left to right > and the other is right to left [if I remember correctly], No problem with mixing - but you need to tell LO what alignment is the "master" one, i.e. is it hebrew with some english text in it, or the other way round. This is either per paragraph or per document/page-style. > As some people have pointed out to me, if I write an document for the U.K., > I need to spell color "colour" to get it correctly spelled for their region, > since my American spelling of "color" would be shown up misspelled in their > systems as "colour" is misspelled in mine. > > So switching between regional language variants is as important as switching > to totally different languages. The language of text is part of the character properties and is inherited the usual way: direct formatting, character template, paragraph formatting, paragraph template, document setting. > So how many of these languages, and their variants, can LO support and use > at one time? No limit. ciao Christian -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: [libreoffice-marketing] how many languages can LO support at the same time. . .
Hi *, On Sun, Feb 16, 2014 at 4:20 PM, Christian Lohmaier wrote: > On Mon, Jan 27, 2014 at 4:52 AM, Kracked_P_P---webmaster > wrote: > > The language of text is part of the character properties and is > inherited the usual way: > direct formatting, character template, paragraph formatting, paragraph > template, document setting. A careful reader pointed out to me that the language cannot be set in Format|Paragraph (i.e. no direct format on a paragraph level exists for this, only in the paragraph style). So while you can assign a language to an entire paragraph using the language item in the Statusbar or using the contextmenu while spell-checking, this sets the character format accordingly. But of course the basic idea still holds true - you can define the language globally, and can gradually override them to a different one. Which method to choose depends on the nature of the document. But when working with different writing systems, very likely you will use the paragraph template method, as usually you'd use a different font as well. ciao Christian -- 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] Writer printing problem
In data martedì 4 febbraio 2014 20:20:04, Kracked_P_P---webmaster ha scritto: > It moved me to the first page, on 4.1.4 64-bit Ubuntu version. > > I have not tested it on Win7 and 4.1.4 and 4.2.0.4, since I have been > working on fixing a backlog of 4 2005-2007 era systems given today to be > out the door ASAP. I tried successfully in a large file: I was on page 16 and printed page 32. The cursor remained in page 16 without moving. Kubuntu on KDE 4.12.1 / LibreOffice Version: 4.1.3.2 (Build ID: 410m0(Build:2)) > > On 02/04/2014 07:41 PM, rost52 wrote: > > Hi Joe, > > > > I tested Version: 4.1.4.2 > > Build ID: 0a0440ccc0227ad9829de5f46be37cfb6edcf72 on XP/SP3 > > with a selected part of a text and printed it. I also printed a page > > in the middle of a several page long document. In both cases Writer > > did not change cursor position, same part of the document remains on > > screen before and after printing > > > > May I ask you to publish the link of your question to the AskLibO > > forum here? > > > > ROSt52 > > > > On 2014-02-04 04:20, Joe Alders wrote: > >> Hello, > >> > >> After a very disappointing experience using the LibreOffice Forum at the > >> 'ask' part of the LibreOffice site, I will try this forum for help. > >> This is my problem using Writer: > >> > >> When printing a part of a Writer document and being somewhere in this > >> document, it always jumps to the first page after giving the 'print' > >> command. > >> This only happens when I want to print a particular page or pages. > >> It does not happen when I will print the complete document. > >> I find this very annoying and hope that someone on this forum can > >> help me > >> out here. > >> I am using Windows 7 64 bits Home Premium. > >> Thanks in advance, > >> Joe. -- Valter Open Source is better! LibreOffice: www.libreoffice.org KDE: www.kde.org Kubuntu: www.kubuntu.org -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Question about Calc and user-defined number formats
So, I installed LibreOffice 4.2.0 on a Windows 7 system today and was showing the system owner how to use it. I created a new spreadsheet and added two columns and four rows, the last row being a "total" row that would show the sum of the previous rows. The first row I added was column headings. The second row I added had text in the first cell and the number "50" in the second cell. The third row I added had text in the first cell and the number "40" in the second cell. The fourth row was blank. The fifth row was the "total" row. Cool. So, I selected cells "B2..B5" and used the "Format/Cells" function to change the format to a currency format. I chose the "-$1,234.00" in red format. The numbers in column B were changed accordingly. Then, my friend wanted only the first cell with a number to have a dollar sign and the numbers below it to NOT have a dollar sign. So, I selected cells "B3..B5" and used the "Format/Cells" function to change the format. When the "Format Cells" window appeared, the "Currency" number format was selected, as expected. I went to the "Format code" box and simply removed the "$$" references, leaving the rest of the format code intact. The Category immediately changed to "User Defined", which is fine. Here's the problem: after the category changes to "User Defined", the modified format code, which is still displayed, doesn't apply to the selected cells and I can't find any way to save the modified currency format as a user defined format I can reuse. I tried changing the comment of "User-defined" to something else, thinking that might be used as a category name or something. What am I doing wrong? Thanks in advance! Peace... Tom -- /When we dance, you have a way with me, Stay with me... Sway with me.../ -- 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] Writer printing problem
Has anyone tested it out on 4.1.5 or 4.2.0? I have not updated to 4.1.5, on my systems from 4.1.4, yet. It now looks like it started with version 4.1.4, maybe. KDE with 4.1.3 works. Win7 and Ubuntu 12.04LTS does not using 4.1.4. Do not remember seeing any test for 4.2.0, yet. On 02/16/2014 02:25 PM, Valter Mura wrote: In data martedì 4 febbraio 2014 20:20:04, Kracked_P_P---webmaster ha scritto: It moved me to the first page, on 4.1.4 64-bit Ubuntu version. I have not tested it on Win7 and 4.1.4 and 4.2.0.4, since I have been working on fixing a backlog of 4 2005-2007 era systems given today to be out the door ASAP. I tried successfully in a large file: I was on page 16 and printed page 32. The cursor remained in page 16 without moving. Kubuntu on KDE 4.12.1 / LibreOffice Version: 4.1.3.2 (Build ID: 410m0(Build:2)) On 02/04/2014 07:41 PM, rost52 wrote: Hi Joe, I tested Version: 4.1.4.2 Build ID: 0a0440ccc0227ad9829de5f46be37cfb6edcf72 on XP/SP3 with a selected part of a text and printed it. I also printed a page in the middle of a several page long document. In both cases Writer did not change cursor position, same part of the document remains on screen before and after printing May I ask you to publish the link of your question to the AskLibO forum here? ROSt52 On 2014-02-04 04:20, Joe Alders wrote: Hello, After a very disappointing experience using the LibreOffice Forum at the 'ask' part of the LibreOffice site, I will try this forum for help. This is my problem using Writer: When printing a part of a Writer document and being somewhere in this document, it always jumps to the first page after giving the 'print' command. This only happens when I want to print a particular page or pages. It does not happen when I will print the complete document. I find this very annoying and hope that someone on this forum can help me out here. I am using Windows 7 64 bits Home Premium. Thanks in advance, Joe. -- 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] Question about Calc and user-defined number formats
At 11:27 16/02/2014 -0800, Tom Williams wrote: I selected cells "B2..B5" and used the "Format/Cells" function to change the format to a currency format. I chose the "-$1,234.00" in red format. The numbers in column B were changed accordingly. Then, my friend wanted only the first cell with a number to have a dollar sign and the numbers below it to NOT have a dollar sign. So, I selected cells "B3..B5" and used the "Format/Cells" function to change the format. When the "Format Cells" window appeared, the "Currency" number format was selected, as expected. I went to the "Format code" box and simply removed the "$$" references, leaving the rest of the format code intact. The Category immediately changed to "User Defined", which is fine. Here's the problem: after the category changes to "User Defined", the modified format code, which is still displayed, doesn't apply to the selected cells ... Nothing happens until you confirm by clicking OK, of course. But if you mean that the format didn't change even after you clicked OK, then the obvious first possibility is that you had made an error in modifying the string in the "Format code" box and had created something that was not a valid format code. In this case, the format of the selected cells would not change and no new format example would be created in the User-defined category. (You can test this by experiment.) ... and I can't find any way to save the modified currency format as a user defined format I can reuse. If the new format had been applied but for some reason not been saved in the Format Cells dialogue, then the Format Paintbrush might be a workaround. But if the format has not been applied to your original selection, then the problem is earlier and this is irrelevant. 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] Question about Calc and user-defined number formats
On 02/16/2014 02:36 PM, Brian Barker wrote: > At 11:27 16/02/2014 -0800, Tom Williams wrote: >> I selected cells "B2..B5" and used the "Format/Cells" function to >> change the format to a currency format. I chose the "-$1,234.00" in >> red format. The numbers in column B were changed accordingly. Then, >> my friend wanted only the first cell with a number to have a dollar >> sign and the numbers below it to NOT have a dollar sign. So, I >> selected cells "B3..B5" and used the "Format/Cells" function to >> change the format. When the "Format Cells" window appeared, the >> "Currency" number format was selected, as expected. I went to the >> "Format code" box and simply removed the "$$" references, leaving the >> rest of the format code intact. The Category immediately changed to >> "User Defined", which is fine. >> >> Here's the problem: after the category changes to "User Defined", >> the modified format code, which is still displayed, doesn't apply to >> the selected cells ... > > Nothing happens until you confirm by clicking OK, of course. But if > you mean that the format didn't change even after you clicked OK, then > the obvious first possibility is that you had made an error in > modifying the string in the "Format code" box and had created > something that was not a valid format code. In this case, the format > of the selected cells would not change and no new format example would > be created in the User-defined category. (You can test this by > experiment.) Thanks for posting this. Duh :) Since no message of any kind was issued telling me the modified format might be invalid, it didn't occur to me that I was breaking the format code. I'll experiment with this. Thanks! Peace... Tom -- /When we dance, you have a way with me, Stay with me... Sway with me.../ -- 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] Change character attributes
Well, that too, but Change Case is actually an item in the menu. Dave On 2/14/2014 17:49, Pikov Andropov wrote: Right!! Format > Character > Effects Thanks. Dave Liesse has written on 2/14/2014 8:36 PM: Pikov, This is an option in the Format menu. Dave On 2/14/2014 17:30, Pikov Andropov wrote: Some word processors permit you to select a bunch of character and change the case. I couldn't find that in LO. I sit in fact there? Thanks. -- 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] Writer printing problem
I tried it out using LO 4.2.0.4 under Linux Mint 15 printing the 5th page of a document while the cursor was on page 3. The cursor stayed on page 3. Graham On 16 February 2014 21:01, Kracked_P_P---webmaster < webmas...@krackedpress.com> wrote: > > Has anyone tested it out on 4.1.5 or 4.2.0? > I have not updated to 4.1.5, on my systems from 4.1.4, yet. > > It now looks like it started with version 4.1.4, maybe. > KDE with 4.1.3 works. > Win7 and Ubuntu 12.04LTS does not using 4.1.4. > Do not remember seeing any test for 4.2.0, yet. > > > > > > > On 02/16/2014 02:25 PM, Valter Mura wrote: > >> In data martedì 4 febbraio 2014 20:20:04, Kracked_P_P---webmaster ha >> scritto: >> >>> It moved me to the first page, on 4.1.4 64-bit Ubuntu version. >>> >>> I have not tested it on Win7 and 4.1.4 and 4.2.0.4, since I have been >>> working on fixing a backlog of 4 2005-2007 era systems given today to be >>> out the door ASAP. >>> >> I tried successfully in a large file: I was on page 16 and printed page >> 32. The >> cursor remained in page 16 without moving. >> >> Kubuntu on KDE 4.12.1 / LibreOffice Version: 4.1.3.2 (Build ID: >> 410m0(Build:2)) >> >> On 02/04/2014 07:41 PM, rost52 wrote: >>> Hi Joe, I tested Version: 4.1.4.2 Build ID: 0a0440ccc0227ad9829de5f46be37cfb6edcf72 on XP/SP3 with a selected part of a text and printed it. I also printed a page in the middle of a several page long document. In both cases Writer did not change cursor position, same part of the document remains on screen before and after printing May I ask you to publish the link of your question to the AskLibO forum here? ROSt52 On 2014-02-04 04:20, Joe Alders wrote: > Hello, > > After a very disappointing experience using the LibreOffice Forum at > the > 'ask' part of the LibreOffice site, I will try this forum for help. > This is my problem using Writer: > > When printing a part of a Writer document and being somewhere in this > document, it always jumps to the first page after giving the 'print' > command. > This only happens when I want to print a particular page or pages. > It does not happen when I will print the complete document. > I find this very annoying and hope that someone on this forum can > help me > out here. > I am using Windows 7 64 bits Home Premium. > Thanks in advance, > Joe. > > > -- > 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
