Re: [libreoffice-users] Calc. extract values

At 15:39 28/07/2015 +0900, Howard Barr wrote: I have calc sheet with 4 columns A1 is Date, B1 is Vendor, C1 is Item, D1 is Cost. I would like to extract the accumulated expenditure of an item and display it in F1. There are over 1,000 items. If I understand you correctly, =SUMIF(C2:C2000;Item

[libreoffice-users] Re: Calc. extract values

Am 28.07.2015 um 08:39 schrieb HBarr: Hi, I have calc sheet with 4 columns A1 is Date, B1 is Vendor, C1 is Item, D1 is Cost. I would like to extract the accumulated expenditure of an item and display it in F1. There are over 1,000 items. Help greatly appreciated. Hbarr

Re: [libreoffice-users] LO Draw to PS shapes

Hi :) Inkscape has a lot of formats by default but i don't remember noticing .csh. Perhaps an add-on / Extension / plug-in? Interesting to hear Photoshop is so limited. Can it not handle standard formats such as .Svg or .Eps? It's not hugely surprising to hear it can't cope with Open Formats

[libreoffice-users] SQL Database Recovery

Advances SQL Database Recovery http://www.softmagnat.com/sql-database-recovery.html software is an advanced solution to fix extremely corrupted MDF files of MS SQL Server. It also helps to get back all the SQL components like Stored Procedures, Triggers, Primary Keys, Unique Keys, Foreign Keys,

[libreoffice-users] Re: Export HTML links in Calc sheet

The way I found to tackle this was to save the LO Calc doc as HTML, from there using Kompozer (html editor) arrange the doc to fit on an A4 sheet properly. Afterwards use Chromium to export to PDF. This was I get the URL links in the PDF. It would be nice if this feature could be included

[libreoffice-users] LO Draw to PS shapes

Hi,Does anyone know of a free app that can convert vector graphics from Draw into Photoshop Custom Shape format (.csh)? Draw doesn't export .csh directly; I did a quick web search but couldn't find anything useful. /Gary -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org

Re: [libreoffice-users] Re: Hourglass/Pause When Scrolling in LO Writer

Ah, I think I know what the problem is ... I'd forgotten that LO's default is to save every few seconds ;-( I reset mine to never automatically save because (1) it's so frustrated being in the middle of a thought when the program decides to save; and (2) it

Re: [libreoffice-users] Question about LO Writer and complex documents

One of Charles Lutwidge Dodgson's, Lewis Carroll, purpose in writing the Alice in Wonderland books was to show how the meaning can be misinterpreted when proper grammar is not used. My favorite example is Jabberwocky ;-) Without good communication skills, then how can anyone be a

Re: [libreoffice-users] Returning to the previous position in a document after reopening [was: Question about LO Writer ...]

On 7/26/2015 11:46 PM, Thomas ny...@hb.tp1.jp wrote: It had a very simple AND convenient function of inserting a quick mark at the cursor position whenever you save a file. As has been pointed out already, Libreoffice does this now (when you SAVE it), as long as you have personalized it in the

[libreoffice-users] Calc. extract values

Hi, I have calc sheet with 4 columns A1 is Date, B1 is Vendor, C1 is Item, D1 is Cost. I would like to extract the accumulated expenditure of an item and display it in F1. There are over 1,000 items. Help greatly appreciated. Hbarr -- To unsubscribe e-mail to: