Tag Info

Hot answers tagged

21

You can achieve this by either splitting or freezing the spreadsheet. These two options are slightly different, the main difference being that splitting adds a second scrollbar, viewing the same sheet from two contiguous windows as it were. How to split the spreadsheet Using the mouse pointer: Drag the little black horizontal segment that is above the ...


12

OpenOffice comes with the unoconv program to perform format conversions on the command line. unoconv -f csv filename.xlsx For more complex requirements, you can parse XLSX files with Spreadsheet::XLSX in Perl or openpyxl in Python. For example, here's a quickie script to print out a worksheet as a semicolon-separated CSV file (warning: untested, typed ...


5

I'm using Perl's xls2csv to convert xls files to csv. Not sure tho if it works with xlsx too. About: It can't be comma separated unfortunately since some columns have commas in them that's why quoting has been introduced: 1,2,"data,data, more data"


5

I take it you've got some values and you want to create a file that Excel can read. The easiest-to-create file format Excel understands probably is CSV, comma-separated values, i.e. a plain text file like this example (from Wikipedia): Year,Make,Model,Description,Price 1997,Ford,E350,"ac, abs, moon",3000.00 1999,Chevy,"Venture ""Extended ...


4

Open/LibreOffice has a comparison feature under Edit->Compare Document...


3

You can just use Debian's column. It provides the option -n which makes it work exactly how you want. Alternatively, you can put a space in the empty columns, using sed: sed ':x s/\(^\|\t\)\t/\1 \t/; t x' < in.tsv | column -t -s $'\t' example: $ sed ':x s/\(^\|\t\)\t/\1 \t/; t x' < in.tsv | column -t -s $'\t' A B C D b1 d1 ...


2

If cell A2 contains 012345678, then to get 78 to display in cell D2, enter =right(A2, 2) in cell D2.


2

As for command-line spreadsheet programs there are sc and oleo. See: sc: the Venerable Spreadsheet Calculator GNU PEM & Oleo: Two great command-line (text-based) financial accounting apps


1

LO Calc can't create a chart based on the column B's values because they are text strings instead of numerical values. This is because RIGHT() is a text function, trying to read the input as string and returning a string. The solution is just to apply to VALUE() function to the output of the RIGHT() function, so that the result of the complete formula is an ...


1

If you need to run the macros that are included/referenced in the .xlsm file on Linux then there is no software that I've come across or was able to find through searching that can do this. The major problem is that the underlying macro languages are completely different between MS Excel of LibreOffice. Without an application your next best options are to ...


1

The Debian package knows of Undo (keybinding u, see also this manpage), so maybe you can grab their source package and compile it on your system.


1

Unfortunately, Calligra does not (yet) have a filter to create/save to Microsoft formats. The only workarounds are to save in the Open Document Format (ODS for a spreadsheet) or as a Google doc. Excel 2007 or later will open ODS files, but you may need to download a "reader" file to make that work. Otherwise, you would have to go through ...


1

Using calligra you can only open ms documents, but you cannot save them in .xls , you always will have to save them in .odf(Open document format). Sorry to be the bearer of bad news but that's one of the important functionalities that is missing in calligra. You can use this url to know more about it : ...


1

I don't know if understand what to want to achieve, but perhaps this awk program is useful for you: Content of script.awk: { ## Number of blocks printed to output. block = 0 ## Get number of columns searching how many tabs exists in the line. ## I substract one because each line has a tab at the end and splits ## function count blank ...


1

If you have the time and know a bit of Perl you could create your own tool in an hour or two. If XLS rather than XLSX, then example on the Spreadsheet::ParseExcel page will do a portion of that you want, walk every cell, sheet by sheet and row by row in a workbook, if you need the XLSX support see the links on the page. Anyway a simple tweak to open a ...


1

https://github.com/dilshod/xlsx2csv Worked well for me. About 85 MB XLSX file converted at about 3 minutes on a Mac Book Pro SSD.


1

I use PHP. Just instal the PHPExel library from http://phpexcel.codeplex.com/ and probably you need XML functions too. This is my code : <?php error_reporting(E_ALL); date_default_timezone_set('Europe/London'); /** PHPExcel_IOFactory */ require_once '/home/markov/Downloads/1.7.6/Classes/PHPExcel/IOFactory.php'; $file="RIF394305.xlsx"; //PATH TO CSV ...



Only top voted, non community-wiki answers of a minimum length are eligible