Hot answers tagged

44

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


17

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


13

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


8

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


7

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 Edition""","",4900....


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

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


4

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.


4

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


4

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


3

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


3

You need to specify the range: =SUM(B2:B8) (in B10). As explained by Mark Stewart, SUM(B2,B8) is equivalent to B2+B8 — you'd use that form of SUM() if you had a specific list of disjoint cells to add (or disjoint cell ranges).


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

The keyword my declares local variables. Therefore, $workbook is local to the body of the following if: if($yes eq "y") { my $workbook = 1; } You could get the scoping that you are looking for by declaring $workbook before the first if, as my $workbook, and then, inside the if or elsif blocks, assigning to it without declaring a new variable ($...


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

Step 1: join the files in a multicolumn file: paste f1 f2 f3 > _1.tsv Step 2: add a formula to calculate the sum: gawk '1;END{for(i=0;i<NF;i++) {printf("=SUM(%c1:%c%d)\t",65+i,65+i,NR)} print ""}' _1.tsv > _2.tsv Step 3: inspect the result $ cat _2.tsv 100 100 100 ... 99 99 99 =SUM(A1:A5) =SUM(B1:B5) =SUM(C1:C5) $ ...


2

Try this: In cell C2 enter 2 and in cell C3 enter 3. In cell C4 enter =SUM(C2:C3). The result (which I tested to make sure) should show as 5. If this worked, then check what is in B2 through B8 to make sure that they are all numbers and that they add up to an integer other than zero. For example, one way to end up with 0 is by summing 0.1 and 0.2 and ...


1

If adding one cell value is acceptable: enter the conversion factor in any empty cell (even on another sheet), select Paste Special, and select the approrpriate calculation below of Transpose. E.g., to convert between inches and centimeters: enter the factor 2.54 in an empty cell; copy that cell; select the values to convert; Menu Edit -> Paste Special; ...


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


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

scim seems good indeed! To help some new users to fix quickly the backspace key, look for the macros.h file. Define MACOSX value then launch make. Just as easy! To seek help within the program, enter :help and read the documentation. Have fun using spreadsheet in your terminal!


1

scim is the best command line spreadsheet right now. It compiles easily on OSX. You have to make one modification to the source code to fix the backspace key on OSX. https://github.com/andmarti1424/scim


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


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

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



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