Tag Info

Hot answers tagged

29

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


7

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


6

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


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

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


4

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


2

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


2

The question has been edited to include data in a totally different format. The original answer is below the line, and the parts of it relating to sed in general still apply. sed can rewrite lines into other formats. Here's a quick sed command to give you a CSV line per record for this new data: sed -n -e '/secs:/{s/.*secs://;H;};/position:/{s/^.*position: ...


2

First of all, less is just a pager, it is a tool that lets you read files. What you're doing is exactly the same as copying input_file to out_put.csv (cp input_file out_put.csv). You're not changing the content in any way. So, to read it as a spreadsheet using, for example libreoffice, you would need to open your spreadsheet application, then open your ...


2

After seeing your CSV output, the problem is clear: you told Excel to use CR line endings, probably because it informed you that they are "Macintosh" style. That is badly outdated information, not true for over a decade now. There are three main line ending styles: LF: The style used by Unix and all its primary derivatives, including Mac OS X. CR: The ...


1

Error 522 probably means you should enable iterations: Menu Tools -> Options Then select OpenOffice.org Calc -> Calculate and set Iterations. You cannot put a direct reference to a cell itself in the cell. You will need to make a new column (or the same cell on a different sheet) to give it a start value. IIRC The problem is that there is no initial value ...


1

The files are the same. If you open a terminal and type cat 1_CopyRow.dbf followed by cat 1_CopyRow.ods then you'll notice that they are the same. What's happening is that Open/Libre Office (I presume you're opening the .ods file using this) is formatting the file for display. 1.97101010000e+007 = 1.9710101 x 10^7 = 19710101 = 19710101.000000000 That ...


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

Try Wordgrinder. It's in the Debian and Ubuntu repos. The only one I found.


1

Word Perfect was available for Unix, at least for SCO Unix. Emacs can handle spreadsheets pretty well. Check out the emacs Wiki article on the topic. Since a traditional terminal does not have any graphics capabilities, the markup display on traditional text editors is rather limited. Emacs can nevertheless use colors to highlight text elements when using a ...


1

Can anybody remember the name of such programs which were popular before (eg. before X became so widespread)? According to this, there were barely any WYSIWYG spreadsheet editors before GUI interfaces, although spreadsheets and the processing of such goes much further back. None of those look to have been ported to *nix, perhaps because at the time no ...


1

You can probably consider the use of ted a command line .rtf file editor. It 's open source and could be compile probably with any c compiler. See http://www.nllgg.nl/ted/


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

I am working on a terminal spreadsheet based on "sc". It has undo/redo, mapping and other stuff. If interested, you can take a look at: https://github.com/andmarti1424/scim


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