We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

vbas96's profile - activity

2013-08-12 11:39:32 +0200 received badge  Famous Question (source)
2013-08-12 11:39:32 +0200 received badge  Notable Question (source)
2013-02-02 06:13:09 +0200 received badge  Popular Question (source)
2012-12-18 04:22:21 +0200 answered a question Problem with saving CSV with carriage return

This is not an answer; it's a workaround.

CSV is a simple text format, but there are variations in delimiters across programs. I had no problem moving data (saved from Libre Calc as .csv) into other programs. So I'll venture a guess that your receiving software may be looking for a particular form of delimiter that's a bit out of the ordinary.

Instead of CSV, try using Data Interchange Format. DIF is perhaps the oldest widely used spreadsheet-compatible format, and is precisely formated. It is supported by nearly all programs that process spreadsheet-styled data. From Libre Calc, "Save As" .dif and try to pull it into your system.

2012-12-17 01:23:35 +0200 commented answer Calc: Need help with macro, formula or other method to automate changes

Відмінне рішення - Libre Calc has many surprising features. Thanks for showing us this one.

2012-12-14 06:31:13 +0200 commented answer Set default formatting for Calc charts

I noticed your interest ROSt52. Took some time on translate.google to try to figure which of the four forms of "Spread the" to use. Then I discovered the verb and object are inverted from my usual...and the imperative sentence form is rare in Japanese. Hope I got it right. Spread the joy!

2012-12-14 05:59:34 +0200 received badge  Supporter (source)
2012-12-14 05:59:18 +0200 commented answer Set default formatting for Calc charts

I use the same approach as WW. It works. Changing data ranges takes minimal effort compared to modifying the chart parameters mentioned, especially if you frequently chart the same number of plots (lines). If dataset is the same size and configuration, labels will load automatically. 喜びを広げる

2012-12-13 18:32:19 +0200 received badge  Nice Answer (source)
2012-12-12 05:37:00 +0200 commented answer How Can I copy paste Calc formulas with absolute references

Nifty! I've always removed the = sign to deformularize, but inserting a character is more elegant as it simplifies the reversal if you're copying (and pasting) a table of formulae. Natürlich care is taken that there's no conflict in the formula that would interfere with the bulk "Find and Replace."

2012-12-12 04:14:36 +0200 answered a question How Can I copy paste Calc formulas with absolute references

I'm getting a somewhat different take on this problem than either of my international counterparts. My question for Rainer is, "Why don't you change the absolutes to relatives and let the problem solve itself." Well, at least partially.

In your formula you have the SheetName referenced as "$Tabelle1." The default in LibreCalc makes that an absolute reference, forcing the program always to look back to the original source workbook. Remove the reference-lock ($) so the formula reads simply "Tabelle.1" and when you paste into the destination workbook, you'll have a relative reference which looks for the data in a comparable sheet there.

But we're not done yet. What is meant by a "comparable" sheet? The receiving sheet (where you will paste the formulae) must have the same relative positioning in both workbooks. In the source workbook let's suppose the sheet from which you are copying is separated from Tabelle.1 by two other sheets. In the destination workbook, the sheet into which you are pasting must also be separated by two sheets from the worksheet equivalent to Tabelle.1 -- in the same relative position.

Spread the joy!

2012-12-07 02:42:55 +0200 received badge  Teacher (source)
2012-12-05 02:15:19 +0200 answered a question calc sorting incorrectly

I mentioned it in my comment. But it's true. If 467 is actually .467 but formatted so the decimal doesn't show, the sort would be correct. Perhaps pepsimax has presented us a puzzle posing as a problem. But I hesitate to call a user's seriousness into question. Instead I'll suggest pepsimax call up Format > Cells > Numbers > Number for that particular cell, and check the Format Code field to make sure the format hasn't been corrupted and there has been no "User-defined" tampering.

2012-12-05 00:13:02 +0200 commented answer calc sorting incorrectly

Ctrl-F8 is a neat feature. Color my spreadsheets blue black and green. Thanks JS. I tried to replicate pepsimax's sorting problem in Libre using text as well as numeric. The text sorted as expected (leftmost character). Could 467 be .467 with an invisible decimal? Yes, absurd, but....

2012-12-01 07:44:19 +0200 commented answer paste special should start empty

My answer was intended to be constructive... to point out a more effective way to address the issue. And yes, in "8 clicks" there's a good discussion about how to file an Enhancement Request.

2012-12-01 00:53:36 +0200 answered a question paste special should start empty

Matter of opinion how the defaults should be set. I tend to go with what I'm given, and hope I can influence a change if I think it's needed. There seem to be some users who agree with you. But what you want is a feature change, and this site is mostly for "How do I..." questions. Please click the following link and read cloph's excellent response which elaborates the difference.


2012-11-30 20:50:45 +0200 answered a question How to Paste Special without 8 clicks the 1st time

Macro idea works, but you have to do a number of "finger exercises" -- clicking or keystrokes -- to activate the macro (see my unanswered question on assigning a macro to a menu: click here).

I believe you are trying to copy formulas which have resulted in numbers. Perhaps... A) The formula may be complicated, or B) You're pasting in another section of the sheet (or in a different workbook) where the formula references won't apply, or C) You simply want "hard" numbers to work with.

I do this all the time. I haven't found a way to change the PasteSpecial defaults in my version of LibreOffice Calc, but there are some "best practices" you can apply which will simplify.

Probably you are too strict in choosing your criteria in the PasteSpecial dialog window. Leaving some of the items checked doesn't interfere with the hard-pasting of numbers. The only changes that really need to be made are 1) uncheck "Paste all" 2) check "Numbers" and 3) uncheck "Formulas." Click "OK" and you're done!

To ease your way further I'll emphasize key-strokes instead of mouse-clicks. This will save you from carpal tunnel agony in your clicking finger. Begin by using Ctrl-Shift-V to open the PasteSpecial dialog. Then press the following sequence of keys.

Space-Down-Down - Space-Down-Down - Space - Enter

Space is of course the Space bar. Down is DownArrow. Enter is itself. If you can do this musically (i.e. a drum pattern) it becomes almost fun. It's in 4/4 time, with two sets of triplets, then a beat, followed by a final downstroke. "Space" is the snare drum, "Down" is a tom-tom. "Enter" is a base drum or cymbal. It sounds like "Rum pah pah, Rum pah pah, Rum..Bam"

Spread the joy!

2012-10-17 18:29:44 +0200 answered a question Calc: position measurements for cell-anchored jpgs

I don't want to forestall any proactive replies here. I've noted this also, and think it's a design issue (that is, I've not found a way to change it). It's especially annoying if you have a need to change row height for preceding rows in the sheet and your graphic is located, for example at row 200. The position is maintained with reference to the page, and you're required to change the y-coordinate. This would also apply to the x-coordinate for a change in column width. I will guess implementation of cell-based coordinate references is part of the plan but has not yet implemented. I don't have programming skills enough to help in that, but will be a part of the squeaky wheel.

2012-10-17 16:59:40 +0200 answered a question Excel rakam sorunu

English translation (from Turkish -- via translate.google.com)

<<<<< Excel numbers the problem: .......... Hey. Libre using Portable office. The numbers come in different forms when I save it as Excel. windows xp operating system used in the workplace. How can I solve the problem. I'd appreciate if you help. Writes instead of numbers. "0tan1aR1" [end of translation] >>>>>

I believe when this user tries to save a Calc document as Excel, the numbers convert to text formatting. I'm not familiar with LibreOffice Portable and don't use xp (if wishes were horses) so I'll leave the solution to others.

2012-10-17 05:01:28 +0200 received badge  Editor (source)
2012-10-16 23:14:35 +0200 asked a question Calc assign macro to menu

I've created a macro and stored it in a LibreOffice v. Calc module (OS - Windows Vista). I have a Menu for the macro created in the document, but cannot successfully "assign" the macro to the menu. The Path I use is >Tools >Customize >Menus. From the dropdown I select the menu where I want the macro to reside, and click >Add. The list of categories appears, and I expand +Libre Office Macros. The resulting choices are +My Macros, +LibreOffice Macros, and +"MyCalc".ods. The problem occurs when I try to select (e.g.) "+My Macros" to show the Module (and allow MacroName selection). The window goes to the "Not Responding" coloration, and I get an MS Windows dialog informing me "A problem caused the program to stop working correctly...." When I restart LibreOffice Calc, recovery is required. The outcome is the same if I store the macro in +My Macros >ModuleName or in +"MyCalc".ods >ModuleName. Suggestions please! It's a macro I would use frequently, and need the convenience of menu access.